+ Reply to Thread
Page 6 of 7 FirstFirst ... 4 5 6 7 LastLast
Results 76 to 90 of 100

VBA to Copy set data, paste into set cells, then copy more & set into cells related 2 date

  1. #76
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: VBA to Copy set data, paste into set cells, then copy more & set into cells related 2

    Am glad its sorted The experience was good, as if i am creating a template of my own
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  2. #77
    Forum Contributor
    Join Date
    11-05-2012
    Location
    Montreal
    MS-Off Ver
    Excel 2007
    Posts
    107

    Re: VBA to Copy set data, paste into set cells, then copy more & set into cells related 2

    Hello Arlette,

    If you don't mind can you please put the template you are creating?

    Thank you

  3. #78
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: VBA to Copy set data, paste into set cells, then copy more & set into cells related 2

    I didnt create any template Naja. I meant the experience felt as if i was creating a template of my own since i had to do complete process flow testing.

  4. #79
    Forum Contributor
    Join Date
    11-02-2011
    Location
    Rugby, England
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    844

    Re: VBA to Copy set data, paste into set cells, then copy more & set into cells related 2

    Good morning Arlu,
    having had some time to play with the sheet, attached you will find my issue.
    I have removed the TL2 & T2 tabs for now, just to get the first one running -> Comments on TL1
    Attached Files Attached Files

  5. #80
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: VBA to Copy set data, paste into set cells, then copy more & set into cells related 2

    I am not sure if you used the updated code since i remember correcting in the exact same places as i did now -
    Please Login or Register  to view this content.

  6. #81
    Forum Contributor
    Join Date
    11-02-2011
    Location
    Rugby, England
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    844

    Re: VBA to Copy set data, paste into set cells, then copy more & set into cells related 2

    Hi, i am using that code
    Have you tried it?
    When i run the code and using the steps above, the code duplicates names in Column B which is the problem.
    It does insert the areas correctly, just makes a mess of the names .

    Regards

  7. #82
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: VBA to Copy set data, paste into set cells, then copy more & set into cells related 2

    Try this updated code - did a few changes -
    Please Login or Register  to view this content.

  8. #83
    Forum Contributor
    Join Date
    11-02-2011
    Location
    Rugby, England
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    844

    Re: VBA to Copy set data, paste into set cells, then copy more & set into cells related 2

    Hi Arlu,

    Still having issues
    I run the new code for monday, change names & date, run again, and it goes messy.
    As attached.
    Many thanks.
    Attached Files Attached Files
    Last edited by galvinpaddy; 11-28-2012 at 04:43 AM.

  9. #84
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: VBA to Copy set data, paste into set cells, then copy more & set into cells related 2

    What do you mean by messy? Its showing that the data is populating in the 3rd Area column for whichever names were showing in the column. And then it added new names through the vlookup.

  10. #85
    Forum Contributor
    Join Date
    11-02-2011
    Location
    Rugby, England
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    844

    Re: VBA to Copy set data, paste into set cells, then copy more & set into cells related 2

    Hi and thanks for your time!

    I dont believe i have been so DAFT, i really am sorry. i completely overlooked the fact that i had been adding unique names on each day. really do apologise!!

  11. #86
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: VBA to Copy set data, paste into set cells, then copy more & set into cells related 2

    No problem at all. Can we mark this as solved now?

  12. #87
    Forum Contributor
    Join Date
    11-02-2011
    Location
    Rugby, England
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    844

    Re: VBA to Copy set data, paste into set cells, then copy more & set into cells related 2

    Hi Arlu,
    I will mark as solved, hopefully we can put this one to rest!
    Thank-you very much indeed for your support!

  13. #88
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: VBA to Copy set data, paste into set cells, then copy more & set into cells related 2

    You are welcome. It was a nice and challenging thread to work on.

  14. #89
    Forum Contributor
    Join Date
    11-02-2011
    Location
    Rugby, England
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    844

    Re: VBA to Copy set data, paste into set cells, then copy more & set into cells related 2

    Hi Arlu,

    As mentioned previously

    There is a description on the last tab
    Attached Files Attached Files

  15. #90
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,145

    Re: VBA to Copy set data, paste into set cells, then copy more & set into cells related 2

    Will try it out and let you know shortly.

+ Reply to Thread
Page 6 of 7 FirstFirst ... 4 5 6 7 LastLast

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