Updating Master Workbook using User's Worksheets

Hello Everyone,

Im looking for some code examples so all users can all update an assigned excel spreadsheet at their leisure f (make changes/edit etc). Im having a little bit of difficulty finding documentation on this (how to's).

1. Each User would have their own copy of the original document
2. When a user makes a change, they will save a copy and email it to me and I will update the master document by hopefully some type of script.
3. This is to alleviate the problem of having multiple users only having access to the document, one user at a time.

The users Worksheet will be laid out exactly as mine and the worksheets will have the same title. I want to be able to open their worksheet and my master and take the data from their file and update mine. I have over 300 worksheets so a simple (='s) does not work b/c of time.

Basicall I'd like to hit a button so that when the spreadsheet is closed or a button such as "UPDATE" is hit on the master, the main spreadsheet would sync his projects back in, with the new data.

I WILL PAY SOMEONE $200 if you have a PayPal account to help me with this and your example is sufficient.

Thank you in Advance!!

Hi - I'm working on something that sounds similar. I have a 'master' file for supervisors. I split the master workbook into many workbooks. I send it out, then they up date their workbook and hit a button and email's back to me.

Then I follow that up a routine that picks them up from my outlook folder and copies them to a network folders. That is followed by a routine that will combine all workbooks on one folder to one master csv file.

So each workbook is append. I'm not sure if that would help but I could send you copies of the vba codes and then you might be able to tweak them to your needs? Let me know...

Thanks Ironman,

This sounds very close to what I want to do...have you ever heard of the program Distributed Spreadsheets? I want to basically do what that program does and instead of appending a file be able to take user provided data that is in a worksheet that is laid out in the same format as my master worksheet....when the user finishes inputing data they save the file and send it back to me...I then want to be able to run a macro that will take the data from the users worksheet and paste special it into the appropriate cells in the master worksheet. Both worksheets can have the same name if this helps or have different names.

Does your solution do this? If so I would love your help and would be happy to compensate you for your assistance.

Thanks

Hello Everyone,

I'm still in need of help badly on this problem and also ran across an article that discussed using multi-thread code? In any event if anyone can assist it would be greatly appreciated.

Thanks!!

ExcelConsult - Not sure if I can help...the code I have takes 100 rows of data (for example) splits it out to 5 workbooks and eamils them out...then upon return I put it all back together.

I do love hard cold cash...but no need for payment, this is afterall, what the forumns are...most of what I have I've googled, asked and otherwise got help putting together, so it would be completely wrong....

You might however be able to read or inturpt what I have, I might be able to send you a file that has all the 'steps' in vba code...can you send me a private message?

For the forumn modirators out there, if this is against the 'rules' just let me know and we'll figure out another way...

I have a similar situation with the file I'm working on. Can you please share the VBA code that you created? thanks