| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Sumif of Sheet1 into Sheet2
How do I summarize from Sheet1, Purchase Order Amount, by Project &
Vendor into Sheet2, with VBA only, not thru a direct Pivot table. Data is already sorted by Project & Vendor .. Data Source : Sheet1 Column A : Project Code Column B : Vendor Name Column C : Purchase Order # Column D : Purchase Order Amount .. How do I use a Dynamic Sumif to achieve this Summary ? Help appreciated, .. Celeste |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
| +/- in sheet2 based on conditions and dynamic rows in sheet1 | Excel Discussion (Misc queries) | |||
| A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated | Excel Programming | |||
| how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
| [=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') | Excel Worksheet Functions | |||
Threaded Mode
