+ Reply to Thread
Results 1 to 3 of 3

Loop Macro Help

  1. #1
    Registered User
    Join Date
    03-24-2014
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Loop Macro Help

    Hi - I'm very new to this so bear with me!

    I am currently working on a Macro for an invoice template that picks all the details from my table of data based on the invoice number and then exports the template to a PDF. I need to loop through a column of invoice numbers so I can repeat the process for each different invoice number but I am having trouble setting up the loop in VBA.

    The table I am working with is called "Schedule_Invoice" & the column within this that I need to loop through is called "Invoice #". I just need to paste each invoice number into cell U6 in my "Invoice Template" worksheet so I can proceed with exporting into PDF and then move on to the next invoice number in the column and repeat.

    I feel as though this should be quite straightforward for those who know what they are doing but unfortunately I don't have the VBA experience.

    If anyone could give me some pointers that would be great.

    Thank you.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    33,499

    Re: Loop Macro Help

    Post a sample workbook with your desensitised data. See the yellow banner at the top of the page.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    03-24-2014
    Location
    Manchester, England
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Loop Macro Help

    Apologies. Hopefully the sample has attached.

    I have removed name & address data etc
    Attached Files Attached Files

+ 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. Excel VBA Macro loop to run a macro multiple times based on a column from a table
    By pepeadad in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-27-2020, 11:59 AM
  2. Loop Macro with Images getting distorted during loop
    By luxy007 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-23-2017, 01:57 PM
  3. Replies: 3
    Last Post: 01-07-2015, 12:19 PM
  4. [SOLVED] Have a loop macro loop for all visible worksheets
    By Graeme-Black in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-22-2014, 11:01 AM
  5. Novice with VBA and macro writing needing help to loop a macro unti no data
    By jrongone in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-25-2013, 12:19 PM
  6. [SOLVED] Copy dynamically changing column and Paste using VBA Loop (Loop within Loop)
    By nixon72 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-12-2013, 12:46 PM
  7. Macro Loop Broken. Detects Max but doesn't continue loop
    By herchenbach in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2011, 12:17 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