HELP. Open one workbook and copy info from there to another workbook

monkeyspank

Board Regular
Joined
Feb 12, 2014
Messages
73
I have a folder that I will place multiple worksheets and just one range(a2:i2) of information copied from each worksheet to a master workbook. After it is copied I would like the workbook that the information was copied from moved to an archived folder so that new ones and old ones wont be in the same folder. Also, I need the master workbook to recognize that new lines of data are being added to it and update accordingly by adding the new line of data . I have place the master workbook in folder of is own, is this necessary? And, is this possible for all this happen without opening the master file or does it have to be a button? What would the code for the button look like?

Can anyone help?
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Forum statistics

Threads
1,226,498
Messages
6,191,376
Members
453,655
Latest member
lasvegasbuffet

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top