auto copy data entered to a main spreadsheet

J

Jerry

Is there a way that an excel file can be setup to
automatically copy a record, when it's entered, to a
master excel file? This would be data entered on multiple
sheets and by multiple users. Also, can more than one
file copy records to the master file. thanks.
 
D

Dave Peterson

I don't think I'd do anything like this automatically.

If the user made a typing mistake, it would be a pain to make sure that the bad
record is dumped and the good record is added.

I think I'd let the input go to each separate sheet and then when I was happy,
I'd grab the data and plop it onto a master worksheet. I could destroy and
rebuild that master worksheet whenever I wanted.

And to keep that data in multiple versions of the same workbook would become way
too difficult for me. But keeping each worksheet as a separate workbook
wouldn't be so bad. Just merge all the worksheets into a different summary
workbook/worksheet. Make all those separate versions available for merging
(same network drive??) and it might even work.
 
Top