Hi all,
So i'm entering data into a single cell lets say "A1" on "Sheet1" when this data is entered and when a is button pressed the data is removed from the cell automatically via VBA black magic. This also either deducts or adds 1 to a stock list source sheet depending on which button is pressed.
I would like on "Sheet2" to automatically record in list form all data that is entered into cell A1 on Sheet1 for stock taking purposes.
Basically i'm nearly there and would like to know if there is a way without using VBA/Macro to make Excel go to the next available row once it has recorded each bit of data entered into cell A1 on Sheet1.
I've tried to ask google a few times but it keeps shoving me towards drop down lists so i also wonder if i'm asking the wrong question.
Kind Regards,
Antony.
Bookmarks