+ Reply to Thread
Results 1 to 4 of 4

Convert Excel VBA to Google sheets

  1. #1
    Registered User
    Join Date
    11-15-2016
    Location
    South Africa
    MS-Off Ver
    2021
    Posts
    9

    Convert Excel VBA to Google sheets

    Cross-posted at https://www.mrexcel.com/board/thread...heets.1265265/ --6SJ

    Hi. Not sure if this is the right place. I got a excel vba script and need to convert to google sheets but have no idea how to do it. Would appreciate any help.
    Placed on mrexcel.com/board

    Working in excel.
    Click on A1, Rotate cells B3 to B4 down to B35. B35 move up to B3
    Please Login or Register  to view this content.
    Administrator's note: Please take the time to review our rules. There aren't many, and they are all important. Our guidelines recommend code tags. I have added them for you this time because you are a new member. --6StringJazzer
    Attached Files Attached Files
    Last edited by 6StringJazzer; 10-11-2024 at 10:46 AM. Reason: please use code tags

  2. #2
    Registered User
    Join Date
    11-15-2016
    Location
    South Africa
    MS-Off Ver
    2021
    Posts
    9

    Re: Convert Excel VBA to Google sheets

    Got it going
    Thanks

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,766

    Re: Convert Excel VBA to Google sheets

    Basically, you don't need to rewrite all data.
    Just to insert row above B3 (to move all rows down) and cut the last result (in this case B36, fi you don't need dynamic row):

    Please Login or Register  to view this content.
    that can be written in javascript as:

    Please Login or Register  to view this content.
    Never use Merged Cells in Excel

  4. #4
    Registered User
    Join Date
    11-15-2016
    Location
    South Africa
    MS-Off Ver
    2021
    Posts
    9

    Re: Convert Excel VBA to Google sheets

    Thanks. It works fine. Just thought of adding a date in D1. So when I click on A1 Button, cells B rotate and Date changes with 7 days on.

+ 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. Replies: 8
    Last Post: 07-16-2023, 06:33 AM
  2. I am trying to convert portions of this google sheets workbook into Excel.
    By west123 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 17
    Last Post: 05-29-2023, 12:40 PM
  3. Can you convert a VBA macro to google sheets?
    By SadCrow in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-09-2022, 09:18 AM
  4. Google Sheets. Can I connect offline data from excel to google sheets?
    By drlemur39 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 11-15-2021, 10:40 AM
  5. How to convert excel aggregation/consolidation to google sheets
    By ISH1959 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 02-18-2021, 08:40 AM
  6. Replies: 1
    Last Post: 02-18-2021, 08:40 AM
  7. Convert Google sheets formulae to excel
    By TH1963 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-28-2020, 03:56 AM

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