Hello everyone,
I have an excel sheet "Data Combine" that I copy+paste data from our subcontractor. This sheet is not in any order.
I have another excel sheet "Final Data" with a numbered column from 1-4226. Data is entered on a daily basis in the "Data Combine" that uses a vlookup formula to sort and confirm areas on the data that is missing. It enters the data in "Final Data" sheet directly next to the numbered column its data represents.
I have another sheet "Asset" that has a map created within the cells to look like our site. Each cell has its own number in it (1-4226) that is in the order it needs to be.
What i would like to happen is, when data is entered on a daily basis, and the row with its represented number in "Final Data" is filled (row 25 has been data next to it), I would like the cell in "Asset" that has the same number to be highlighted automatically if the cell in "Final Data" has information in it. If blank, then no change.
Attached in the sheets I have been using.
Any help with this will be amazing. Thank you
Bookmarks