Excel VBA Code: Read-out, count and compare values with output in another sheet.

Hey Guys! I need your help.

I'm working on my Equipment list and I was hoping to make it a bit more efficient (for now with formulas).
I have my Data sheet where I want to input my data. And on a second sheet, it is counting, depending on the project documents,
the Quantities of my Tools which I have checked-out or used there yet. (In the end I wanna create some charts and diagrams to post later, but that's really not a big problem now.)

I was looking around to see if I find some VBA Macro Code and tried to Code myself (for some time already), but I got nowhere and a PivotTable is what I want to avoid.

Maybe one of the master programmers here can help me out please? :-) (Excel Sheet attached)
It would help me a lot.

11111.JPG
22222.JPG

Hi there,

Will the same document Number (e.g. "Doc-45") ever appear in the "Word Doc Number" column AND the "Excel Doc Number" column?

Regards,

Greg M

Hi there,

I'm assuming that the answer to my question above is "NO"

Take a look at the attached version of your workbook and see if it does what you need.

Adding or editing an "Excel Doc Number" or "Word Doc Number" value on your "Data" worksheet will (if appropriate) add a new row to the Table on your "Output" worksheet, and the new row will be populated with the required formulas.

The code assumes that all document numbers will have the format "Doc-##" or "Doc-###".

The workbook uses the following code in a standard VBA CodeModule:

Please Login or Register  to view this content.

and the following code in the VBA CodeModule of the "Data" worksheet:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M