Automatically Copy Data to Specific Worksheet

Hello,

When I put monthly data into a spreadsheet, I also put the same data (in the exact same format) into several other spreadsheets.

Is there a way that I can save myself time by having the data automatically copy into the specified spreadsheet or worksheet?

Thanks

Hi
Yes you can create links in each of the required cells from your main spreadsheet such as:

=[Workbook Name]Sheet Name!$A$1

Every time the source cell changes the linked cell will automatically update even if it is closed.

Bear in mind that all linked workbooks need to be on the same network.

Good luck.
Tony

Hi Tony, thank you for that! I am going to try it out.
This could potentially save me a lot of time, I really appreciate it.

Thanks.

Hi Tony. I actually can't seem to get this formula to update when changes are made in the original cell. Any ideas?

Nevermind, got it! Thanks again!