Macro: copy column value to another sheet based on criteria

[Alcotraz]

Hi guys,

I am very new to VBA and I am trying to work out a macro code which would do the following : for example I have values in Column A and percentages in Column B, and I need to copy only the percentages ( excl formatting) from column b if there is a value in column A and paste it in sheet 2 , in the Column B, if there is a same value in column A ? if there is no value, do not copy anything ., column will have blanks.

Many thanks,

Aiva

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[Parth007]

Oops John made it quickly

[Alcotraz]

Thank you so much for code provided, I am getting an error subcsript out of range, is there anything that I need to edit in this code?

Many thanks,

Aiva

[Parth007]

Hey Check this Code provided by John.. it doesnt give error..

[JOHN H. DAVIS]

Thank you so much for code provided, I am getting an error subcsript out of range, is there anything that I need to edit in this code?

Many thanks,

Aiva

You need to run with Sheet1 activated of the copy from sheet. You also need a Sheet named Sheet2. Check your Sheet names and advise.

[Alcotraz]

It looks ok when I add in the test sheet, but when I want to apply to my orginal sheet it comes as an error, but I will have a look at this later.

But I found an issue with values, if the cell is formated as currency, or percentage, ir doesnt copy over, also, if there is text somewhere in column A, after the text row it stops copying the percentages too..

[Alcotraz]

It might be easier to understand for you guys if I submit an original sheet.

Please find attachment below.

So the goal is , from sheet 6, Column G , once I press button CERT.DONE. , those percentages to copy over in sheet4 for the same items as per Sheet6 in Column G , and delete contents in column H. keeping the same format, so only values( percentages)

http://docdro.id/bIDyxVo

Many thanks,

Aivaras