Any Excel wizards out there help me with a formula
I'll try explain it but can email the workbook to anyone who wants a go..
I have a catalogue of equipment on a sheet called 'Master'. Each item has a unique part number in column A and a total quantity of item in column E. The info in column B
is irrelevant.
In the same workbook I have several sheets that personnel have submitted for items they require from the catalogue (not the full catalogue just the lines for items they require). The sheets are named order 1, order 2 etc....The item part numbers are in column A and qty required in column E. Again info in column B
is irrelevant.
I need a formula that will update the total quantity column in 'Master' (column E) using the quantities of each part number requested in column E on each sheet submitted by personnel, so I can order the total qty required without going through each sheet adding them up (lots of items and lots of sheets)
I've tried using a SUMIF formula but the problem I'm having is the multiple worksheets and part numbers on different lines in each
Can anyone help
I may treat anyone who can sort me out with a gift from the club shop
I'll try explain it but can email the workbook to anyone who wants a go..
I have a catalogue of equipment on a sheet called 'Master'. Each item has a unique part number in column A and a total quantity of item in column E. The info in column B
In the same workbook I have several sheets that personnel have submitted for items they require from the catalogue (not the full catalogue just the lines for items they require). The sheets are named order 1, order 2 etc....The item part numbers are in column A and qty required in column E. Again info in column B
I need a formula that will update the total quantity column in 'Master' (column E) using the quantities of each part number requested in column E on each sheet submitted by personnel, so I can order the total qty required without going through each sheet adding them up (lots of items and lots of sheets)
I've tried using a SUMIF formula but the problem I'm having is the multiple worksheets and part numbers on different lines in each
Can anyone help
I may treat anyone who can sort me out with a gift from the club shop