Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
merge pairs of columns
Hi I have 3 pairs of columns (A,B; C,D; E,F), the first column in each pair has dates and the second column has some values. I want the data to be merged into a new set of columns (G,H,I,J) in such a way that the dates from all 3 sets of data are displayed chrnologically (i.e. sorted in ascending way as per date value) in column G and corresponding values are displayed in columns H, I and J. Could anyone please suggest vba code for doing this; since the data involved is huge and it is a repetitive exercise, help appreciated. thanks in advance mpr -- mpreddy ------------------------------------------------------------------------ mpreddy's Profile: http://www.excelforum.com/member.php...o&userid=13274 View this thread: http://www.excelforum.com/showthread...hreadid=535897 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing pairs of cells in four columns | Excel Discussion (Misc queries) | |||
Sum product of many pairs of columns | Excel Worksheet Functions | |||
Remove Duplicate Pairs(2 Columns) | Excel Programming | |||
merge multiple files from text list of file pairs | Excel Programming | |||
Merge file pairs | Excel Discussion (Misc queries) |