[video]http://www.youtube.com/v/3KORGsUcReM[/video]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!