Forum Discussion
2016 Excel Copy Same Cells from Multiple Sheets onto one Sheet
Hello,
can you describe the scenario in a bit more detail?
Is it the same cell on each sheet? Like A1 on each sheet? Is it the same cell each day, or will tomorrow use a different cell?
If it is the same cell each day, you can use a simple reference to the cell. In your target column, select a cell, type a = sign and then click to the sheet and cell you want to copy, then hit Enter. Repeat for all 31 cells on all 31 sheets.
If it is a different cell each day, please provide more detail about how you identify the cell to copy.
i have 8 cells in one row that are all data sets for each day: new admits, re admits, discharges, etc.
I would like to get information from each day easily onto one sheet to have all days with information in columns for each category and rows for data on each day.
HOPE I AM MAKING SENSE :)
Below is a row that i copied and pasted for one day. All 8 cells are exactly the same cells each day which are:
Z28 AA28 AB28 AC28 AD28 AE28 AF28 AG28
| 114 | 1 | 1 | 2 |