Hi, So how do I do it? This is a follow on from the other thread where I asked if it was possible to do this without a macro. It seems it is possible but requires alot of space and a pivottable Etc.
Can anyone help me to write a macro for this? I'm new to this so what is simple to you will be foreign to me!
I need to generate a list on the results page that take account of all materials entered into cells A5:A20 and their Quantity in column C5:C20 on every sheet, total them, remove duplicates but still add quantities of the same material should a duplicate be made.
For example sheet1 cement = 5, sheet2 cement = 3, sheet3 cement = 30, etc. The list should have just one entry for cement, but the result should be - cement = 38
I got some way to doing this with formulas and a pivottable but am sure this can be much simpler with a macro...
Thanks, Richard
(Can you explain a few of the basics of VBA or direct me somewhere that can, I am eager to learn)