+ Reply to Thread
Results 1 to 2 of 2

How to create a macro that goes on a loop until the rows and columns are empty?

  1. #1
    Registered User
    Join Date
    04-17-2023
    Location
    Phoenix, Arizona
    MS-Off Ver
    Office 365
    Posts
    2

    Question How to create a macro that goes on a loop until the rows and columns are empty?

    Hello friends,

    I have a report that I receive in CSV, and I need to format it in a very specific way. I need to copy the data from tab A (csv) to tab B (vertical).

    TAB CSV
    tabA.png

    TAB vertical
    tabB.png

    Basically, the macro has to create a new row for each category (in rows) for each branch (in columns) adding the date and the branch name.

    I don't know to create a loop that copies all the data and when the last row is empty, it jumps to the next column until the last column is empty.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    08-08-2022
    Location
    Buenos Aires
    MS-Off Ver
    Excel 2019
    Posts
    1,777

    Re: How to create a macro that goes on a loop until the rows and columns are empty?

    Hi rhjaber. Try with:

    Please Login or Register  to view this content.
    You are always very welcome if you add reputation by clicking the * (bottom left) of each message that has helped you.

+ 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. [SOLVED] delete columns and rows based on zero or empty values and create new file
    By Ali-M in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-31-2022, 08:38 AM
  2. [SOLVED] Need to Create Macro Button That Hides Empty Columns ONLY when Rows are Filtered
    By asoule519 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-27-2019, 10:10 PM
  3. [SOLVED] Loop through all non empty columns and rows and copy each N row
    By ISMI in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-05-2018, 12:16 PM
  4. Replies: 0
    Last Post: 08-03-2016, 07:01 PM
  5. VBA macro to delete all empty rows and columns
    By specialist1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-09-2015, 04:01 PM
  6. Code/Macro for deleting empty columns and rows.
    By gautamacharya in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-09-2014, 01:49 PM
  7. Hide columns if rows empty
    By melewis212 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-25-2012, 06:55 PM

Tags for this Thread

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