+ Reply to Thread
Results 1 to 1 of 1

Microsoft Excel to Google Sheets

  1. #1
    Registered User
    Join Date
    09-20-2016
    Location
    Fgura, Malta
    MS-Off Ver
    2013
    Posts
    23

    Microsoft Excel to Google Sheets

    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.

    Please Login or Register  to view this content.
    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?

    Please Login or Register  to view this content.
    I attached the Excel Workbook with this thread.

    Thank you.
    Attached Files Attached Files
    Last edited by marifard; 03-01-2021 at 03:55 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Microsoft Excel- Plotting Lines onto Google Maps (Macro)
    By wesgerrr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2019, 08:35 AM
  2. Replies: 1
    Last Post: 09-20-2019, 11:38 PM
  3. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  4. Replies: 0
    Last Post: 10-26-2016, 11:07 AM
  5. Converting spreadsheets from Microsoft Excel to Google Docs
    By hammerb in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 10-08-2013, 02:32 PM
  6. [SOLVED] how to search google using cell values in microsoft excel 2010
    By Julii in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 09-16-2013, 09:31 AM
  7. All the excel files downloaded from google drive are not opening in Microsoft Excel 2010
    By kapilpatel in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 02-21-2013, 12:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1