+ Reply to Thread
Results 1 to 6 of 6

two macros concatenate and copy paste

  1. 06-28-2010, 10:24 PM #1
    rsheer
    rsheer is offline
    Registered User
    Join Date
    06-28-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    two macros concatenate and copy paste

    Hello excel experts.
    At work Im considered good in excel but I am not this good. I have a workbook attached to explain further.

    On Macro One tab I need to write a macro that takes the data in column 1 and places it in column 3 after applying the first cell to all of the cells in column 2. It then repeats until I have every combination and at the first empty cell after the last cell in column 1 and 2 is concatenate(d).... lol. non sure thats a word? The example is pretty self explanitory.

    On macro two tab. I need to do somewhat of the same thing but it copies and pasts a section of data and fills in column 2 with the data in sheet one. It continues to copy below until all of the data in sheet 1 is accounted for and ends the macro.

    I really really need help with this so if anyone has any ideas I am all ears. thanks
    Ryan
    Attached Files Attached Files
    Last edited by rylo; 06-30-2010 at 12:57 AM.
    Reply With QuoteRegister To Reply
  2. 06-28-2010, 11:53 PM #2
    rylo
    rylo is offline
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: two macros concatenate and copy paste

    Ryan

    Here's something for the first one you want.

    Please Login or Register  to view this content.
    With the second one, where is the data located on the relevant sheets? Exactly where you have it on macro2? Or is the data in some other location?

    rylo
    Reply With QuoteRegister To Reply
  3. 06-28-2010, 11:57 PM #3
    rsheer
    rsheer is offline
    Registered User
    Join Date
    06-28-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: two macros concatenate and copy paste

    Thanks for that one... I really appriciate it. The second one would be three sheets in a workbook. The first would have the data in column A. The second would have several lines (not sure how many yet) lets call it 7 and 7 columns wide. This data set would need to be pasted into sheet 3 and thats when it populates the second columns based upon the data in sheet 1. I hope this is making sense.

    Thank you so much for helping with this.
    Ryan
    Reply With QuoteRegister To Reply
  4. 06-29-2010, 12:04 AM #4
    rsheer
    rsheer is offline
    Registered User
    Join Date
    06-28-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: two macros concatenate and copy paste

    Here is a new workbook closer to what I am trying to accomplish
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 06-29-2010, 06:35 PM #5
    rylo
    rylo is offline
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591

    Re: two macros concatenate and copy paste

    Hi

    See how this goes.
    Please Login or Register  to view this content.
    rylo
    Reply With QuoteRegister To Reply
  6. 06-29-2010, 09:39 PM #6
    rsheer
    rsheer is offline
    Registered User
    Join Date
    06-28-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: two macros concatenate and copy paste

    Thats exactly what I needed. Thank you!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1