Copy nonadjacent Autofiltered cells to another sheet

G

Gizmo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and Paste Word 2010 0
Dealing with the error: unable to filter on excel hc home school 0
Dates In Excel 5
Working outlook via vba code with xlsx - error 0
If then formula with multiple cells 2
Tree from Parent/Child Pairs 1
Visio: copy text of a master shape to User-define Cells (Variable) 0
Mail Merge Help 1

Top