Hi,
Please could someone help with the below -
I have a workbook with multiple sheets.
On sheet one I have a number of cells formatted as below -
E3 - Name
E5, G5, I5 - Number
E7 - Type
Basically I would like a button below this that once the above boxes have been completed with information it cuts the information from them and adds it onto a single row on another sheet.
For Example -
The above moves onto sheet two -
E3 data is pasted in A1 on sheet two
E5, G5, I5 data is pasted in B1, C1, D1 on sheet two
E7 date is pasted into E1 on sheet two
If information is then entered into sheet one again and the button is pressed it uses the next available row on sheet two, so enters into A2, B2, C2, D2, E2 etc.
Is this possible?
Thank You
Bookmarks