Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro to make a cum list
I have a number of xl files located in the same folder. I would like to have
a macro which runs through the files, finds the name from B1, copies it to cum list and cums all the codes from the sheets which has this name on. Also this macro should populate data only from files which have the date matching into given time interval in B2. A B C D 1 name 2 code date 3 A 4 B 5 C 6 D 7 E 8 It should appear something like below assuming there were 3 of code A, 0 of code B, 2 of code C, 5 of code D and 1 of code E found from files having name1 on. 1 2 3 4 5 6 A code A B C D E B name1 3 0 2 5 1 C name2 D name3 E name4 Great thanks for every reply -- Regards, veljo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can you make a drop down list in a drop down list? | Excel Discussion (Misc queries) | |||
insert date | Excel Worksheet Functions | |||
Data Val list Excel 97 fire macro | Excel Discussion (Misc queries) | |||
HOW DO I MAKE VALIDATION LIST CONTAING DATA FROM A DIFFERENT BO | Excel Discussion (Misc queries) | |||
Macro to change validation list and print | Excel Discussion (Misc queries) |