Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Searching 2 columns for dates and text problem
I have two worksheets in a single workbook.
WS1 Col A contains dates; Apr-06 thru Mar-07 over a 1,000 rows Col B is populated with 15 unique category descriptions over the 1,000 rows. (lets say the descriptions are Cat1, Cat2, Cat3€¦Cat15) Col C is a currency Im looking for a VBA solution to satisfy the following€¦ For each occurrence of the current month in Col A, If true... for every occurrence of a category match in Col B, roll-up the values in Col C and place the SUM in Cell A1 of WS2. Hope this makes sense. Any ideas appreciated. Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concantenate columns with dates and text | Excel Worksheet Functions | |||
Problem searching cell text | Excel Discussion (Misc queries) | |||
problem summing columns with dates | Excel Worksheet Functions | |||
searching text values in two columns | Excel Discussion (Misc queries) | |||
comparing columns of text (cross-searching) | Excel Discussion (Misc queries) |