Copy cell to another workbook

Giganews Newsgroups
Subject: Copy cell to another workbook
Posted by:  Stevie (ukc…@hotmail.com)
Date: Wed, 16 Jul 2008

I have a large file which I am using for inventories. I would like to be
able to copy the cells for prices from the final week previous  months
inventory to  first months prices of the next months inventory.

This is how my first cell in the column looks, exactly what I want. But how
can I extend this formula down the whole column to reflect each column on
the previous workbook without having to change the last number each time?

='[Inventory p11.xls]Walk In'!$R$5

If I try to drag this formula the lenghth of the coulmn all formualas are
exactly the same

Any help is appreciated

Thanks

Replies