Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data table is not updating correctly in excel 2003 | Excel Discussion (Misc queries) | |||
excel table auto format total row should see sum formula already | Excel Worksheet Functions | |||
Auto table feature in excel doesnt work on multiple tables | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) |