2 Worksheets sharing data

J

Joey041

I am trying to get away from the cut and paste world. I have a data dump
that I sort and from that result I have certain fields that I add to a report.

I am trying to find a way to automate this. I am used to formulas (count,
Counti). Is there a formula that I a missing to display data rather than
totals?

Thanks in Advance
 
D

David McRitchie

Hi Joey,
Of course not. a formula can only return a value.

As to the question itself, too ambiguous as to what you are
looking for. Try recording a macro and see what you get.
A recorded macro is very seldom sufficient in itself but it does
help to show you what you might use within a macro subject to
necessary changes to handle such things as any selection range..
 
D

David McRitchie

Hi Joey,
Different answer --- Please, please, please put the
entire question into the body of the question.

The question is still very ambiguous as to whether
the ranges on sheet1 will change but if they are fixed
you can use formulas like
=Sheet1!B2 + Sheet1+C2
=SUM(Sheet1!B2:B20)
='Sheet One'!B2

You can enter = sign into a cell, go to the
other sheet click on a cell and return to the original sheet
to find the cell included in the formula.

An example of a summary page from several other sheets
can be found in
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm
it isn't pretty like for a nice report but it is an interesting
example of grabbing descriptive titles and data from pages
all with the same format.
 
Top