Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help: Copying Visible Cells only to Visible cells!
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Visible Cells in Sheet with Merged and Hidden Cells | Excel Discussion (Misc queries) | |||
Copying visible merged cells | Excel Discussion (Misc queries) | |||
Copying and pasting to visible cells only | Excel Discussion (Misc queries) | |||
problem copying visible cells from 2000 to 2003 | Excel Discussion (Misc queries) | |||
Copying visible cells only on a protected worksheet | Excel Discussion (Misc queries) |