Hi,
I made a file tracking workbook in MS Excel and last week I export it in google sheets to make easier for two persons or more enter the data at the same time. My problem is that I made two buttons in MS Excel workbook, one to save the data entered in a particular sheet to another sheet and the other one is to clear the cells, but in Google Sheets I didn't found them.
I built two new buttons in Google Sheets to replace the buttons that I made in MS Excel. One button to save data from New Inv Entry worksheet to Invoices worksheet and Clear Button to clear data entered in New Inv Entry worksheet. The code for Clear button I don't have any issues but I have problems with the Save Button.
This is the code that I made in MS Excel to save data from New Inv Entry worksheet to Invoices worksheets. I wish to convert it to Google Sheets.
I use this function hereunder in Google Sheets to replace the code that I pasted but I have a problem with it because it didn't save in the last row and didn't save all the data. Any help?
I attached the Excel Workbook with this thread.
Thank you.
Bookmarks