I have two tabs, sheet1 and sheet2. I am pulling data from sheet two
and pasting it on sheet1. Sheet1 already has data in it from previous
updates. Here is what I am trying to do.

I want it to find the value in cell A8 on Sheet2. Then look on sheet1
for that value in column F. If it finds that value then cells B to K
of that row need to be cleared.

Big pictu Find value in F8 on sheet2. If that value exists on
sheet1 (if it exists it will esist in several rows) then find the rows
it is in and clear the contents of columns B to K. Then paste the
values from row 8 on seet 2 into the place where it existed before on
sheet1. Check to see if the next row after 8 has the same value. If it
does paste it below the previous paste on sheet one, adding rows as
necessary.

Example:

Pre-Paste
Sheet 2
0100 Product 1 54% 63%
0100 Product 2 89% 56%

Sheet 1
xxxxxOther dataxxxxxx

0100 Product 4 78% 90%
0100 Product 5 34% 14%
0100 Product 6 23% 74%

xxxxOther dataxxxxxxx
Post-Paste Sheet 1
0100 Product 1 54% 63%
0100 Product 2 89% 56%