A little video about how to use Microsoft Excel to set up tracking code URLs for Clickbank with some tips on how to stop the formulas from auto-iterating when using the auto-fill handle feature in Microsoft Excel by using the $ operator in the formula.

If you have a difficult time watching the video here, please go to YouTube and view it in a larger size there.

The main reason for the video is that I was having a lot of difficulty yesterday getting this Excel spreadsheet to work the way I wanted it to, so I did some research and found the solution. I’m certain if I had difficulty figuring this method out, there are others out there who have had similar experiences. By recording this video, hopefully, I won’t have to “figure it out again” either - I can just come back here and be reminded how to do it *grins*

A very quick summary of features covered in the video:

• Use the & to append multiple cells together - for example: =c2&A4
• Use the $ to freeze a formula on one cell in the spreadsheet - for example =$C$2 to hold the formula on that cell while using the drag autofill feature in Excel

I hope you guys find this useful, please let me know what you think!