I am new to the forum and have self taught what I know about excel, and have seemed to stumped myself on this one. I am formatting a spreadsheet to track fabrication progress, individual welder welds, and individual welder repairs with repair rate. I will attach a sample and try to describe what I am attempting to do.
On the first sheet (Log) in column 'D' an ID number will be input using a data validation drop down box. On the second sheet (Stats), I have names in column 'A', their ID # in column 'B', and total weld count in column 'C'. What I want to happen is when I select an ID number from the drop down list in column 'D' on the Log sheet for the particular weld, I want it to add to that welder's total weld count on the Stats Sheet. Is this possible, and if so, how?
Also, on the Stats Sheet I have a column for 'repairs' and would like for the spreadsheet to add to the total for that ID number's repairs when I select 'Yes' from my data validation drop down box on the Log Sheet. It would be easy to do this manually as we rarely have repairs but if it's possible to do, I would like to.
I am using 2003 version.. boooo... but have the latest and greatest on my Home PC and can work on it there if it makes it easier.
Thank you in advance to anyone who takes time to assist. It is greatly appreciated!
Bookmarks