I have a cell refering to another workbook. example: April.xls
I want to change all cells with that refrence but without changing each one
individually, so i created a cell which i input the current month. How do i
link it to all other cells so instead of getting information from april.xls
it will get information from july.xls

examle formula:
=[April.xls]Sierra'!H7

how do i enter in this formula the cell no. instead of april?

If current month is in A1:

=INDIRECT("["&A1&"]Sierra!H7")

HTH
--
AP

"Jared" a écrit dans le message de news:
...
I have a cell refering to another workbook. example: April.xls
I want to change all cells with that refrence but without changing each
one
individually, so i created a cell which i input the current month. How do
i
link it to all other cells so instead of getting information from
april.xls
it will get information from july.xls

examle formula:
=[April.xls]Sierra'!H7

how do i enter in this formula the cell no. instead of april?

I did try this function but it gave me an error

maybe because it is a different workbook?

Waiting for a different approach

thanks

"Ardus Petus" wrote:

If current month is in A1:

=INDIRECT("["&A1&"]Sierra!H7")

HTH
--
AP

"Jared" a écrit dans le message de news:
...
I have a cell refering to another workbook. example: April.xls
I want to change all cells with that refrence but without changing each
one
individually, so i created a cell which i input the current month. How do
i
link it to all other cells so instead of getting information from
april.xls
it will get information from july.xls

examle formula:
=[April.xls]Sierra'!H7

how do i enter in this formula the cell no. instead of april?

select all cells that contain formula you want to change.
press Ctrl+H
Find what: April
Replace with: July
then press Replace all


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=539193

It would be only good for one sheet, but doing it for over 7 sheets becomes a
hassle for every month.

All i wanted to do is change the contents of one cell which would be linked
to all the other cells.


"starguy" wrote:


select all cells that contain formula you want to change.
press Ctrl+H
Find what: April
Replace with: July
then press Replace all


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=539193

you can change it for all 7 sheets at a time.
Find what: April
Replace with: July
click "Options " tab. it will expand window
select
within: workbook
then press Replace all

does it work..?


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=539193