i think i just need the formats, i.e. if their are 10 data files in
column a then there will be 10 in column c and so forth. i need all the
columns (a,c,d) to contain the same number of files as column b. but in
my spreadsheets the number of files in the column will change i.e.


sheet 1 col a 2330 files
sheet 2 col a 1870 files
sheet 3 col a 1500 files


also these numbers will change in the future.


--
speary
------------------------------------------------------------------------
speary's Profile: http://www.excelforum.com/member.php...o&userid=24959
View this thread: http://www.excelforum.com/showthread...hreadid=385229