ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Copy nonadjacent Autofiltered cells to another sheet (https://www.excelbanter.com/excel-discussion-misc-queries/180818-copy-nonadjacent-autofiltered-cells-another-sheet.html)

Gizmo

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


All times are GMT +1. The time now is 03:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com