Copy data to other worksheets based

[joserborges]

Hello all,

I need some help. I have a simple worksheet which i have enclosed for your viewing. The sheets has six cloumns across one is a Tracking sheet and all the others surmise the data for the respective acct exec. where I need help: I need the sheet to copy the data on the tracking sheet to the respective worksheet for the acct exec.

For Example: On the main tracking sheet when the data is inputted into the columns that data should copy over to the respective sheet for the Acct Exec listed on the last column into the next available row in the acct executive respective worksheet.

I posted something similar before instead requiring data to post

[sktneer]

Try this code to see if this works as per your requirement. For detail see the attached sheet.

Please Login or Register  to view this content.

[joserborges]

maybe im doing something wrong. it isnt working.

[joserborges]

Bump...Please help.

[sktneer]

Please find the attached sheet. The problem was due to the red text I wrote in col. C. Now test the code by following the instruction in the sheet (red text).

[Pete_UK]

I've corrected the formulae you were trying to use and set this up for you in the attached file.

Be careful how you type the names in - I've assumed you want an initial followed by a full-stop and then a space before the surname.

Hope this helps.

Pete

[joserborges]

Pete and Sktneer,

Thank you both for the help. I've been away dealing with a terrible cold. I'll look into the sheets and respond with the outcome.