| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy nonadjacent Autofiltered cells to another sheet
I am trying to create a printable form (Gig Sheet) that contains data from my
"Records" sheet. I want to filter the records sheet by column I and then F(Value1). Then copy Cells A?:A?,C?:C?,D?:D?,E?:E? from the result and paste them into Gig Sheet column E6:E17,C6:C17,A6:A17,D6:D17. Then I want to filter the records sheet by column I and then F(Value2). Then copy Cells A?:A?,C?:C?,D?:D?,E?:E? from the result and paste them into Gig Sheet column E19:E29,C19:C29,A19:A29,D19:D29. Then I want to filter the records sheet by column I and then F(Value3). Then copy Cells A?:A?,C?:C?,D?:D?,E?:E? from the result and paste them into Gig Sheet column E31:E40,C31:C40,A31:A40,D31:D40. Then I want to filter the records sheet by column I and then F(Value4). Then copy Cells A?:A?,C?:C?,D?:D?,E?:E? from the result and paste them into Gig Sheet column E42:E47,C42:C47,A42:A47,D42:D47. The answer is probably easier than the question. Ha |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Autofiltered rows to another workbook using macro | Excel Discussion (Misc queries) | |||
| Printing multiple nonadjacent cells on the same sheet in excel 200 | Excel Discussion (Misc queries) | |||
| Copy Results from Autofiltered List | Excel Worksheet Functions | |||
| How do I fill (copy) nonadjacent cells to adjacent cells? | Excel Discussion (Misc queries) | |||
| can I export just the autofiltered data into own sheet? | Excel Discussion (Misc queries) | |||
Threaded Mode
