Hi,

I need to transfer many different cells worth of data from man
different "Spares" workbooks into one "List" workbook.

I need this function to be automatic when the user clicks on
selection of buttons on "List". There will be different button
relating to the the different "Spares" workbooks that the data will b
taken from as not all of the "Spares" workbooks will be required all o
the time.

I also need the function not to overwrite any data already entere
either directly by the user or automatically into "List" from th
"Spares" workbooks.

I understand there is the ISBLANK function but I am usure how to use i
in this case.

Also the formatting of "List" is over three colums:
"Quantity", "Description" and "Part Number"
and does not start on cell A1.

A long question I know, but any ideas?

Thanks
Susi

--
Susie
-----------------------------------------------------------------------
SusieQ's Profile: http://www.excelforum.com/member.php...fo&userid=3081
View this thread: http://www.excelforum.com/showthread.php?threadid=50483