Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summarising Information from other files
I have a total of 150 files (file1 to file150) containing performance
information and I want to be able to automatically produce a file containing summary information. What I need is a formula that will identify the row containing the phrase "All Transactions" and then copy the rest of the row to the summary file. This formula would then be replicated for each detail file to allow me to produce 150 lines of information in the summary file. Can anyone help me out with the formula that I need? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Issue opening csv files in Excel | Excel Discussion (Misc queries) | |||
Recently Used File List - 2002 Contains 'Temp' Files | Excel Discussion (Misc queries) | |||
How do I unrestrict access to files Information Rights Mgmnt? | Excel Discussion (Misc queries) | |||
merging my excel files | Excel Discussion (Misc queries) | |||
put files together | Excel Discussion (Misc queries) |