1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Help needed in trying to create a Macro? to cut, and concatenate rows in Excel

Discussion in 'Business Applications' started by Icke_F, Apr 17, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. Icke_F

    Icke_F Thread Starter

    Joined:
    Apr 17, 2012
    Messages:
    11
    bomb #21, did you see the new Test Data.xlsx I previously attached, and why it wasn't working with the summarizer macro you gave me? I've tried it a few times, but it keeps giving me a column full of formula values as data (instead of the actual years as the data).

    Please let me know either way, as I'm trying to get this sorted out asap. Thanks.
     
  2. Garf13LD

    Garf13LD

    Joined:
    Apr 17, 2012
    Messages:
    455
    :confused::confused::confused:
     

    Attached Files:

  3. Icke_F

    Icke_F Thread Starter

    Joined:
    Apr 17, 2012
    Messages:
    11
    Garf13LD, WOW! You hit the jackpot. That works like a charm!!!

    Thank you sooo much. I really appreciate your help.

    Thanks for your time and effort.
     
  4. bomb #21

    bomb #21

    Joined:
    Jul 1, 2005
    Messages:
    8,271
    Not until now. The answer is the original column B is text format -- not something that could be discerned from screenshots in the first instance.
     
  5. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1049742