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?
Bookmarks