I have a workbook that will have lots of worksheets in it. I want to be able to use one worksheet from the workbook to be able to update columns and rows of the other worksheets in the workbook.

I have created a macro in the master/main worksheet that will open a userform that will allow me to insert a clients name into it an then that macro will place the clients name onto the spreadsheet and create a new worksheet with that clients name on it.

I want to be able to do two things:

Part I
I want the information that is in 'row 11' of the main/master page copied over to the worksheet with the username on it. So everytime I add some info to 'row 11' on the main/master worksheet that info will automatically be added to the worksheet with the usersname on it. By the way the worksheet with the usersname is being created by the copy of another worksheet and is simply being renamed.

Part II
I think this is going to be the tricky part. I want all of the information from the 'row' on the main/master worksheet that has client name on it be added to the worksheet that has the same name as the client. So if I have:
Jackson, Charles on row 15 of my main/master worksheet and a worksheet with the name Jackson, Charles I want to be able to type in the number 7 on the main/master worksheet on the same row as the name Jackson,Charles and have the number 7 appear on the worksheet with the name Jackson, Charles.

with this code completed I would like for the spreadsheets to look something like this:

main/master
'row 11' nails apples blue things night sun
Jackson, Charles 7 8 10 14 20 1

worksheet named Jackson, Charles
Nails 7
apples 8
blue 10
things 14
night 20
sun 1

This is the code I am using on the main/master to copy and create the user worksheet
Please Login or Register  to view this content.
I know that I have used alot of words but I know (think I know, but I know that I dont know) the code needed to do this is no that difficult for someone versed in vba coding which I am not.

thanx.