I am trying to create a master spreadsheet with the main sheet providing all
of the data. I would like to copy information so as to display relevant data
on different sheets. For instance, On one part of my master sheet, I have a
Houston section that provides sales figures that have embedded formulas. I
would like to copy that portion of the spreadsheet and copy it to another
sheet, yet still linking them so when changes are made to the main
spreadsheet, it will adjust the info on the new sheet. I am using Excel
2007. Any help would be greatly appreciated!!!

Thanks!

Try this sample construct from my archives:
http://www.savefile.com/files/430142
AutoCopy Lines to Resp Sht Non Array.xls
(Full details inside, nicely rendered. Easy to adapt ..)

Data is continuously entered in a master ("parent") sheet, with lines neatly
auto-copied to each individual ("child") sheet based on the values within a
key col.

In the sample, the key col in the master sheet is the "State" col, which may
contain eg: NY, CA, NV, SD, AZ, etc. All lines with "NY" in the key col will
be auto-copied to the sheet named: NY, and appear neatly bunched at the top,
w/o any intervening blank lines. Ditto for lines with "CA", "NV", etc which
will be copied into their respective sheets.

Propagation of the "child" sheet is as simple as making a copy of the
initial one, then renaming it accordingly as the next key col value. Eg we
first formulate one child sheet for "NY", dress it up nicely, then just make
copies of the "NY" sheet, and rename these as: CA, NV, SD, etc.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Steve" wrote:
I am trying to create a master spreadsheet with the main sheet providing all
of the data. I would like to copy information so as to display relevant data
on different sheets. For instance, On one part of my master sheet, I have a
Houston section that provides sales figures that have embedded formulas. I
would like to copy that portion of the spreadsheet and copy it to another
sheet, yet still linking them so when changes are made to the main
spreadsheet, it will adjust the info on the new sheet. I am using Excel
2007. Any help would be greatly appreciated!!!

Thanks!