+ Reply to Thread
Results 1 to 2 of 2

Copy data to specific layout into 2 excel sheets

  1. #1
    Registered User
    Join Date
    01-07-2013
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    10

    Copy data to specific layout into 2 excel sheets

    Hello,
    I would like some help to copy some data into a loop and a specific layout.
    I try to automate some task to make labels (I did one), in my sheet PrintLabel. The other sheet will have my customer data.
    I let an example with my code, test_form.xlsm
    and what I would like it’s to look at into my sheet customerData to know until which row I have to copy my data and into my sheet PrintLabel I would like to copy the data in this order A1->A8 and C1->C8 and E1->E8 and then A9->A16, C9->C16 ... until it copy all datas from the customerData.
    Do you think that is the better way to do it?

    Last questionm is it possible to securise the layout in the sheet printlabel?

    Many thanks for your advices.

  2. #2
    Registered User
    Join Date
    01-07-2013
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Copy data to specific layout into 2 excel sheets

    Or we can do by A1,C1,E1 and A2,C2,E2 would be easier I think, no?
    But I would have need two loop, one for the columns A (sheet customerdata) for example and another one to add the row (in sheet printlabel).
    Last edited by Dacodac; 02-06-2013 at 04:34 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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