Excel Tips By Bloglyne – How To Set Up Clickbank Tracking Code

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!

4 Responses to Excel Tips By Bloglyne – How To Set Up Clickbank Tracking Code

  1. Terence May 3, 2008 at 11:38 am #

    Thanks for a really useful video. I have just started to use Excel to store my Clickbank data instead of having text files all over the place and this will help immensely. I’m off to practise with it now.

  2. Vincent Sparreboom June 15, 2008 at 6:08 am #

    I have a blog with Tips and Tricks where i discus Excel quite frequently but i never thought of handling my affiliate links like this.

    Sometimes you just have to be pointed in the right direction!

    Great Tip, thanks a lot! You just got bookmarked.

  3. Joseph Murray October 15, 2008 at 3:44 pm #

    Nice post. Very informative. I’ve bookmarked it so I can follow more posts. Thanks, Joseph.

  4. Ron Davis December 13, 2008 at 4:02 am #

    Great tip bro. Real useful vide for all clickbank users.

Leave a Reply