Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Read write non contiguous cells
Hi All!
I have several sheets in a wkbk where the user enters data in fixed cell addresses. Cells are non contiguous. I want to read the values from each sheet and cell and compile a tabulated summary report on a "Report" sheet in the same wkbk. Each sheet results to be on a separate row. Using office 2000 Thanks in advance for any assistance sgl |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
OLAP write back via formulas (functions), not read only pivot tab | Excel Worksheet Functions | |||
write a formula to sum cells on different pages of the same workb. | Excel Worksheet Functions |