Posting data once for two spreadsheets

[andirobinson]

[Excel 2010] I have two different spreadsheets that will need to have the same information put on one page in each workbook. Is it possible to link the worksheets so that I only have to enter the information once, but it will be in both places? The one workbook has worksheets that have information from all of the sheets rolled up into one summary worksheet, so I don't know if that complicates things.

Thanks.

[MarvinP]

If you select two tabs (ctrl Click a second tab) the data entered on either will be entered on the other too.

I saw this is a Mr Excel video. He recommended against it unless all your sheets are exactly alike.

Are your two sheets alike enough to have this work for you?

I'm a little confused on if the two places you want the data is on separate spreadsheets, workbooks or worksheets. Without seeing an example it is hard to tell your requirements. Will copy and paste using the windows clipboard work?

[smalls]

Agreed with MarvinP on the clarity. If you are talking about two worksheets (tabs) in the same workbook, it should be fairly simple to execute. But are you talking about two completely different workbooks (two different ".xls" or ".xlsx" files)?

Knowing this information would help in order to provide an answer.

Cheers

[andirobinson]

Two different workbooks. The pages in question would look exactly alike, except for the fact that some of the data in one of the workbooks is references on another sheet within that same workbook (on a page summarizing data).

[MarvinP]

I still don't have enough information to make a good guess.

I'm thinking you have a workbook with Account or Month worksheets. You have another workbook that has all the Accounts or Months as worksheets and a summary sheet to total all the sheets. You have someone work on the Account or Monthly workbooks individually and they give them to you at some ending date. You want to copy their work over to your summary workbook and get a grand total.

If the worksheets look exactly the same in both their and your workbooks, you should be able to simply Copy and Paste using Windows Clipboard. This is dependent on formulas that work on theirs and not your workbook. Paste vlaues only may be a solution.

I'd love to help but need more info. Perhaps a "Go Advanced" and upload two workbooks to show us what you require? Use the paperclip icon to attach files.