macro compare autosum and write to worksheet

K

Ker

Joined
Feb 20, 2006
Messages
2
Reaction score
0
I have created a macro to hide colums and open a worksheet. Now i need it to compare words in one column and add numbers in next column if they are the same Then write the description and total to another worksheet.
eg.
worksheet 1
Col A Col B
5 Apples
7 Apples
3 Oranges
8 Oranges

Worksheet 2

12 Apples
11 Oranges

thanks for any help much appreciated
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro compare sum write 0
Simple nested if and statement 2
Macro to add numbers in a text string 5
Finding Next Largest Number Based on Criteria 3
sum if column is equal to 2 options 3
Macro to align and compare multiple rows and columns 1
Min-Max question 6
Is there a way to parse multiple values in a cell and applycalculations to those cell ? 1

Top