Forum Discussion
2016 Excel Copy Same Cells from Multiple Sheets onto one Sheet
Hello, can you send me instructions on how to use INDIRECT formula?
Thanks
Hello again, I don't think you need Indirect for this. It should not be used if it can be avoided.
With the fixed cell addresses, you can manually set up the references to the cells. The format for this is
=SheetName!Z$28
or, if the sheet name has spaces, you need to wrap it in single quotes, like
='Sheet Name'!Z$28
Enter the first formula, then copy it down, adjust the sheet name in each row. Then copy to column to the right and adjust the cell references. Now you can change the data in the original sheets and the formulas will update to show the current content of the cells.
I'm attaching an example for you to inspect. Let me know if that helps
Your example looked like exactly what I want to do, but I am not quite sure on how to do it. is there a way to set formula where it will pull information for each day/column with that formula and get information all at once.
Do you happen to have a YT video that shows how to do it? I learn better by seeing it.
Thanks!
I don't have a video for that scenario, but the steps are easy.
Click the cell where you want to see the result
type a = sign
click the sheet that has the value you want to see
click the cell that has the value you want to see
Hit Enter.
The cell now has a reference like =Sheet2!A1
Repeat for all other cells.
Thank you. I tried this, but i was only able to do one sheet/day at a time. is there a way to get all days in a month show up in a column?
Thank you for all your help!