Matching row data from multiple columns

**cmw52** · 10-11-2009, 06:30 PM

Hi

I am trying to organise data from multiple columns and need some help to find a quick way of doing it.

To explain the problem. I have stock values for two stocks on trading dates where the trading dates become out of sync (the trading dates are different for different countries), but want to align the row data into a new worksheet (Eg Column A = dates, Column B = stock values, Column C = dates, and Column D = values of different stock). A and C start on the same date but after a certain number of rows become out of sync, and the only way i have found is to go through the sheet manually and move the data around.

So what i want to do is to create a new worksheet with the dates in column A, b stock values on dates given in column A, but also want the D stock values on the matching dates given in column A.

Can someone help? Im fairly new to vba.

Thanks guys

**JBeaucaire** · 10-12-2009, 12:57 AM

Mockup a sample worksheet with 20 rows of data or so, then mockup your sample desired results. Click GO ADVANCED and use the paperclip icon to post up your workbook.

You may not require a VBA solution, but we'll take a look.

**cmw52** · 10-12-2009, 12:02 PM

Hi

Thanks for your response. I have attached the workbook with the data in.
I have tried to use the lookup command in column H, which works fine until row 27. See the colour coded cells.

There is also a module within the sheet with a couple of subs that i have tried to use to do the same thing, which again works to some extent, but not completely.

Thanks for your help. Its been bothering me for too long.