I presently have stock sheets with details of suppliers, items, quantities held-in stock and on display, price, etc. Whenever I reduce the quantity of items held (either in stock or on display) I need to have that entire row of information picked up and placed on another sheet so I can keep an eye on stock levels.
I haven't got a clue how to do this!
Please someone help me - I need hand holding on this as I am a self-taught beginner trying to learn more!
Just so we can understand fully what you would like to do, could you please upload a sample of your file to a free file sharing site such as DropBox, ge.tt or SpeedyShare and then post the link to your file back here. Be careful with any sensitive data.
Include any code or formulae that you may have tried.