Macro copying rows to a new sheet based on a specific value

**St3ff3ns** · 01-03-2018, 05:21 AM

Hi Dears,

I am trying to copying all rows from Sheet "DRP data" to sheet "DRP Rework",

I would like the macro to copy all the rows containing a "A" letter in column U:U

I also would like the macro to erase the previous data contained in sheet DRP rework before copying all info (in order to make sure to do not have a double counting)

Here-below the starting code i have used but I cannot get the wanted info... could you help me in correcting it please ?

Please Login or Register  to view this content.

Thanks in advance !

Steffen

**AliGW** · 01-03-2018, 05:23 AM

How is this different to your other thread, please?

**St3ff3ns** · 01-03-2018, 05:28 AM

Hi Ali,

The other is solved and this is another macro executing another action,

Rgs,

**vcoolio** · 01-03-2018, 05:34 AM

Hello Steffen,

Try adjusting your code as follows:-

Please Login or Register  to view this content.

I hope that this helps.

Cheerio,
vcoolio.

**St3ff3ns** · 01-03-2018, 05:49 AM

Hi Vcoolio,

I have adapted as proposed, however, here-below the run time error I get :

Run-time error '1004':
Application-defined or object-defined error

Any idea why this has popped up?

Thanks !

**kev_** · 01-03-2018, 06:05 AM

another option

Please Login or Register  to view this content.

**vcoolio** · 01-03-2018, 06:06 AM

Hi Steffen,

It could be just a minor thing but its hard to tell without seeing your workbook set up.

Could you please upload a sample of your workbook so I can have a look and do some testing with your layout. If you have sensitive data in your workbook, then please use dummy data (just a few rows will do).

Cheerio,
vcoolio.

Macro copying rows to a new sheet based on a specific value

LinkBack

Thread Tools

Rate This Thread

Display

Macro copying rows to a new sheet based on a specific value

Re: Macro copying rows to a new sheet based on a specific value

Re: Macro copying rows to a new sheet based on a specific value

Re: Macro copying rows to a new sheet based on a specific value

Re: Macro copying rows to a new sheet based on a specific value

Re: Macro copying rows to a new sheet based on a specific value

Re: Macro copying rows to a new sheet based on a specific value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro copying rows to coulm based on specific criteria

[SOLVED] Macro for copying rows with cells with specific values from 1 sheet to another

Copying Rows Based on Specific Cell Match

[SOLVED] Macro question - Copying rows into worksheets based on criteria of a specific column

Copying rows from another sheet based on specific criteria

Macro for copying rows from master sheet to other worksheet based on column content

Macro for copying specific rows to a new sheet.

Bookmarks

Bookmarks

Posting Permissions