Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    I have 2 workbooks which I have attached

    1) Linking
    2) Unit Sales

    1) I need to link the data in U13, AE13, AF13 etc to Book3 from C2 Onwards
    2) I need to link the data in U52, AE52, AF52 etc to Book3 from d2 Onwards
    3) The data must appear as positives that are on the workbook linking
    4) I have 2 macros and would like to combine this into one macro if possible

    I have written code, which links and copies the data from col AE, but do not know how to include col U. I.e It must be contain Col U and then from AE onwards it must not be from U onwards, it must include U and then link and copy from AE

    Your assistance will be most appreciated

    Regards

    Howard
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I'd write a separate line to link the value from column U, followed by a loop that links the values from column AE onwards.

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    [quote name='HansV' post='800471' date='29-Oct-2009 07:44']I'd write a separate line to link the value from column U, followed by a loop that links the values from column AE onwards.[/quote]


    Hi Hans

    Thanks for the reply. It makes sense to have separate line to link the value from column U, followed by a loop that links the values from column AE onwards.

    Regards

    Howard

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •