really? there's no easier way to do this than with a macro. I thought I
could put one formula that makes an absolute cell reference to the cell # and
some kind of code to go to the next worksheet each time i copy down. Then I
would enter this into the first cell and then copy down a column. I don't
understand macro formulas as I have never run a macro.
Any other suggestions?
moushami

"Ron de Bruin" wrote:

You can do it manual if you have 3 sheets like this
Enter the = sign in a cell in the first worksheet and select a cell in the second worksheet

You get a formula like this
=Sheet2!A1
Do the same for the other cells

If you have a lot of sheets then my macro is easier
http://www.rondebruin.nl/summary.htm



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



"mnirula" wrote in message ...
hi ken
maybe I'm not expressing myself clearly. Lets say I have three worksheets
named account a, account b, and account c. I insert a worksheet in the
beginning of the workbook. I want to copy cells A1, A2, and A3 from all
three worksheets into the newly inserted worksheet in a column or a row.
What is the formula that allows me to do this instead of copying and pasting
from each individual worksheet which can be quite time consuming? Any
suggestions?
Thanks
moushami

"Ken Wright" wrote:

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