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