there isn't an easier way??? i just want to copy the same cell in many
worksheets into a list. I know how to do a 3-d reference and this seems like
it should be a far easier task. Why is it so complicated?
regards
moushami

"Ron de Bruin" wrote:

Maybe you like this

You can use this macro to create a list on a new worksheet with formulas that link to the
cells on each sheet.
http://www.rondebruin.nl/summary.htm


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



"mnirula" wrote in message ...
the sheet names are account numbers and I am trying to extract the account
name, the account number and the account total (eg. cells A1, A2, A3) into a
list on a new worksheet. Do you you know how to do this?
moushami

"Ken Wright" wrote:

Various ways - what are the sheet names like?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"mnirula" wrote in message
...
This is a very simple task. I simply want to create a summary list in a
column of the exact same cell in multiple worksheets. I know how to
compute
a formula using the same cell across multiple worksheets but can't figure
out
how to do this. I have tried several queries using the search function
using
key words but haven't been able to find the answer. Any help will be much
appreciated.