Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating worksheets based on lines of information from anotherworksheet
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating/Naming New Worksheets Based on Select Cells in Master Worksheet | Excel Worksheet Functions | |||
Creating number of worksheets based on list | Excel Discussion (Misc queries) | |||
Creating A Summary Sheet With Information From Several Worksheets | Excel Discussion (Misc queries) | |||
Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? | New Users to Excel | |||
Record information is on two lines | Excel Discussion (Misc queries) |