Forum Discussion
Question on a type of text linking between sheets
Hi, I'm trying to work out how I would copy text live from one sheet to another.
Essentially what I'm trying to do is create a meeting minutes template that automatically puts yesterday's actions onto today minutes without having to copy and paste it. Only condition to end this (and to prevent it pasting across all days of the month) would be crossing it out with ctrl+5 once the action has been completed.
The setup I have is a sheet for everyday of the month, each with their own actions box on identical coordinates. It's not the only thing on the sheet but it's the bit I'm trying to make easier.
Is there any way I could do this? I'm not particularly experienced in excel so I'm hoping it's not too complex.
Image of the actions section plus sheets.
now it looks like your data is in cell E7 but I also realize my trick won't work because of circular reference (I use it for pulling prior total to new page starting value but here you are looking at the same cell).
So that said, you'll need to use =1!E7 on page 2 and =2!E7 on page 3 and so on
3 Replies
You can simply put in
=5!G7
in to the corresponding G7 cell on sheet 6 but note this does NOT copy the data over it just SHOWS the data from the prior sheet (as referenced) in this cell. Then for items done you can delete/overwrite those cells. To Modify an item you will need to COPY and PASTE VALUES ONLY and then you can modify.
This may be tedious to apply to all 30 sheets but once you do it once you have a 'template' for each month.
Alternatively you could highlight all sheets from sheet 2 to 31 and then use a formula like:
=INDEX(VSTACK(1:30!G7),SHEET()-1)
and then you can copy/fill down and over as needed
(note you might need a refresh/calculate now after the copy/fill for it to update)
Thank you for your solution and formula m_tarler. :)
Am I doing this right? I've got it copied across sheets 1 to 31 with some data on sheet 1 and it's providing me with "0" no matter the data on the previous sheet. I'm definitely missing something here. I've also refreshed it. What's going on?
now it looks like your data is in cell E7 but I also realize my trick won't work because of circular reference (I use it for pulling prior total to new page starting value but here you are looking at the same cell).
So that said, you'll need to use =1!E7 on page 2 and =2!E7 on page 3 and so on
