I have a master workbook with manually entered data. This data needs to be entered to different extents in four other dependent workbooks. To avoid the possibility of human error over time, I'd like to use VBA within the dependent workbooks to call up data from the master workbook and enter it automatically. Where should I start looking to learn how to do this?
Populating dependent workbooks with data from master workbooks
- Thread starter PipBoy808
- Start date
Perhaps some of the code examples on Ron's site will help you out. He's done extensive work on copying/paste to different locations.
http://www.rondebruin.nl/win/section3.htm
http://www.rondebruin.nl/win/section3.htm