Auto updating a table
 

If I have the following table (sheet1):
A 1 2 3 4 5
B 4 5 6 7 8
C 1 9 0 3 7

...and then (sheet2)

A 1
B 1
A 2
C 6
B 2
A 3
...is there a macro or programme I could run which would insert the
values from sheet 2 in order into the rows on sheet one to give:
A 1 2 3 1 2 3 4 5
B 1 2 4 5 6 7 8
C 6 1 9 0 3 7


Thanks very much!


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=549452

Auto updating a table
 

You might record part of this into a macro to make it "Auto".
Pivot Table Multiple Consolidation Ranges
Range: Select the data on sheet2; include top blank headers.
Layout: Drag Column button from Column field and
drag in Value button instead.
Data field: Count of Value
Options: No grand totals
Part of he Pivot Table will then look like this:
1 2 3 6
A 1 1 1
B 1 1
C 1

Name the Count of Value matrix <array1
Name the Column field <vect1
Create another matrix with this array formula:
=IF(array10,vect1,"")
Copy Paste Special Value
The matrix will then look like this:
1 2 3
1 2
6
Insert this matrix in the proper place on sheet1.
Remove the blank spaces and left justify with
Goto Special Constants Text
Delete Shift Left