I Have a spread sheet set up whereby i have vlookups and if functions (tied to hyperlinks). These all work fine and dany, BUT they have to be tied to a certain cell (don't they?) i.e. a3, b3, c3 etc. My problem is that this spreadsheet could run into the 1,000's is there any way to avoind having to copy this onto every line?

Also, is there a way to generate sequential numbers that can be split. For example if I wanted

Red, 3, Cars = 0001 then if it happenes again =0002 etc?

but if

Red, 2, cars = 0001 (not 0003)

Is there any way to do this?