Hi there,
Currently trying to make a new sheet up for work for transferring stock and stuck on a formula and can’t seem to pin down what it would be.
Main work sheet I have a item ID and different transfer ID’s, on separate sheets named for the days of the week I have a break down of the list of these item ID’s, quantity transferred and a unique transfer ID.
Is there a way to return on the main sheet the quantity for each item transferred off that matches the transfer ID no matter which sheet day this was sent on?
Hopefully this makes sense as can’t explain it any other way!
Many thanks
Bookmarks