information between multiple workshheets

  • Thread starter Thread starter minimoi
  • Start date Start date
M

minimoi

I have a "master" work book, and a work book for each working day.
The daily work books are shared and updated by six individual users.
I need each users information to be automatically inserted to the"master"
when saved.

All help much appreciated.
 
I hope this is to be done when you save the 'master' file. You will need to
use a macro to do this. If you are familiar with VBA try the below.

You will have to write the code in 'Workbook_BeforeSave' procedure.

'For each daily workbook
'Open daily workbook
'Get the required fields
'Close daily workbook
'Update master file fields

'Save master
 
Back
Top