I have seen a few videos with parts of this in it but something is always left out.
Problem: Have to validate data from two Excel files to be sure they match on a weekly basis. Also need to show reasons in comment column if differences are found.
I am calling the new worksheet "Validation".
One of the worksheets, "SEPS Equipment", needs to be compared to the equipment list already in the Validation workbook.
The other worksheet, "Model Equipment", needs to be compared or listed side by side to the SEPS Equipment workbook.
It would be really nice if the two worksheets could be easily updated with changes to the original workbooks after changes are made.
All of the files share two common columns calls "Room ID Number" and "Equipment ID Number"
I would like to have two drop down cells at the top - Department and Room Name.
Both of which could be tied in by the room ID Number.
The idea was to be able to pick a department and room name and have three columns under each worksheet on the same page show data. The three columns of data under each would be Equipment ID Number, JSN, and Count or Qty. So a total of three rows (Original Equipment, SEPS Equipment, and Model Equipment), with 9 sub-rows of data based on equipment ID number
Once the Department and Room Name where changed, so would the information below.
We have to show accountability for all changes in the sheets and model. So by bringing in the "comments" column from the SEPS Equipment worksheet we can see why the equipment was changes and passably when the change happen
I love the videos, very personal, nice touch. Would try and learn until I can peace all this together my self but needs to be completed by Tuesday of next week if I am going to impress.
Thanks for any help on the sub you may give me. I will continue to work on what I can until I have an answer. I have power point to show what I am trying to do more in detail. Finding a way to get it on here is another story.
Problem: Have to validate data from two Excel files to be sure they match on a weekly basis. Also need to show reasons in comment column if differences are found.
I am calling the new worksheet "Validation".
One of the worksheets, "SEPS Equipment", needs to be compared to the equipment list already in the Validation workbook.
The other worksheet, "Model Equipment", needs to be compared or listed side by side to the SEPS Equipment workbook.
It would be really nice if the two worksheets could be easily updated with changes to the original workbooks after changes are made.
All of the files share two common columns calls "Room ID Number" and "Equipment ID Number"
I would like to have two drop down cells at the top - Department and Room Name.
Both of which could be tied in by the room ID Number.
The idea was to be able to pick a department and room name and have three columns under each worksheet on the same page show data. The three columns of data under each would be Equipment ID Number, JSN, and Count or Qty. So a total of three rows (Original Equipment, SEPS Equipment, and Model Equipment), with 9 sub-rows of data based on equipment ID number
Once the Department and Room Name where changed, so would the information below.
We have to show accountability for all changes in the sheets and model. So by bringing in the "comments" column from the SEPS Equipment worksheet we can see why the equipment was changes and passably when the change happen
I love the videos, very personal, nice touch. Would try and learn until I can peace all this together my self but needs to be completed by Tuesday of next week if I am going to impress.
Thanks for any help on the sub you may give me. I will continue to work on what I can until I have an answer. I have power point to show what I am trying to do more in detail. Finding a way to get it on here is another story.
