I have several workbooks that I need to link to a main workbook. Is there an
"easy" way to pull the data from one workbook into the main workbook? I know
how to link them, but I need to link the entire workbook. I have been going
cell to cell using the sum function, clicking into worksheet 2, then enter,
keeping the data linked to that cell. However, there are so many cells, that
it would take a couple of days to do it at this rate. Thanks for any help.

See if this works for you:
http://www.rondebruin.nl/copy2.htm

Scroll down until you see section named 'Copy from row 2 till the last row
with data'

PS, make sure you copy the function named 'Function LastRow(sh As Worksheet)'


Regards,
Ryan--

--
RyGuy


"Kristi" wrote:

I have several workbooks that I need to link to a main workbook. Is there an
"easy" way to pull the data from one workbook into the main workbook? I know
how to link them, but I need to link the entire workbook. I have been going
cell to cell using the sum function, clicking into worksheet 2, then enter,
keeping the data linked to that cell. However, there are so many cells, that
it would take a couple of days to do it at this rate. Thanks for any help.