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.
Bookmarks