Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts

    Create column,move all strings to column A and fill series

    Hello experts.
    I have a data in sheet.First i need to insert a column A then move All the only String/Text of column B to column A. After that fill the series via text name when new string/name comes it start filling with the new name.

    Before and After sheet is attached with...


    Thanks alot
    Attached Files Attached Files
    Last edited by farrukh; 2013-03-15 at 02:36. Reason: new name

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,828
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi farrukh

    nice to hear from you again.

    See attached file for my solution.
    If you want to change sheet names, you will need to aslo change them in the vba code.

    zeddy
    Attached Files Attached Files

  3. The Following User Says Thank You to zeddy For This Useful Post:

    farrukh (2013-03-15)

  4. #3
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts
    Respected Zeddy simply the best ... you have saved a lot of time for me...

    Is it possible that from column name " Session start " need to create session detail in a month like

    Month Days
    Oct-10 10
    Nov-10 15
    Dec-10 20
    Jan-11 4


    I mean to say count October days and show in days column same as next month which is available.

    Thank you

    farrukh
    Last edited by farrukh; 2013-03-15 at 07:18.

  5. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,828
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi farrukh

    Thank you for thanking me.

    I have attached a new file which has a new sheet [Detail] which shows the Count of how many sessions started in a specified month.
    In order to generate better test data, I modified the dates previously given in sheet [Before]
    (see colour coded cells where I changed the month and year)

    Now, when the data is processed, the formulas on sheet [Detail] will show results.

    Please note, I modified the vba routine and named ranges for this new version

    Please let me know if this is what you wanted.

    zeddy
    Attached Files Attached Files

  6. The Following User Says Thank You to zeddy For This Useful Post:

    farrukh (2013-03-15)

  7. #5
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts
    Respected Zeddy that's really great last thing in detail sheet column A please add formula to get auto pick month from After sheet column E . I mean distinct name automatically?

    Thanks for your always kind help

    farrukh

  8. #6
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,828
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi farrukh

    As requested.
    See attached file.

    I have updated the routine assigned to the button labelled [Process Data] on sheet [After]
    This will now automatically generate the month counts on sheet [Detail]

    I have also added buttons [Refresh Counts] to sheet [Detail], to demonstrate the routine for you.
    If you have any questions, just ask.

    zeddy
    Attached Files Attached Files

  9. The Following User Says Thank You to zeddy For This Useful Post:

    farrukh (2013-03-15)

  10. #7
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts
    Respected Zeddy,
    Wonderful really appreciate your kind help... you always help all...
    Best wishes

    Thank you
    farrukh

Posting Permissions

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