Hello all,
I need to know if there is a way to make a macro that on key press, we will say Alt+L, it will add a row to the bottom of a table and insert data from the new sheet into my master table.
Example:
I have 100 rows of information taken from 100 sheets.
I want to add a new sheet, make row 101, and duplicate a sheet, then pull information off into the main sheet.
This would allow me to add inventory faster, while being able to have individual sheets.
I know it may seem odd, but it will be very crucial and extremely helpful to me.
Thank you all in advance.
Bookmarks