PDA

View Full Version : [SOLVED] Searching a file for information



oam
11-26-2013, 05:48 PM
I am making a combined report that takes numerous Excel files that are generated by a Master database and compiles them into a logical report. The Excel files are generated by the Master database and exported and save the server. The report I am making goes out to these reports and pulls in the required information to complete the report. The problem is, when the Master database generates the export files that are used in the report, the information does not always come out in the same rows and columns every time, and sometimes, some of the cells are merged which makes matters worse. What I would like to know, is there a formula or macro that will search a range of columns (see picture below) and find a phase like “Production Total” and look across the row and find the number at the end of the row and return that number?

Thank you for your help.

10873

snb
11-27-2013, 02:38 AM
sub M_snb()
msgbox cells.find("Production Total").address
End sub

oam
11-27-2013, 08:27 PM
Where will this output to?