Buiding Array Formula
I would like to create a Macro that would at least help me on th following: 1) to copy the content of an excel filename"SaleForecast.xls" under Worksheet name="Sales" to another excel filename="ForecastSummary.xls under worksheet name="SalesSummary" 2) to look for a row of data that fits the following conten criteria,e.g. look for cell value where Sales is 1000, Saleperson = John & Sales is 75%: ColumnA ColumnB ColumnC Sales Saleperson Sales % 5000 Carmen 75 1000 John 30 8000 Weller 75 2000* John* 80* *Note:Above data is under worksheet name "Salesman" and the whole rang of cell where data are marked in * are required to be copied to a ro below cell where value="Backlog" under worksheet name "SalesSummary" under th same excel file 3) Using example above, to create a formula that will sum up all valu under Sales Column where Sales % is =75%, Saleperson = Carmen & Sales i 4000 fdtoo, Thanks! -- fdto ----------------------------------------------------------------------- fdtoo's Profile: http://www.excelforum.com/member.php...fo&userid=2579 View this thread: http://www.excelforum.com/showthread.php?threadid=39201 |
All times are GMT +1. The time now is 09:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com