copying formula pattern

**marvinks** · 04-11-2007, 04:26 PM

Hi Starguy or others
I attached a file. In the sheet called Inv$ I want to pull the inventory purchase amount for the item (barley) for Jan from the Jan worksheet(cell Jan!B5) This is the same for all the months plus all the inventory items. If I have to do these all manually it will take a while. Is there anyhow to fill these formulas in.

Thanks

**kraljb** · 04-11-2007, 05:04 PM

Try using the INDIRECT formula to help you...

Assume in A1 on the summery sheet you has Jan and B1 has Feb etc.

=INDIRECT(A1 & "!B5") and pull it across.

Enjoy.

**starguy** · 04-12-2007, 04:20 AM

Originally Posted by marvinks

Hi Starguy or others
I attached a file. In the sheet called Inv$ I want to pull the inventory purchase amount for the item (barley) for Jan from the Jan worksheet(cell Jan!B5) This is the same for all the months plus all the inventory items. If I have to do these all manually it will take a while. Is there anyhow to fill these formulas in.

Thanks

see in attached file for INDIRECT formula implementation.