Help with updating spreadsheets simultaneously

[rramoutar7]

Hi guys,

I have two spreadsheets with similar information. The first is a list of names and projects, the second has the list of names and projects corresponding to the first, but also contains hyperlink linking each project to a specific folder on the system. The first spreadsheet is updated regularly, while the second will not be. However i would like a way to keep the second spreadsheet automatically updated along with the first, so that when the time comes to update the second spreadsheet to correspond with the first, the person who is updating (not necessarily me, hence why I will need to keep it as updated as possible) will not have to manually compare the two spreadsheets and fill in the new information from the first spreadsheet to the second. I was thinking something similar to the 'Group' command but more dynamic. Maybe a button to click update when a new row/new cells with information is added to the first spreadsheet, that maybe looks for something like an empty cell (signifying new row/cell) or a string (signifying the new information) or something? Is this too complicated?

Reesha

[arlu1201]

Will the 2nd file be open at the time when the user is updating info in the 1st file?

Or do you want the macro to open the 2nd file, update the info and close it?

[rramoutar7]

Open, update and close please so sorry for the late reply!

Reesha

[arlu1201]

Do you have a sample of both the files which you can upload?

[rramoutar7]

here you go!