nikzulfaizan
New Member
- Joined
- Oct 9, 2014
- Messages
- 14
Hi...
I have two worksheet. Sheet1 is for data entry and sheet2 is where I keep the record in the table list...
How can I save the data into sheet2 and subject to where the data should paste when I click the save button . Whenever I save the data, it will find where the last record is and save it.
Example destination columns:
Sheet2[table_list]
A2 = Record No
B2 = Year
C2 = Title
F2 = Reference Record
Thank you and regards,
NickzNickz
I have two worksheet. Sheet1 is for data entry and sheet2 is where I keep the record in the table list...
How can I save the data into sheet2 and subject to where the data should paste when I click the save button . Whenever I save the data, it will find where the last record is and save it.
Example destination columns:
Sheet2[table_list]
A2 = Record No
B2 = Year
C2 = Title
F2 = Reference Record
Thank you and regards,
NickzNickz