Trying to put together vba to compare the "parts" sheet to the "orders" sheet (both in same workbook).
Specifically compare COL B of "parts" sheet starting at ROW 8 to COL P of the "orders" sheet starting with ROW 5.
If match IS found, do the following copies from "parts" sheet to "orders" sheet:
Copy COL D cell data on "parts" to COL Q of "orders"
Copy COL A cell data on "parts to COL R of "orders"
Copy COL G cell data on "parts to COL E of "orders"
If NO MATCH is found, do the following copies to the NEXT AVAILABLE OPEN ROW on the "orders" sheet:
(this will essentially add this line item to the base of the parts list that was found missing)
Copy COL B cell data on "parts to COL P of "orders"
Copy COL D cell data on "parts to COL Q of "orders"
Copy COL A cell data on "parts to COL R of "orders"
Copy COL G cell data on "parts to COL E of "orders"
Last, Turn all data to red bold font on all these items/rows that have been added as new rows of data (at the base of "parts")...
Specifically compare COL B of "parts" sheet starting at ROW 8 to COL P of the "orders" sheet starting with ROW 5.
If match IS found, do the following copies from "parts" sheet to "orders" sheet:
Copy COL D cell data on "parts" to COL Q of "orders"
Copy COL A cell data on "parts to COL R of "orders"
Copy COL G cell data on "parts to COL E of "orders"
If NO MATCH is found, do the following copies to the NEXT AVAILABLE OPEN ROW on the "orders" sheet:
(this will essentially add this line item to the base of the parts list that was found missing)
Copy COL B cell data on "parts to COL P of "orders"
Copy COL D cell data on "parts to COL Q of "orders"
Copy COL A cell data on "parts to COL R of "orders"
Copy COL G cell data on "parts to COL E of "orders"
Last, Turn all data to red bold font on all these items/rows that have been added as new rows of data (at the base of "parts")...