N
NonIllegitimiCarborundum
Greetings all,
I'm trying to build a formula (maybe only a macro can do this?) that will:
1. search through several worksheets in a workbook for a variable date that
I assign each time I run it
2. return the dollar amount figure in the cell to the right of each date
that matches my parameters
3. add all these dollar amounts together in a cell on a summary worksheet
Thanks in advance for any suggestions!
Pat
I'm trying to build a formula (maybe only a macro can do this?) that will:
1. search through several worksheets in a workbook for a variable date that
I assign each time I run it
2. return the dollar amount figure in the cell to the right of each date
that matches my parameters
3. add all these dollar amounts together in a cell on a summary worksheet
Thanks in advance for any suggestions!
Pat