I have created a spreadsheet to keep track of stock in engineers vans.
There are 7 sheets (one for each van) and a total sheet, which is an
order form.
Each van sheet has a very simple setup, a list of items, start qty,
end qty and reorder qty (difference)
What I wanted was for any items which have a positive (not 0) reorder
qty to be copied into the cells in the order form worksheet. Say... if
reorder qty =>0 copy and paste to next empty cell in specified area in
order worksheet.
I don't think I've described that very well so please ask if you
require more info.
Many thanks,
Richard Thorneycroft
Bookmarks