+ Reply to Thread
Results 1 to 8 of 8

Macro to Conatenate dynamic data

  1. #1
    Registered User
    Join Date
    05-04-2012
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2003
    Posts
    14

    Macro to Conatenate dynamic data

    Hi Experts,

    Very Good Morning !!!!

    I have learnt about VBA coding with the help of you all guys thanks very much for that.

    Now i'm facing a different problem i'm not sure whether i'm very weak in making the logic or the scenarion itself is difficult.

    Let me explain you about my work.

    We are internet providers in India i have to prepare a report on monthly basis,which will have around 40 sheets of (Hell for me data),I have attached screenshot of 1 sheet in which data would be something like in the attached pic .I need to concatenate all the rows of A & B in column C its hard to explain also.

    Any help would be greatly appreciated.

    Thanks,
    SSG.
    Last edited by 6StringJazzer; 07-19-2015 at 08:12 AM. Reason: Attachments deleted at OP request

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Macro to Conatenate dynamic data

    xls file would be more helpful
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    05-04-2012
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Macro to Conatenate dynamic data

    Hi Patel,

    Thanks for your response !!!

    Please find the attachment.


    Thanks,
    ssg.
    Last edited by 6StringJazzer; 07-19-2015 at 08:13 AM. Reason: Attachments deleted at OP request

  4. #4
    Registered User
    Join Date
    05-04-2012
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Macro to Conatenate dynamic data

    Hi Experts,

    Someone please shed few logics or tricks to make my life easier.

    Hoping for few logics alteast.


    Thanks,
    SSG.

  5. #5
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Macro to Conatenate dynamic data

    I did not understand your goal

  6. #6
    Registered User
    Join Date
    05-04-2012
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Macro to Conatenate dynamic data

    Goal is simple,In column C there are formaules "Concatenate",I want that to be done through a macro,I have around 40 sheets and more than 1000 rows to add that formaule and it is all to be done manually because in column A and B is dyanmic which is not fixed.

    I hope you understand my pain area.

    Thanks,
    SSG

  7. #7
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: Macro to Conatenate dynamic data

    Please Login or Register  to view this content.

  8. #8
    Registered User
    Join Date
    05-04-2012
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Macro to Conatenate dynamic data

    Hi Patel,

    You made my life easier that is simply superb.

    Thanks a lot for all your efforts.

    Thanks,
    SSG.

+ 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