Copying Data/Formula

  • Thread starter Thread starter Kristi
  • Start date Start date
K

Kristi

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--
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Highlighting duplicates 0
Retain INDIRECT() Data 2
Linking to combo box selection 2
Compile data from several workbooks 1
Link To File That No Longer Exists 1
How to copy & paste a worksheet but change 1 bit of the formula? 1
Macros 2

Back
Top