Copy rows & columns based on the name to another sheet

**desitracks** · 11-24-2010, 06:37 PM

Hi,

I'm very new to VBA programming, if you can help me it would be greatly appreciated.

First column name is Status, which has values of "Y" or "N".

Then I have bunch of rows and columns with sets of data.

Lets say I have about 4 rows with 10 columns of data, it is basically sets of data. Right now I have about 10 sets of data, some of them are with 2 rows with 10 columns and some with 5 rows with 10 columns.

Example:

Here is what I have done:

I have selected 4 rows and 10 columns and named it "Test1" and selected another set of rows and columns and named it "Test2".

what I would like to do is in Sheet 2 to copy all the rows and columns based on the name and where "Status" = "Y".

Is this possible?

Thanks!

**Domski** · 11-24-2010, 07:41 PM

Hi,

I'm not sure the naming part is necessary.

Best thing would be to upload a sample workbook showing what you are trying to achieve and I'm sure it shouldn't be asking too much to come up with a solution.

Dom

**desitracks** · 11-25-2010, 10:31 AM

Hi I have attached the excel sheet.

First sheet name is "Payment" and second sheet name is "PaymentReceived".

What I would like to do is to select all the rows that has "Y" in column B and copy it.

Then paste it in sheet "PaymentReceived" under the right headings, and it should have an empty row between set of data.

I'm not sure if this would be possible.

Thanks!