Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm trying to determine if I can do this in Excel. Here's the project: I
need to create separate profiles for 225 individual schools using data that is stored in one spreadsheet. The schools are listed in rows with corresponding data organized in columns. I have a template of tables and charts that will be the same for each school, with only the data points being imported that are differenet for each school. Myt question is, is it possible to write a set of commands in Excel that will generate 225 individual files with the data I want in tables and graphs? Or, do I need to set-up each of the 225 files separately and cut and paste or link it? My client assumes that Excel has a data-merge feature that is similiar to mail merge. I've never used Excel to generate this many individual reports and I can't determine how to do it without manually configuring each new file and creating each pie chart or table separately. Suggestions? Are there other programs that I should look into? Thank you, Meagan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel creating temp files upon save. | Setting up and Configuration of Excel | |||
printing - creating new files on each page break | Excel Worksheet Functions | |||
creating multiple files from a spreadsheet | Excel Discussion (Misc queries) | |||
Creating PDF files from Excel. | Excel Discussion (Misc queries) | |||
Creating Individual Excel Files from Sheets | Excel Discussion (Misc queries) |