![]() |
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