Like this?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi everyone,
I'm trying to set up a stock reporting sheet and have tried using =NL("columns" to get the different item no's across the top of my sheet. This works fine but I would like there to be two empty columns between each item so I can have an opening stock, movements and closing stock column for each item.
I've tried to do a fixed item column so that the opening stock is a lookup on each item but I need it to be a lookup in case we add new items in the future.
Thanks
Please sign in to leave a comment.