Data Source for a Range

  • Thread starter Thread starter cyan
  • Start date Start date
C

cyan

I'm working on an application that requires repeatition of a range of
cells. I need a way to point to a section of information--and pull it
into several worksheets.


Is there a way to reuse a pivot table? Can I assign a cell a pivot
table? Or can I use a formula to assign a range of cells?


I'm working with Excel 2002.
If you need more info let me know--
Cyan
 
-----Original Message-----
I'm working on an application that requires repeatition of a range of
cells. I need a way to point to a section of information--and pull it
into several worksheets.


Is there a way to reuse a pivot table? Can I assign a cell a pivot
table? Or can I use a formula to assign a range of cells?


I'm working with Excel 2002.
If you need more info let me know--
Cyan


---
Message posted

.
Try using a named range. Then refer to it in the other
Click to expand...
worksheets. To do a named range select the group of data
you need to repeat then click in the "Name Box" to the
left of the formula bar, and type in a name. *Hint*: No
spaces! Then you can use the name anywhere in the
workbook.
 
Seems a strange question because Excel is set up so we have numerou
methods of referring to a range of cells (even if it is a single cell)
in a worksheet from somewhere else.

1. What is your base data (table or separate cells) ?
2. What do you want to do with it ?
3. Are you using VBA or formulas ?


It looks like a case of having a workbook containing your base data an
pivot tables and referring to that with formulas.

After many years of producing reports from large amounts of databas
output I have found that the separate process of :-
Raw Data listing -> Pivot Table -> Report is best. Only the fina
reports require any special formatting. This is fast and extremel
flexible when changes occur because the raw data is not changed in an
way - except by the addition of any calculated columns
 
Back
Top