VBA to copy & paste VALUES based on criteria

Hello,

I need a macro that will paste cell values from one sheet to another.

On sheet named "filtered"

Column A = Account
Column B = "no" or "upload"

Columns A and B are both formula driven.

If the formula returns "upload" in Col B, I would like the VALUE of cell A to paste over into the sheet named "upload". If the formula returns "no", I would like to skip that row and move to the next.

Any help is greatly appreciated!

Hello Stacymyers11,

Try the following code placed in a standard module and assigned to a button:-

Please Login or Register  to view this content.

The code filters Column B for the criteria "Upload" in the "Filtered" sheet then copies/pastes the adjacent value from Column A into Column A of the "Upload" sheet.

Check the spelling of the sheet names. Make sure that the sheet names on the tabs and in the code match exactly.

Test the code in a copy of your workbook first.

I hope that this helps.

Cheerio,
vcoolio.

This works great, thank you!!

Hi again,

the code was working, I exited the workbook and now I am getting an error:

Capture.PNG

This is the line giving the error:

With ws.Range("B2", Range("B" & Rows.Count).End(xlUp))

Hi StacyMyers,

The PNG doesn't work so I can't see the error. Could you tell me what the error says please.

In the meantime, try changing this line:-

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Let me know how it works out.

Cheerio,
vcoolio.