IF find "Refund Needed" text, then copy rows into another Sheet

R

rperezmi

Dear all,

I have this problem on two sheets.

Sheet two is called "Incremental" and I have a row with data from column A34:L34 with L34 having "Refund Needed" or "Expenses Account" text.

I want to copy the entire row (A34:K34 ~ A40:K40) into the first sheet (called "Tax Refund Request"), when "Refund Needed" is on L34, L35, L36... LXY".

Please let me know your comments :)

Regards,
Rodrigo
 
D

Don Guillett

Dear all,

I have this problem on two sheets.

Sheet two is called "Incremental" and I have a row with data from column A34:L34 with L34 having "Refund Needed" or "Expenses Account" text.

I want to copy the entire row (A34:K34 ~ A40:K40) into the first sheet (called "Tax Refund Request"), when "Refund Needed" is on L34, L35, L36... LXY".

Please let me know your comments :)

Regards,
Rodrigo
Click to expand...

Send your file to me and I'll look later
 

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

If Cell = X, Then Copy Entire Row Into A New Sheet 4
Copy entire row from another sheet onto first sheet if a unique text matches 1
Macro to copy and paste to another sheet, based on if-then-else 0
find a value in a column then copy next few rows 4
Auto find a specific row and copy it to another worksheet 0
Import text file into Excel 2007 then copy sheet to another workbo 2
VBA-Copy entire row into another sheet if column K =today()+14 3

Top