search column for text, if found, paste value in a different column in new sheet

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.

attach please a sample with before and after

Maybe you are right, but I'm lazy and not very intelligent

patel45,

Thanks for the reply. I attached the example I posted. I've figured out that what I need is an If Then ElseIf statement to separate the Ks and the Vs and then a Loop to make Excel go through all the data, but I'm not savvy enough to write the code on my own just yet.

There's also the problem of inserting blank rows after each account. Some of these accounts go on forever, so I wasn't sure how to insert them after Excel recognizes it has gone through the data for one account.

patel45, that is amazing. Thanks!