LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
meaganbz
 
Posts: n/a
Default creating many individual files using a template from one spreadshe

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel creating temp files upon save. Joel Pratt Setting up and Configuration of Excel 2 May 18th 05 10:37 PM
printing - creating new files on each page break Tere Gardner Excel Worksheet Functions 4 May 4th 05 09:12 PM
creating multiple files from a spreadsheet Carol Summa Excel Discussion (Misc queries) 1 March 17th 05 12:07 PM
Creating PDF files from Excel. Chaplain Doug Excel Discussion (Misc queries) 2 December 16th 04 10:42 PM
Creating Individual Excel Files from Sheets Chaplain Doug Excel Discussion (Misc queries) 5 December 16th 04 09:03 PM


All times are GMT +1. The time now is 12:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"