I have a master Excel doc that pulls data from 14 sub files. I need a way of resetting the data on the sub files by way of macro or script. Further explanation: 14 agents input data on their spreadsheet. Owner of master doc currently clicks a button that pulls data from their sheets and copies all their data into the master doc. The data on the agents worksheets is now redundant and not needed. I need someway of resetting the agents data from the master doc. So 1 file will be resetting the data of the 14 sub files. This master doc will be used on other servers, so a simple macro probably wont do the job as it needs to be universal. Help appreciated.
-------------------- You can't beat an egg!..............no wait!!1
I presume that this is a business application. This forum is for personal users only.
--------------------
Do you know that we're all in line for succession to the throne? Really?
Well, if forty-eight million, two hundred thousand, seven hundred and one people died I'd be Queen.
Previous
Index
Next
Threaded
Edit
Reply
Quote
