Rows of information from a single sheet, split them and turn them into multiple sheets

I am putting together a database of employee information. Each employee is their own row, with each column identifying various employee information. Some of the columns include start dates, trainining dates, projects, end dates, as well as contact numbers.

What I want to do is to take this single sheet, and make it so the rows of informaiton will pupulate individual employee information sheets, which I can then add additional information that isn't required on the main datasheet.

Or would it be easier to creat something in Access? If so, how would I go about doing that?

Any help would be GREATLY appreciated!

Brock

Welcome to the forum!

My suggestion is that you move all the info to a Employee sheet. Then have a Summary or Master sheet using cell references to the other sheets. This way, when you update the Employee page, the Master will update automatically. And the master sheet will only have the information required for that sheet.

It can work the other way.

What I want to do is to take this single sheet, and make it so the rows of informaiton

Are you wanting to automate the creation of the sheets, or just techniques on linking the two?

Why don't you post a sample workbook of what you have and a employee sheet of what you're expecting?

Look at each sheet, you will see the name. Now go back to PersInfo and change the last name. Now look at the other sheets again and see the change.

Try this version.

OK, I had to go watch a couple of training videos to get this one. ;-)

On Snuffy's page, you have to hard code cell B3 using the concatenating formula. This brings the Last, First onto the page. Then the formula in C5 and E5 use B3 to go get all the other info. This formula will work even when you have two of the same last names. (Hopefully, you won't have the same First names!

The only difference in C5 and E5 is the last number, which designates the column of the array PersInfo!A3:W47.

When you edit this formula, you have to use Ctrl-Shift-Enter, as this is an Array formula.

Once you get all the formulas in place, rename this sheet Template and use it to insert a copy of the sheet template when adding new member sheets.

I can add a Ribbon tab for workbook utilities if you like.