Transferring date from multiple worksheets to a "totals" worksheet.

Hi, would be most appreciative if someone has a solution to this. As I
am new to Excel I don't know if it is possible to do but hopefully it
is.

Here is the situation - I have a workbook with lots of different
worksheets. All of the sheets have the same columns. What I want to do
is whenever I add an entry into one of the worksheets that entry
automatically gets added onto the end of the totals worksheet.

eg

Sheet One
Property Date Price
X dd-mm-yy 123,456
Y dd-mm-yy 456,789

Sheet Two
Property Date Price
a dd-mm-yy 444,555
b dd-mm-yy 789.654

Totals
Property Date Price

=> Should contain data from sheet one and two in whatever order the
data was entered onto those sheets.

I hope the problem is clear and someone has a solution.
Many thanks,
Tony


--
tonyDeBrascoPosted from http://www.pcreview.co.uk/ newsgroup access

Hi Tony

If I understand you correct you can use something like this
http://www.rondebruin.nl/copy2.htm





--
Regards Ron de Bruin
http://www.rondebruin.nl


"tonyDeBrasco" <tonyDeBrasco.1sj0ny@> wrote in message news:wuydnZjIv4XNX0LfRVn_vQ@giganews.com...
>
> Hi, would be most appreciative if someone has a solution to this. As I
> am new to Excel I don't know if it is possible to do but hopefully it
> is.
>
> Here is the situation - I have a workbook with lots of different
> worksheets. All of the sheets have the same columns. What I want to do
> is whenever I add an entry into one of the worksheets that entry
> automatically gets added onto the end of the totals worksheet.
>
> eg
>
> Sheet One
> Property Date Price
> X dd-mm-yy 123,456
> Y dd-mm-yy 456,789
>
> Sheet Two
> Property Date Price
> a dd-mm-yy 444,555
> b dd-mm-yy 789.654
>
> Totals
> Property Date Price
>
> => Should contain data from sheet one and two in whatever order the
> data was entered onto those sheets.
>
> I hope the problem is clear and someone has a solution.
> Many thanks,
> Tony
>
>
> --
> tonyDeBrascoPosted from http://www.pcreview.co.uk/ newsgroup access
>

Many thanks for the help, it worked a treat alas no the bar has risen a
smidgen. Now I have to try and somehow grab a few sheets (all with the
title totals) from different workbooks and from those different sheets
generate an overall totals sheet. The columns on the individual totals
sheets are all the same.

So I think the total problem is:

- somehow allowing the user to indicate what workbooks they want to
grab the totals sheets from
- taking all the data off these total sheets and then creating an
"ultimateTotals" sheet...


If anybody has any ideas or suggestions as to how this could be done
(if it can be done) twould be great,

Many thanks
Tony


--
tonyDeBrascoPosted from http://www.pcreview.co.uk/ newsgroup access

Hi Tony

Try this
http://www.rondebruin.nl/copy3.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"tonyDeBrasco" <tonyDeBrasco.1ske3y@> wrote in message news:Gs6dnfUpKrM8IX3fRVn_vA@giganews.com...
>
> Many thanks for the help, it worked a treat alas no the bar has risen a
> smidgen. Now I have to try and somehow grab a few sheets (all with the
> title totals) from different workbooks and from those different sheets
> generate an overall totals sheet. The columns on the individual totals
> sheets are all the same.
>
> So I think the total problem is:
>
> - somehow allowing the user to indicate what workbooks they want to
> grab the totals sheets from
> - taking all the data off these total sheets and then creating an
> "ultimateTotals" sheet...
>
>
> If anybody has any ideas or suggestions as to how this could be done
> (if it can be done) twould be great,
>
> Many thanks
> Tony
>
>
> --
> tonyDeBrascoPosted from http://www.pcreview.co.uk/ newsgroup access
>