Puff The Magic Wagon!

iTrader: (2)

I have two worksheets...

On WS1, I have totalled a list of expenditure (H50)

I wish to display just that total on WS2

So at the cell ref, I should go WS1!H50 but that doesn't work. I can't get it to work as a pivottable as there is no list.

Doh!

All I want to do is to have the running totals displayed on WS2, where I will subject them to other formulae from WS3 etc..

I know its simple, but damned if I can find it

Thanks

bioforger

iTrader: (1)

Just type = in the cell u want it in WS2 then navigate to WS1 n click the cell, simple

DJ Dunk

iTrader: (5)

Yep. Or just name the total cell then type =NAMEDCELL wherever you want it

BTW the correct syntax is =WS1!H50


[Edited by DJ Dunk - 11/11/2002 3:24:27 PM]

Andy Hall

Hi Puff,

find the box where you want to put the total on WS2 and hit the Sum icon, then go back to WS1, highlight the numbers you want to highlight and hit return. Worked for me a minute ago.

Also thank for the contact for the tracker, should be having it installed in a couple of weeks.

Cheers
Andy

Puff The Magic Wagon!

iTrader: (2)

Hmm..

Then you have to change the name from =WS1!A1 to =WS2!A1 It won't do it straight off but getting the required result in the end

Ta!

DJ Dunk

iTrader: (5)

Change the name ? Just name the cell or range of cells, like:

Insert, Name, Define, PUFF's TOTAL

Then wherever you type =sum(PUFF's TOTAL) your total will appear

[Edited by DJ Dunk - 11/11/2002 3:33:00 PM]

Puff The Magic Wagon!

iTrader: (2)

Wow! See one response & respond to that & by the time you've done it, theres 3 more

Thanks all



Andy YHM

XRS

Use Lotus 123.


YKIMS