Okay, so i am aware of what I wish to happen, but i do not know where to start in making it happen.
I am creating a system in of which a user can input data into, (row of data, including item names, date, costs etc) Once this has been filled in on Sheet 1, a button could maybe trigger a macro/code that places this line or information into a table in Sheet 2.
Once the data has been cut/copied over i no longer wish for the data to still be in Sheet 1. (but i could always set up a separate clearing macro).
Another problem i am having is when more data is sent to sheet 2 i do not want it to paste over the data already in sheet 2, and instead add it underneath or on-top of it.
Sorry if this is confusing If you need more info please ask. i Realllly need this to happen.
P.S If you can think of a similar way of doing this i am willing to alter my original idea drafting.
I am creating a system in of which a user can input data into, (row of data, including item names, date, costs etc) Once this has been filled in on Sheet 1, a button could maybe trigger a macro/code that places this line or information into a table in Sheet 2.
Once the data has been cut/copied over i no longer wish for the data to still be in Sheet 1. (but i could always set up a separate clearing macro).
Another problem i am having is when more data is sent to sheet 2 i do not want it to paste over the data already in sheet 2, and instead add it underneath or on-top of it.
Sorry if this is confusing If you need more info please ask. i Realllly need this to happen.
P.S If you can think of a similar way of doing this i am willing to alter my original idea drafting.
Last edited: