For Loop to Copy Paste Data from sheet to another

[stein7]

Hi all,

In cell B1 and B2 there is a data validation list where the user will select the client name and Type.

Capture.JPG

I am trying to get a macro to use what the User selects in those drop downs as Conditions and Loop through the "Database" sheet Copy Pasting all Lines that match those Conditions into Summary Cell N4

Capture2.JPG

In the first photo, with the first drop down, the column on the Database that corresponds to that is Database Column C, in the second drop down the corresponding column is Database Column Y

The thing is I would only need to copy the data from column A, C, F, G, H, I, W, X, Y in Database, not the entire line.

Any help here is much appreciated. I have attached the Sample Spreadsheet for your reference.

[vcoolio]

Hello Stein7,

See if the following code, assigned to the button, will do the task for you:-

Please Login or Register  to view this content.

I hope that this helps.

Cheerio,
vcoolio.