Hi, I'm new to macros and variants of this question is probably asked all the time, but I'm having trouble copying certain parts of my data to a new worksheet. What I want is an Excel macro to search Sheet1 column A, find a value ("K" for example), and if found, paste the corresponding value in column B into Sheet2 ("column C"), for example. Then I want it to go through all the Ks in the column.

Then I want to run another search for "V" and if found, paste the corresponding value in column B into Sheet2 Column D this time.

I would like to have the data separated by Accounts.

So the data looks like this:

Sheet 1
Acct A - K - 50 - $2
Acct A - K - 100 - $3
Acct A - V - 75 - $2
Acct B - K - 25 - $1
Acct B - K - 100 - $1
Acct B - V - 50 - $1
Acct B - V - 75 - $1

And I want the output to look like this:

Sheet 2
Acct A - 50 - - $2
Acct A - 100 - - $3
Acct A - - 75 - $2

Acct B - 25 - - $1
Acct B - 100 - - $1
Acct B - - 50 - $1
Acct B - - 75 - $1

(Each dash signifies a different column)

I have searched this forum and many others, got a bunch of codes but I wasn't able to tweak them to work for my particular situation. Any help would be much appreciated.