Forum Discussion
2016 Excel Copy Same Cells from Multiple Sheets onto one Sheet
Did you try using INDIRECT formula? You can get whatever data you need from whatever sheet you want with this formula.
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!
