PDA

View Full Version : EXCEL



22-03-1999, 12:02 AM
I have set up five sheets each consisting of different materials. Each sheet has 'Description', 'Quantity', 'Retail' & 'Price'. When I put a quantity in I want it to automatically go to my last sheet which is my 'Order sheet'.Is there an easier way than copy & paste special, pick formulas click ok.
As I sometimes have 30 or 40 items chosen this becomes a long task.
Many thanks.