| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying filtered data to another Excel Spreadsheet
When you paste, the data is pasted into a contiguous block of cells,
even if columns or rows in that range are hidden. Perhaps the hidden columns in the destination workbooks could be moved to the far right of the table, so they don't interfere with the copy and paste. wrote: Hi, I tried it, and it still gets gets messed up by the hidden columns. Thanks though! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| create excel spreadsheet on a data access page | Excel Discussion (Misc queries) | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
