help with VBA codes to extract selected data from worksheet on specific conditions

**ragulduy** · 09-09-2013, 11:38 AM

Change

count_1 = 1

to

count_2 = 1

and copy the information across using either:

Sheets("Sheet1").rows(1).copy Sheets("Sheet3").Range("A1")

or

Sheets("Sheet1").rows(1).copy ws.Range("A1")

Depending on whether you are using an existing sheet or adding a new one.

**HarryC** · 09-10-2013, 03:34 AM

@yudlugar

Hello there

Thanks a lot for helping me out

One last query please. Probably being thick here. How can i allow the second macro to retrieve the data for Dawn Gray for example. I have given the thought of retrieving the data in the same sheet. If you see on Sheet 2, I have got the data retrieved for Sue Hendry. What i would like to do now is click on "Dawn Gray" and it clears the data for Sue and retrieves the data for Dawn?

Is this possible. For example. i am attaching the latest sheet.

Thanks