Creating worksheets based on lines of information from anotherworksheet

G

gan.lawrence

I'm basically trying to create a database in a single excel file. My
first worksheet contains lines of information - each line contains a
single project with different points of information in each column.

What I want to do is for the excel file to automatically create a new
worksheet for each line of information, filling in all the information
accordingly in an outline fashion.

So for instance, if I have 5 project, 5 lines - I should have 5
worksheets, one for each line, each project. All the sheets following
the initial "list" worksheet will be of the same format - so if
perhaps its easier to make some sort of "form skeleton" and have excel
fill in the data accordingly, that would work too.

Any help would be greatly appreciated! Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top