Hello,
I have a small project im working on and require some help seeing i know nothing about VBA. I have spreadsheet with document numbers and versions. I have to make sure every day before i use them that they are the correct versions. I import listings on the documents to the second sheet that has the correct versions each day. How can i make a search button that checks the second sheets and lets me know maybe by coloring the document title red or green if my versions on sheet 1 are good or bad. Attached a small example
So I have document 1 and its version is A and i need to check sheet 2. If document 1 on sheet 2 is a different version then that document description on sheet 1 needs to be flagged.
Thanks
Bookmarks