Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Combining Data from 2 Colums to 1 Column

  1. #1
    Guest

    Default

    I have two colums one with Year in 2002
    format, another with the month in the 1, 2, 3, 4 format. I need it to be in the MMDDYY format
    Column A | B | C | D |
    so 2002 | 1 | Data | MoreData|

    will be copied to ANOTHER SHEET as

    Column A | B | C | D
    1/1/2002 | dATA | mORE dATA |

    How do I combine this in a macro?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Perth Australia
    Posts
    1,584
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    You say you want it in MMDDYY format - where is your data for the day, or is it always the first of the month?
    Derek

  3. #3
    Guest

    Default

    Derek,
    The data can be formatted as first of the month. Meaning if column A reads 1 (Jan) and B reads 2002, for it to combine it and paste it onto another cell as
    1/1/2002. Again if A reads 2 (Feb), B reads 2002..it copies it over as 2/1/2002, etc.
    thanks for your help!
    vanessa

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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