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".
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".