Results 1 to 9 of 9

VBA/Macro for Copying Purchase Order Form to a New Tab, Auto Increment the Tab number.

Threaded View

joemi VBA/Macro for Copying... 04-01-2015, 04:29 PM
mehmetcik Re: VBA/Macro for Copying... 04-01-2015, 08:31 PM
joemi Re: VBA/Macro for Copying... 04-01-2015, 10:54 PM
mehmetcik Re: VBA/Macro for Copying... 04-02-2015, 05:05 PM
joemi Re: VBA/Macro for Copying... 04-02-2015, 06:20 PM
mehmetcik Re: VBA/Macro for Copying... 04-02-2015, 06:39 PM
joemi Re: VBA/Macro for Copying... 04-02-2015, 07:27 PM
mehmetcik Re: VBA/Macro for Copying... 04-03-2015, 07:56 PM
joemi Re: VBA/Macro for Copying... 04-06-2015, 11:44 AM
  1. #1
    Registered User
    Join Date
    04-01-2015
    Location
    United States
    MS-Off Ver
    2007
    Posts
    5

    VBA/Macro for Copying Purchase Order Form to a New Tab, Auto Increment the Tab number.

    Hello All,
    I normally find your form very informational, so I thought I would try to get any answer.
    I have a form that has a bunch of worksheets with a Purchase ORder form on each sheet. The sheets are label 001-100. I also have a "PO Tracker" Sheet, that basically takes information from from each Purchase order form and organizes it on the tracker (IE; PO #, Date of Purchase, Vendor, and Customer Sold to). I have also created a Hyperlink from the Tracker sheet to each individual Purchase order form, for quickly finding a given PO. The problem that I have is that once I exceed the 100, I have to manually copy a new PO form to a new tab, rename it to "101", and then on the Tracker sheet, I have to create new line items with links to the appropriate fields.
    It can be time consuming when you are doing this everyday.
    Is there a way I can create a macro to Automatically copy the blank PO form, Create and Name Incrementally (101,102,etc.) and then also add a line item to tracker with all of the look ups to the new tabs created?
    I have tested a few codes in VBA, but can't quite get it right.
    This would be a huge time saver, as well as make it so any of my co-workers could create their own new PO's without ruining the Workbook.
    Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 11-19-2013, 12:03 AM
  2. [SOLVED] Purchase Order Printing (Automatically increment the number in a cell)
    By bigsi1984 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-09-2013, 03:37 AM
  3. Purchase Order Increment
    By knightrider99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-14-2012, 06:53 AM
  4. Macro Reqd to update Purchase order log, everytime a new purchase order is made
    By manthankanabar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-23-2012, 01:47 AM
  5. [SOLVED] Increment Purchase Order Number
    By Curious in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2006, 09:40 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