Copy Worksheet, Transfer Data List & Print

    I'm ok with vBA macro's but sometimes have trouble figureing out to get one started, though I can usually alter a preexisting macro to do what i want it to do.


    I need a VBA Macro that (when run) will Copy a worksheet in my workbook, then transfer data from a list into said worksheet and then print it.


    Example.


    Worksheet 1 (Worksheet containing a list of customer information such as name, address, phone number, charges, ect)
    Worksheet 2 (A blank invoice)


    Worksheet 1 has 10 customers (though this number can change) listed with their information. I'd like to be able to click a button and have it copy an invoice however many times it needs to to make an invoice for every customer, and then copy said customer information over to it's respective invoice, and then prints all the invoices once done.


    I'm not sure if it's possible.

    Re: Vba Macro That Creates Copies Of A Worksheet And Transfers Data Into It And Prints It


    You need to supply workbooks showing the stucture you are using, everything you ask i fairly simple, in fact you could use the macro recorder to get you most of the way there just switch it on and perform the actions, take a look at the code which you say you can usually alter to make work for your situation and when you have something near and a workbook we can look at get back to us where we will be glad to help!

    Re: Vba Macro That Creates Copies Of A Worksheet And Transfers Data Into It And Prints It


    Oh and if the invoice's tab could be renamed to the name of the customer. here is an example of what I've got.[hr]*[/hr] Auto Merged Post Until 24 Hrs Passes;[dl]*[/dl]OK, I will see what I can do about recording the macro

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login