Here is what I am trying to do. I am not sure how to write this macro.

Given:

Table1.xls
Contains a table on sheet1 A1:F1000.

Fruit Client Price
1 2 3
2 5 6
4 8 2

Goals:

1. find cell A2 on sheet1 and create a new sheet with that name. (Ex hen new sheet is called “1”).

2.Copy values Client to sheet “1” cell B5

3.Copy values price to sheet “1” cell C5

4-Do this for all values in column A. (For fruit1, 2 and 3)

I have no idea where to start here...any suggestions?