Macro Date Testing

B

BKBK

I need to know how to write macro that will date test each line and cop
info to another spreadsheet-
First spreadhseet

Jan 15, 2004 xxx yyy


March 11, 2004 www xxx


May 22, 2004 zzz aaa

Want to copy info to this spreadsheet below with the first column no
changing

Jan-04 xxx yyy

Feb-04

Mar-04 www xxx

Apr-04

May-04 zzz aa
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Write a Macro to retain rows based on certain criteria 1
How to getting text labels to show up in scatter chart. 0
Form return lookup values 1
Calculating occupational sick pay entitlement 0
I need to help with Excel (beginner) -- year row and month column 2
Sorting CSV Data By Date 8
Help w/Duplicates & Macros 5
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0

Top