Transferring information from a master worksheet into secondary worksheets.

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. I update this spreadsheet on a daily basis so I need it to feed the information to the secondary spreadsheets as I update.

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. I posted this before and got a code to use, but it didn't include updating it every day.

Try this. You might need to edit the columns of the sub-sheets since the columns on those sheets are not 100% match to the master.

Please Login or Register  to view this content.