+ Reply to Thread
Results 1 to 3 of 3

Macro Help - Using a macro to creat x extra rows

  1. #1
    Registered User
    Join Date
    07-13-2020
    Location
    England
    MS-Off Ver
    360
    Posts
    1

    Macro Help - Using a macro to creat x extra rows

    Hey All,

    I'm having a little trouble figuring out the best way to approach an excel problem, please can anyone help?

    Problem - I'm trying to create an excel based purchase order system, I want to fill out a basic form (date, product number, description, unit price, currency, supplier etc) & then run a macro, which will take that form and populate it into a table format, for the purpose of uploading as a CSV file.

    The trouble I have, I want multiple forms to go into one daily table. I know how to copy each form over if it's one row, but when you I have multiple rows of data, I'm not sure how to add the data to the bottom/top in this instance. How would I get the macro to check if the previous row has data and skips the row / only copies over if the rows are blank?

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    8,098

    Re: Macro Help - Using a macro to creat x extra rows

    Hi, Kronos999,

    do you need the table right away or could you work with a range and add a table at the end of the day? Please find the link to https://jkp-ads.com/Articles/Excel2007TablesVBA.asp where nearly all things for tables and their use with VBA are explained.

    HRH
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    1,779

    Re: Macro Help - Using a macro to creat x extra rows

    A small example file as per the yellow banner above would in us providing you with relevant code.

+ 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] Macro adding 4 extra rows for each value of a specific table
    By St3ff3ns in forum Excel General
    Replies: 6
    Last Post: 01-03-2018, 10:13 AM
  2. [SOLVED] Macro to set extra extra thick outer border for selected column and row:
    By Chad Bateman in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-02-2014, 01:43 PM
  3. Macro to remove extra blank rows
    By alexduy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2013, 01:20 PM
  4. Replies: 8
    Last Post: 08-27-2012, 04:37 PM
  5. Delete rows with macro - with an extra challenge
    By Renvilo in forum Excel General
    Replies: 1
    Last Post: 07-27-2011, 05:48 AM
  6. Add extra rows to a macro-ed file
    By m5rcc in forum Excel General
    Replies: 0
    Last Post: 10-05-2009, 09:35 AM
  7. [SOLVED] Macro to insert extra rows in a table
    By Jonathan Oz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-21-2005, 10:06 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