Forum Home
Press F1
 
Thread ID: 1130 1999-03-21 12:02:00 EXCEL Guest (0) Press F1
Post ID Timestamp Content User
1478 1999-03-21 12:02:00 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.
Guest (0)
1