updating the master workbook whenever user click submit in check workbook

**share knowledge** · 04-11-2011, 03:44 AM

Hello all

Attached are the 2 workbooks I am working on – Check and master.

Check – many users will use this sheet. When they click submit I want the datas to get updated in the master workbook (not all but according to headings listed in the master)

Master – info in the check workbook should get placed here

Is it possible to have a code to do this activity?

Thanks much

**Dave H9** · 04-11-2011, 07:34 AM

Try the below and assign SubmitInfo() as the button macro. You will need to specify the correct file path in the WriteToLog subroutine for the code to work on your machine (I have commented the line).

Please Login or Register  to view this content.

This code was developed thanks to experienced contribuors to this site so hopefully it works for you.

**Dave H9** · 04-11-2011, 08:04 AM

Apologies, in heinsight it is probably easier if I post the amended workbooks

Hope it works for you (you will still need to amend the file path as above.

**share knowledge** · 04-11-2011, 10:42 PM

this is brilliant

thank u dave

)))))))))

updating the master workbook whenever user click submit in check workbook

LinkBack

Thread Tools

Rate This Thread

Display

updating the master workbook whenever user click submit in check workbook

Re: updating the master workbook whenever user click submit in check workbook

Re: updating the master workbook whenever user click submit in check workbook

Re: updating the master workbook whenever user click submit in check workbook

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions