J
Jay Jayakumar
There is a workbook which has many worksheets, each of
which is similar in looks, with many levels of "subtotal"
rows. Imagine looking at the highest summary level, where
there are "+"s in the left of row numbers. The first
column has row titles. Sometimes, the user changes some
row titles at this high level. She needs to then
duplicate these changes to all the other spreadsheets. So
she would like to copy all the high level rows of this
first column, to another spreadsheet that has an identical
structure (at the high level). The key is that at the
summary level, the worksheets are identical, BUT NOT at
the details levels.
Stated in an "Excel" way, I need to copy "Visible Cells"
of one sheet, and paste to only the "Visible Cells" in
another spreadsheet. Stated in another way, I need to
copy a non-contiguous set of cells from one sheet to a non-
contiguous set of cells in another sheet.
Copying visible cells can be done using Edit, Goto,
Special, Visible Cells, as in:
http://www.inq7.net/inf/2003/jun/09/inf_21-1.htm
Assuming that I can have the user select the destination
range to be identical in structure to the original range,
I was trying to write VBA code to paste the range (which
has many areas) to corresponding "Areas" of the target
range.
How do I do it, since the user has to select copyFrom
range, then run the macro to remember the copied range,
then select the target range and continue running the
macro.
Alternatively, I need to be able to access the clipboard,
with the copied range, with all its "Areas".
I may not be saying this properly, so please let me know
if I can elaborate.
Any clues will be appreciated.
Regards,
-Jay
which is similar in looks, with many levels of "subtotal"
rows. Imagine looking at the highest summary level, where
there are "+"s in the left of row numbers. The first
column has row titles. Sometimes, the user changes some
row titles at this high level. She needs to then
duplicate these changes to all the other spreadsheets. So
she would like to copy all the high level rows of this
first column, to another spreadsheet that has an identical
structure (at the high level). The key is that at the
summary level, the worksheets are identical, BUT NOT at
the details levels.
Stated in an "Excel" way, I need to copy "Visible Cells"
of one sheet, and paste to only the "Visible Cells" in
another spreadsheet. Stated in another way, I need to
copy a non-contiguous set of cells from one sheet to a non-
contiguous set of cells in another sheet.
Copying visible cells can be done using Edit, Goto,
Special, Visible Cells, as in:
http://www.inq7.net/inf/2003/jun/09/inf_21-1.htm
Assuming that I can have the user select the destination
range to be identical in structure to the original range,
I was trying to write VBA code to paste the range (which
has many areas) to corresponding "Areas" of the target
range.
How do I do it, since the user has to select copyFrom
range, then run the macro to remember the copied range,
then select the target range and continue running the
macro.
Alternatively, I need to be able to access the clipboard,
with the copied range, with all its "Areas".
I may not be saying this properly, so please let me know
if I can elaborate.
Any clues will be appreciated.
Regards,
-Jay