excel 2003 create summary sheet using conditional formulaes

carrach · 09-22-2009, 09:01 AM

I need to create a spreadsheet using information available in 5 other spreadsheets. I want to use a formulae that looks for company size in two different columns using OR (if med or large in either column but not if small), I then want each company found, to be copied to the new spreadsheet along with the information in two more columns (non-consequtive) in same row. I would then need to find the information within 2 more workbooks that match the company name found but can't work out how to do it. Also because only some of the available companies would be selected, I would like the findings to be placed into the next available line on the new spreadsheet. Is this possible. I have only been able to create a spreadsheet the same size as the original but with empty rows where the information does not match the company size. Help

09-22-2009, 09:01 AM	#1 (permalink)
carrach Registered User Join Date: Sep 2009 Posts: 5 OS: windows xp	excel 2003 create summary sheet using conditional formulaes I need to create a spreadsheet using information available in 5 other spreadsheets. I want to use a formulae that looks for company size in two different columns using OR (if med or large in either column but not if small), I then want each company found, to be copied to the new spreadsheet along with the information in two more columns (non-consequtive) in same row. I would then need to find the information within 2 more workbooks that match the company name found but can't work out how to do it. Also because only some of the available companies would be selected, I would like the findings to be placed into the next available line on the new spreadsheet. Is this possible. I have only been able to create a spreadsheet the same size as the original but with empty rows where the information does not match the company size. Help