Fishyninja
New member
- Joined
- Feb 20, 2014
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hello All. I had a question. I have been tasked with creating an 'Excess Inventory' Spreadsheet. We have multiple work books with the inventory for specific projects and we want a single workbook where all the excess totals are added up for ease of reference. I know how to link workbooks so that's not a problem but in my mind all I keep coming up is for example =(Excess-WkBk1+Excess-WkBk2+ExcessWkBk3....) and do on and so forth. That cant be right.....can it? Also is there a way to auto fill categories, so for example if I am trying to work out the excess amount of A4 folders we have can I establish a method where by inserting 'A4 Folders' into my excess inventory sheet it searches other linked work books to auto fill the data?
Last edited: