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.

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.

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.

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.

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.

You must create a formula link or copy the cells with a macro
http://www.rondebruin.nl/copy2.htm


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



"mnirula" wrote in message ...
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.

If you'd care to give an example of a couple of sheet names, (or you perhaps
have a list of these accounts that you can use) an account number (By all
means dummy it up, but make sure it is representative) then maybe I can give
you a formula example.

One option may be to use the INDIRECT() function that allows you to build
range references from strings of data. If you already have a list of the
accounts (which I assume are the exact sheet names), then we can probably
help.

--
Regards
Ken.......................

<snip