Copy different sheets into master
Posted by Jo on January 17, 2002 6:53 AM
If I have different workbooks (for each job we do) showing when I send something out for approval, is there a way I can have the info copy over to a master calander (next empty line down) so I only have to open one file each day to see what's overdue?
Posted by Damon Ostrander on January 17, 2002 9:24 AM
Hi Jo,
It is quite easy to copy data from one workbook to another, or to modify a master workbook based on information gathered from other workbooks, and also to find the next available row in your master (using the Range object's End method). But you will need to provide more specific information about your problem in order to get more specific help.
Damon
