Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I automatically generate a worksheet.
Hello
I wish to generate a worksheet based on the contents of a csv file. For example, if the csv file contained the following data: 0,Example Report 1.Group Heading 1 2,500 2,650 1,Group Heading 2 2,890 9,END,0 I would want to generate a worksheet which looks like this Example Report (Cell A1) Group Heading 1 Sales (Cell A2 and the word 'Sales' in cell B2) 500 (Cell B3) 650 1150 (Cell B4 and SUM(B3:B4) in C4) Group Heading 2 Sales (Cell A6 and the word 'Sales' in cell B6) 890 890 (Cell B7 and SUM(B7:B7) in C7) Total Sales 2040 (The words 'Total Sales' in A9 and SUM(C4:C7) in C9) The csv file can be loaded into a separate worksheet for data to be transferred to the main worksheet. The basic format of the report would always remain the same but the number of headings and number of entries under each heading is variable. I am assuming that because of the variable nature of the data I cannot set up a standard template. I am quite happy to generate the cell definitions, e.g. B7=Sheet 1!B$6, outside Excel or generate them after the csv file has been imported. What would be the best approach? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I automatically generate a worksheet.
Sorry about the layout. That's not how it looked when I posted the question.
I don't know how to stop it being reformatted but hopefully from the cell numbers you can see what it should look like. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert row and automatically generate field in new row | Excel Discussion (Misc queries) | |||
generate automatically sum | Excel Worksheet Functions | |||
Automatically generate letter | Excel Discussion (Misc queries) | |||
How do I automatically generate an invoice number | Excel Worksheet Functions | |||
How do I automatically generate dates? | Excel Discussion (Misc queries) |