Transferring info from a master worksheet to secondary worksheets

[NFregia]

I have a spreadsheet set up that we use to keep track of our job numbers.

Each job has the job number, date started, description, etc. across the worksheet in a row so I need to copy the information for the entire row.

I want to set it up so that the first column is the project manager's initials and the entire row is copied/transferred to a secondary worksheet for each Project Manager.

Is there a way to do this that is fairly simple? I am not a programmer and have no idea how to work with macros.

[icestationzbra]

there are a few ways of doing that based on how your data are laid out, all without coding.

please attach a sample worksheet so that someone can assist.

[NFregia]

Test - JOB Log 2012.xlsx

I hope that worked. I'm new to this forum and not sure if I attached it correctly.

[arlu1201]

You can use this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:

Choose Tools | Macro | Macros
Select a macro in the list, and click the Run button

[NFregia]

Do I store it on the Master worksheet or the secondary?

[NFregia]

Never mind, I got it and thank you so much. It worked!

[NFregia]

The code above worked to feed the information into the secondary worksheets, but I update this worksheet as we get new jobs (usually daily) and therefore need it to update the secondary spreadsheets with every new addition. I apologize for not making that more clear intially. Can this be done?

[arlu1201]

Can we clear out the previous update and then put in the complete data set?