P
Peter Gasparik
Hi, I am a new in VBA and I am wondering whether someone can help me. I would
like to create a macro which will search for string value in a worksheet
“data†column “A†and if it finds the match it will take the integer value
from worksheet “Data†column “B†and copy it to another worksheet “Namesâ€
column “B2†and additionally make sum of the values as they are always a
numbers.
A B
Peter 3
Martin 4
Albert 5
Wendy 8
Danka 77
Wendy 8
Wendy 9
Many thanks,
Peter.
like to create a macro which will search for string value in a worksheet
“data†column “A†and if it finds the match it will take the integer value
from worksheet “Data†column “B†and copy it to another worksheet “Namesâ€
column “B2†and additionally make sum of the values as they are always a
numbers.
A B
Peter 3
Martin 4
Albert 5
Wendy 8
Danka 77
Wendy 8
Wendy 9
Many thanks,
Peter.