Hi, I have a simple Quote/Ordering system.
The setup uses one sheet with lines containing part number, description, price, qty and total. Every time I enter a non-zero number in qty, I need this line transferred into another sheet for ordering purposes.
What is the simplest way of doing this? The spreadsheet is used by non-computer literate staff so I would prefer it that it happens invisibly in the background. I have tried using Autofilter but autofilter is not 'live' e.g. I have to turn autofilter off then back on in the second sheet to see changes made in the first sheet.
Thanks
Mike
Bookmarks