I'm not clear on how you want to increment your numbers for RED and CARS.
Are they incremented separately or pairwise?

Barb Reinhardt

"Aikisteve" wrote:


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?


--
Aikisteve
------------------------------------------------------------------------
Aikisteve's Profile: http://www.excelforum.com/member.php...o&userid=36111
View this thread: http://www.excelforum.com/showthread...hreadid=565964