Cross Referening Data Sheets

excelme

New member
Joined
Oct 1, 2013
Messages
4
Reaction score
0
Points
0
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 and third sheets that has the correct versions. How can i make a search button that checks the 2 sheets and lets me know maybe by coloring the document title red or green if my versions in use are good or bad. Attached a small example/

Thanks
 

Attachments

  • tracking.xlsx
    49.4 KB · Views: 14

royUK

New member
Joined
Mar 22, 2011
Messages
155
Reaction score
0
Points
0
Location
Derbyshire, UK
Website
www.excel-it.com
Excel Version(s)
most versions
I would combine both sheets then you the code will be simpler.

What determines if a document is good or bad? Are you matching version numbers on the tracking sheet with the download?

You could possible use Conditional Formatting not VBA
 

excelme

New member
Joined
Oct 1, 2013
Messages
4
Reaction score
0
Points
0
I would combine both sheets then you the code will be simpler.

What determines if a document is good or bad? Are you matching version numbers on the tracking sheet with the download?

You could possible use Conditional Formatting not VBA


Yes im just matching versions. If the version does not match the sheet with the download then i know i need to get the updated version.
 

excelme

New member
Joined
Oct 1, 2013
Messages
4
Reaction score
0
Points
0
But it also has the check the document number. So if document 1 is version C. It needs to check the sheet 2 for document 1 and check the version if they dont match it needs to be flagged on sheet 1.
 

royUK

New member
Joined
Mar 22, 2011
Messages
155
Reaction score
0
Points
0
Location
Derbyshire, UK
Website
www.excel-it.com
Excel Version(s)
most versions
It might be easier to make a helper column that combines the document number & version then check that column. Conditional Format could highlight the row of they didn't match
 
Top