I've a (for me) tricky problem.
Situation:
- Several people have their own workbooks on a shared network drive, and continually updating text data
- Added complication is that these people can add rows to their text data so the range is not always the same
- One person has to collate all this data/updates into one summary workbook and print off regularly for the VP.
Questions:
- Please help us figure out how to do this?
- There must be a way to link to the text range in each individual worksheet so it updates in the main summary workbook?
I'm unfamiliar with any Excel programming but, with clear and "idiot-proof" instructions am sure can figure it out.
Thanks very much for any help or guidance you can give me... I'm under the gun here ...
Cheers, Susan
Bookmarks