My reason for wanting this system is to provide pre prepared workbooks for
12 months for a relative to make as easy as possible for her to keep her
records without being afraid of Excel.
I have two monthly workbooks running identical accounting sheets.
I want to bring forward the balance showing in cell E33, sheet 'Bank' in
workbook March.xlsx to cell C4, sheet 'Bank' in workbook April.xlsx.
Is this possible? I have my doubts... I have tried all I know wthout
success.
Can anyone help me?
Ed
='[March.xlsx]Bank'!$E$33
If you now close the March workbook the formula will expand to show
the full path to the March workbook. If you want to copy the two files
across to your relative's PC, you must ensure that they are located in
an exact folder location - it might be best to set up a sub-folder
from C: drive, so that the path is something like:
='C:\Temp\[March.xlsx]Bank'!$E$33
Hope this helps.
Pete
On Feb 19, 3:17 pm, "Edward" <edward.j.obr...@DELETEbtinternet.com>
wrote:
Many thanks,
Ed
"Pete_UK" <pash...@auditel.net> wrote in message
news:fa1efc4d-53b9-48c6...@e18g2000vbe.googlegroups.com...
Pete
On Feb 19, 4:26 pm, "Edward" <edward.j.obr...@DELETEbtinternet.com>
wrote: