How do I allign columns with different numbers of things?

[larryg003]

Hi guys,

I would be eternally grateful if you could help me with this!!!

I have 4 columns:
In column A I have 100 random days.
In column B I have 500 days that are in order. In C and D I have data which lines up to the date in Column B.

How do I sort so that the order of A is unchanged and Excel will automatically match
the first value of Column A with Column B (based on the same date) and the corresponding data in C & D?

THANK YOU SO MUCH!

[JBeaucaire]

Based on what you've said so far, I'd guess a LineEmUp macro would have to do it. Is VBA OK?

If so, post up a good example workbook (not too small) and I'll see if I can whip something up for you.

Click GO ADVANCED and use the paperclip icon to post up your workbook.