Copy cell to another workbook

S

Stevie

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
 
B

Bernard Liengme

Copy it to first cell
Edit this cell to make formula read ='[Inventory p11.xls]Walk In'!R5
(look! no dollars)
Now drag down and the R5 will increment
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Copying spinners for each cell in Excel 2003? 2
Coping formulas to new workbook 12
Excel lookup across entire workbook 1
Link to another workbook & indirect 4
Gathering information from different worksheets in the same workbook 1
How can I update the latest cost paid for a part? 2
How to create absolute link to cell in another workbook (Excel 2003) 1

Top