Copying worksheet (containing formulae & data) to another workbook, to use for the next yr

[PurrSent]

Hi

Using Excel 2010 on Windows 10

I have a Workbook for 2018, Sheets are Jan - Dec, ie 12 sheets, plus a sheet containing data, ie named payees (income) and recipients (outgoings), that has been 'entered' from the previous month, plus manually entered too.

There is a 'Master' sheet which takes this above data from Dec 2018 sheet, ie sources re Income and destinations re Outgoings. The formula in 'Master' sheet is, for example "{=Dec!C16}".

I thought I'd copy this 'Master' sheet, which contains data that needs to be continued into Jan sheet of the next year, ie 2019, and paste into a new sheet, named 'Master2018' . Then, in Jan (2019 Workbook) I thought I could use a similiar formula to catch that 2018 data, and have it displayed in the Jan 2019 sheet, then be ready to continue with the 2019 accounts.

So -
- I entered '=' into the first required cell in the Jan 2019 sheet,
- clicked on the relevant cell in the new 'Master 2018' sheet,
- then clicked 'Enter' (also tried Shift+Ctrl+Enter)
- the formula showing was "='[P****Accounts 2018 Rev 8-12-18.xlsm]Dec'!C16"
- but, the data in the cell in Jan (2019) is "='2018'!B6" rather than the data, which should be a name, ie Joe Bloggs.

I've clearly not done something correctly, due to my limited knowledge. I hope you can understand my post / scenario

Could someone please help me and let me know how I can achieve this, please?

I appreciate any help. Thanks very much

 

[Logit]

Top of page. THREAD TOOLS

 

[PurrSent]

Unfortunately, when I click on Thread Tools, I don't see an option to amend the Subject line. The only options I see are -

Show Printable Version
Email this Page ...
Unsubscribe from this Thread

Am I missing something ... ?

Thanks

 

[Logit]

.
Hmm ... must be a glitch in the Forum server. That specific menu selection should be there.

You can contact one of the Administrators and ask for assistance.