Creating worksheets based on lines of information from another worksheet
- From: gan.lawrence@xxxxxxxxx
- Date: Tue, 22 Apr 2008 16:20:22 -0700 (PDT)
I'm basically trying to create a database in a single excel file. My
first work*** 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
work*** 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" work*** 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!
.
- Prev by Date: Re: Excel document incorrectly applying read-only
- Next by Date: Re: Excel document incorrectly applying read-only
- Previous by thread: Moving data from one column to another
- Next by thread: Open UTF-8 in Excel 2007
- Index(es):