sindhuja
03-07-2009, 10:53 PM
Hi,
Here is my requirement…
I have an excel with some sample data…
I want the counts of all the accounts with the below criteria excluding the accounts in the sheet 2. Also want the counts in the sheet 3.
< -100k , (-100k) to (-500k) , > -500k , 100k to 500k , >500k
Also another set of account to be distinguished separately from others.
Search for the accounts – corresponding subtotal and the cell value next to the subtotal cell…
Am not sure whether this can be done using macro… any help on this will be highly appreciated..
Immediate help will be highly helpful…
-Sindhuja
Here is my requirement…
I have an excel with some sample data…
I want the counts of all the accounts with the below criteria excluding the accounts in the sheet 2. Also want the counts in the sheet 3.
< -100k , (-100k) to (-500k) , > -500k , 100k to 500k , >500k
Also another set of account to be distinguished separately from others.
Search for the accounts – corresponding subtotal and the cell value next to the subtotal cell…
Am not sure whether this can be done using macro… any help on this will be highly appreciated..
Immediate help will be highly helpful…
-Sindhuja