Excel VBA IF Copy and Paste Value Equals

[falascot]

IN VBA, I'm trying to copy the value in column MaterialNum if it equals the value 390.005-15 to column PartNum. Thanks for the help

 

[Joe4]

Welcome to the Board!

So, you want to copy the values of "390.005-15" over to the "PartNum" column? Is that correct?
If so, please tell us the column letters that the "PartNum" and "MaterialNum" columns are found in.

 

[falascot]

Part# = C
MaterialNum = P

Thanks for the help.

 

[falascot]

IN VBA, I'm trying to copy the value in column MaterialNum (column "P") if it equals the value 390.005-15, the value is copied to (column "C") Part# in the same row. It will overwrite the value in this case of 390.005. The current table is approximately 65,000 rows, but in most cases the value of 390.005-15 in column "P" maybe less than 20 rows.

I need to keep looping through the spread sheet until it's finds all the values.

This information is being pulled from a SQL table for manufacturing and it refreshes every 15 minutes

On the image, I hid some of the columns so I could show the two working columns that I have identified. Column "C" and column "P".