Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Required Columner Data
Hello all,
I have an sheet where despatch data is being stored, another sheet is the unique item list. Now I wish to put the the vehilce wise details for the particular date in a unique item list sheet. I know, we can use pivot table but I want this to run through vba code as users are not conversant with pivot table. I am not very much conversant with vba macro. Can anybody help me by providing the codes to resolve this issue. Unique Item List Sheet Result for the date of 22/09/2008 PART_NO Sum GJ18T-1091 GJ6Y-5476 GJ6Y-6053 FAGM0034 20 20 FAGM0042 20 20 FAGM0044 20 20 FAGM0046 18 18 FAGM0049 0 FAGM0050 16 16 FAGM0052 16 16 FAGM0071 24 24 FAGM0074 40 40 FAGM0100 0 FAGM0126 26 26 FAGM0151 23 23 FAGM0153 24 24 FAGM0156 24 24 FAGM0157 40 16 24 FAGM0159 32 32 Despatch Data Sheet DATE VEH_NO PART_NO QTY 22/09/2008 GJ06Y-6053 FAGM0156 33 22/09/2008 GJ06Y-6053 FAGM0179 20 23/09/2008 GJ18T-1091 FAGM0162 18 23/09/2008 GJ18T-1091 FAGM0151 23 23/09/2008 GJ18T-1091 FAGM0178 40 23/09/2008 GJ18T-1091 FAGM0183 40 23/09/2008 GJ18T-1091 FAGM0198 21 23/09/2008 GJ18T-1091 FAGM0201 40 23/09/2008 GJ18T-1091 FMGM0668 40 23/09/2008 GJ18T-1091 FMGM0642 40 23/09/2008 GJ18T-1091 FAGM0206 45 23/09/2008 GJ18T-1091 FAGM0179 20 23/09/2008 GJ18T-1091 FMGM0656 100 23/09/2008 GJ6Y-5476 FAGM0162 24 23/09/2008 GJ6Y-5476 FAGM0126 26 23/09/2008 GJ6Y-5476 FAGM0074 40 23/09/2008 GJ6Y-5476 FAGM0156 24 23/09/2008 GJ6Y-5476 FAGM0042 20 23/09/2008 GJ6Y-5476 FAGM0044 20 23/09/2008 GJ6Y-5476 FPGM0012 24 23/09/2008 GJ6Y-5476 FPGM0011 24 23/09/2008 GJ6Y-5476 FAGM0157 16 23/09/2008 GJ6Y-5476 FAGM0178 20 23/09/2008 GJ6Y-5476 FAGM0153 24 23/09/2008 GJ6Z-3075 FAGM0159 16 23/09/2008 GJ6Y-6053 FAGM0162 18 23/09/2008 GJ6Y-6053 FAGM0071 24 -- Thanks, Vikram P. Dhemare |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Required data entry | Excel Discussion (Misc queries) | |||
Required data in one sheet | Excel Worksheet Functions | |||
Conditional Formatting based on data in adjacent cell & restrict save without required data | Excel Programming | |||
Help required with Consolidating Data | Excel Worksheet Functions | |||
Removing lines of data that do not contain required data (macro) | Excel Programming |