F
fdtoo
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
fdtoo,
Thanks!
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
fdtoo,
Thanks!