View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nks1510 nks1510 is offline
external usenet poster
 
Posts: 1
Default subtracting from total multiple sheets (inventory) help.


Hi there,
Need to input a formula for an inventory spreadsheet where in i can
deduct the supplies leaving a location from the total inventory.

There are aproximately 50 worksheets that are deducted from the total
inventory,
i.e
sheet 1 =total inventory (part 001)
sheets 2-50 load sheets (part 001 on each)

How can i deduct the total parts from 2-50 worksheets (part 001) to
reflect on total inventory (part 001 on sheet 1).

Is there a common formula for this?
Kinda new at this ...any help would be greatly appreciated.

Thanks


--
nks1510
------------------------------------------------------------------------
nks1510's Profile: http://www.excelforum.com/member.php...o&userid=23863
View this thread: http://www.excelforum.com/showthread...hreadid=375040