question

MrJones-2929 avatar image
0 Votes"
MrJones-2929 asked

EXCEL Command Button: Copy data, paste data to next empty row , delete original data, save & compile copied data on Sharepoint

Hello, I have a spreadsheet uploaded to Sharepoint that will be used repeatedly as an ongoing form / log. I would like the following to occur when I click the Command Button:
1. All entered data is copied from Worksheet1 to Worksheet2
2. All copied data on Worksheet2 must be copied to the next empty row so that each time the form is used, the data is saved for future reference.
3. All entered data on Worksheet 1 is cleared but the formulas remain for the next use, HOWEVER the data on Worksheet2 must always remain and compile with each new use.

Current functionality:
1. The command button opens an Outlook email draft and attaches the Workbook
2. V-Lookup copies the data from Worksheet1 to Worksheet2


office-vba-devoffice-scripts-excel-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers