BrianExcel
Well-known Member
- Joined
- Apr 21, 2010
- Messages
- 975
Hey folks,
I am trying to pull in data from a sheet in one workbook to another sheet in a different workbook. Neither is protected in any way, but I'd like to program code into a button (or into workbook_open) so it automatically pulls the information in.
I've searched online but haven't found much that walks you through how to do this step by step. Can anyone assist?
For simplicity, let's use workbook1 sheet 1 as the source, and workbook2 sheet 2 as the destination. Ideally I'd like to use the .End(xldown) code as well so it automatically looks for the end of the data instead of hard coding A1:E500 or something.
We'll say for example sake that both workbooks are located at c:/brian
Can anyone point me in the right direction?
Thanks!
I am trying to pull in data from a sheet in one workbook to another sheet in a different workbook. Neither is protected in any way, but I'd like to program code into a button (or into workbook_open) so it automatically pulls the information in.
I've searched online but haven't found much that walks you through how to do this step by step. Can anyone assist?
For simplicity, let's use workbook1 sheet 1 as the source, and workbook2 sheet 2 as the destination. Ideally I'd like to use the .End(xldown) code as well so it automatically looks for the end of the data instead of hard coding A1:E500 or something.
We'll say for example sake that both workbooks are located at c:/brian
Can anyone point me in the right direction?
Thanks!