refering to specific cell in the formula

[need a help]

='C:\Documents and Settings\VENUS\Desktop\[1.xlsx]1'!$A$1
this is a formula in the specific cell but i have more than 150 files.xlsx
and i have to merge it in one sheet can any one give me a way to make this
idea possiable
a b c d e
1 1xlsx 2.xlsx 3.xlsx 4.xlsx 5.xlsx
2 ='C:\Documents and Settings\VENUS\Desktop\[A1]1'!$A$1
3 ='C:\Documents and Settings\VENUS\Desktop\[B21]1'!$A$1
4 ='C:\Documents and
Settings\VENUS\Desktop\[B3]1'!$A$1
that mean i will refer the name of the file in the furmula to the cell A1 B1
C1 etc.
i have tried many ways but it doesn't run
so kindly and expert tell me the way to do that with the file name and the
sheet that i give (1) for it names also in the same way

 

[T. Valko]

Try this:

Enter this formula in A2:

="='C:\Documents and Settings\VENUS\Desktop\["&A1&"]'!$A$1"

Copy across as needed.

This will result is a TEXT string that looks like a formula.

='C:\Documents and Settings\VENUS\Desktop\[1.xlsx]'!$A$1

Select all the cells that hold these formulas
Goto Edit>Copy
Then, Edit>Paste Special>Values
Then, Edit>Replace
Find what: =
Replace with: =
Replace All

That's correct. You want to replace the = with an =.

 

[T. Valko]

Ooops!

I left out the sheet name.

Enter this formula in A2:
="='C:\Documents and Settings\VENUS\Desktop\["&A1&"]'!$A$1"

Formula should be:

="='C:\Documents and Settings\VENUS\Desktop\["&A1&"]1'!$A$1"


--
Biff
Microsoft Excel MVP

Try this:

Enter this formula in A2:

="='C:\Documents and Settings\VENUS\Desktop\["&A1&"]'!$A$1"

Copy across as needed.

This will result is a TEXT string that looks like a formula.

='C:\Documents and Settings\VENUS\Desktop\[1.xlsx]'!$A$1

Select all the cells that hold these formulas
Goto Edit>Copy
Then, Edit>Paste Special>Values
Then, Edit>Replace
Find what: =
Replace with: =
Replace All

That's correct. You want to replace the = with an =.


--
Biff
Microsoft Excel MVP

='C:\Documents and Settings\VENUS\Desktop\[1.xlsx]1'!$A$1
this is a formula in the specific cell but i have more than 150
files.xlsx
and i have to merge it in one sheet can any one give me a way to make
this
idea possiable
a b c d e
1 1xlsx 2.xlsx 3.xlsx 4.xlsx 5.xlsx
2 ='C:\Documents and Settings\VENUS\Desktop\[A1]1'!$A$1
3 ='C:\Documents and Settings\VENUS\Desktop\[B21]1'!$A$1
4 ='C:\Documents and
Settings\VENUS\Desktop\[B3]1'!$A$1
that mean i will refer the name of the file in the furmula to the cell A1
B1
C1 etc.
i have tried many ways but it doesn't run
so kindly and expert tell me the way to do that with the file name and
the
sheet that i give (1) for it names also in the same way

 

[need a help]

i done with the sheet name before but it dosn't work
(e-mail address removed)
can you send me an excel sheet with same you done to see how it will work
great thanks for you

Ooops!

I left out the sheet name.

Enter this formula in A2:
="='C:\Documents and Settings\VENUS\Desktop\["&A1&"]'!$A$1"

Formula should be:

="='C:\Documents and Settings\VENUS\Desktop\["&A1&"]1'!$A$1"


--
Biff
Microsoft Excel MVP

Try this:

Enter this formula in A2:

="='C:\Documents and Settings\VENUS\Desktop\["&A1&"]'!$A$1"

Copy across as needed.

This will result is a TEXT string that looks like a formula.

='C:\Documents and Settings\VENUS\Desktop\[1.xlsx]'!$A$1

Select all the cells that hold these formulas
Goto Edit>Copy
Then, Edit>Paste Special>Values
Then, Edit>Replace
Find what: =
Replace with: =
Replace All

That's correct. You want to replace the = with an =.


--
Biff
Microsoft Excel MVP

='C:\Documents and Settings\VENUS\Desktop\[1.xlsx]1'!$A$1
this is a formula in the specific cell but i have more than 150
files.xlsx
and i have to merge it in one sheet can any one give me a way to make
this
idea possiable
a b c d e
1 1xlsx 2.xlsx 3.xlsx 4.xlsx 5.xlsx
2 ='C:\Documents and Settings\VENUS\Desktop\[A1]1'!$A$1
3 ='C:\Documents and Settings\VENUS\Desktop\[B21]1'!$A$1
4 ='C:\Documents and
Settings\VENUS\Desktop\[B3]1'!$A$1
that mean i will refer the name of the file in the furmula to the cell A1
B1
C1 etc.
i have tried many ways but it doesn't run
so kindly and expert tell me the way to do that with the file name and
the
sheet that i give (1) for it names also in the same way

 

[T. Valko]

Well, it does work for me. This is something not easily demonstrated in a
sample file since your referencing several other files.

???

--
Biff
Microsoft Excel MVP

i done with the sheet name before but it dosn't work
(e-mail address removed)
can you send me an excel sheet with same you done to see how it will work
great thanks for you

Ooops!

I left out the sheet name.

Enter this formula in A2:
="='C:\Documents and Settings\VENUS\Desktop\["&A1&"]'!$A$1"

Formula should be:

="='C:\Documents and Settings\VENUS\Desktop\["&A1&"]1'!$A$1"


--
Biff
Microsoft Excel MVP

Try this:

Enter this formula in A2:

="='C:\Documents and Settings\VENUS\Desktop\["&A1&"]'!$A$1"

Copy across as needed.

This will result is a TEXT string that looks like a formula.

='C:\Documents and Settings\VENUS\Desktop\[1.xlsx]'!$A$1

Select all the cells that hold these formulas
Goto Edit>Copy
Then, Edit>Paste Special>Values
Then, Edit>Replace
Find what: =
Replace with: =
Replace All

That's correct. You want to replace the = with an =.


--
Biff
Microsoft Excel MVP


='C:\Documents and Settings\VENUS\Desktop\[1.xlsx]1'!$A$1
this is a formula in the specific cell but i have more than 150
files.xlsx
and i have to merge it in one sheet can any one give me a way to make
this
idea possiable
a b c d e
1 1xlsx 2.xlsx 3.xlsx 4.xlsx 5.xlsx
2 ='C:\Documents and Settings\VENUS\Desktop\[A1]1'!$A$1
3 ='C:\Documents and
Settings\VENUS\Desktop\[B21]1'!$A$1
4 ='C:\Documents and
Settings\VENUS\Desktop\[B3]1'!$A$1
that mean i will refer the name of the file in the furmula to the cell
A1
B1
C1 etc.
i have tried many ways but it doesn't run
so kindly and expert tell me the way to do that with the file name and
the
sheet that i give (1) for it names also in the same way

 

[need a help]

i have forgeten to tell you that i use excel 2007 is that mean something that
doesn't work with me it will come after i enter it in the cell like this
='C:\Documents and Settings\VENUS\Desktop\["&A1&"]1'!$A$1"
as a text and without the ="" we enter in the first and the last
do me a help make me a file and send it to me by email i will be thankfull
for you
my email (e-mail address removed) pls do it for me

Well, it does work for me. This is something not easily demonstrated in a
sample file since your referencing several other files.

???

--
Biff
Microsoft Excel MVP

i done with the sheet name before but it dosn't work
(e-mail address removed)
can you send me an excel sheet with same you done to see how it will work
great thanks for you

Ooops!

I left out the sheet name.

Enter this formula in A2:
="='C:\Documents and Settings\VENUS\Desktop\["&A1&"]'!$A$1"

Formula should be:

="='C:\Documents and Settings\VENUS\Desktop\["&A1&"]1'!$A$1"


--
Biff
Microsoft Excel MVP


Try this:

Enter this formula in A2:

="='C:\Documents and Settings\VENUS\Desktop\["&A1&"]'!$A$1"

Copy across as needed.

This will result is a TEXT string that looks like a formula.

='C:\Documents and Settings\VENUS\Desktop\[1.xlsx]'!$A$1

Select all the cells that hold these formulas
Goto Edit>Copy
Then, Edit>Paste Special>Values
Then, Edit>Replace
Find what: =
Replace with: =
Replace All

That's correct. You want to replace the = with an =.


--
Biff
Microsoft Excel MVP


='C:\Documents and Settings\VENUS\Desktop\[1.xlsx]1'!$A$1
this is a formula in the specific cell but i have more than 150
files.xlsx
and i have to merge it in one sheet can any one give me a way to make
this
idea possiable
a b c d e
1 1xlsx 2.xlsx 3.xlsx 4.xlsx 5.xlsx
2 ='C:\Documents and Settings\VENUS\Desktop\[A1]1'!$A$1
3 ='C:\Documents and
Settings\VENUS\Desktop\[B21]1'!$A$1
4 ='C:\Documents and
Settings\VENUS\Desktop\[B3]1'!$A$1
that mean i will refer the name of the file in the furmula to the cell
A1
B1
C1 etc.
i have tried many ways but it doesn't run
so kindly and expert tell me the way to do that with the file name and
the
sheet that i give (1) for it names also in the same way

 

[T. Valko]

i have forgeten to tell you that i use excel 2007

It doesn't matter. The only thing different is the location of the menu
(ribbon) commands.

Edit>Copy

In Excel 2007: Right click>Copy

Edit>Paste Special>Values

In Excel 2007: Right click>Paste Special>Values

Edit>Replace

In Excel 2007: Home tab>Editing group>Find & Select (the binocular
icon)>Replace

A sample will not accomplish anything. The formulas would already be
converted which defeats the purpose of the steps I've described.

Trust me. This works, you just have to get the path correct.

--
Biff
Microsoft Excel MVP

i have forgeten to tell you that i use excel 2007 is that mean something
that
doesn't work with me it will come after i enter it in the cell like this
='C:\Documents and Settings\VENUS\Desktop\["&A1&"]1'!$A$1"
as a text and without the ="" we enter in the first and the last
do me a help make me a file and send it to me by email i will be thankfull
for you
my email (e-mail address removed) pls do it for me

Well, it does work for me. This is something not easily demonstrated in a
sample file since your referencing several other files.

???

--
Biff
Microsoft Excel MVP

i done with the sheet name before but it dosn't work
(e-mail address removed)
can you send me an excel sheet with same you done to see how it will
work
great thanks for you

:

Ooops!

I left out the sheet name.

Enter this formula in A2:
="='C:\Documents and Settings\VENUS\Desktop\["&A1&"]'!$A$1"

Formula should be:

="='C:\Documents and Settings\VENUS\Desktop\["&A1&"]1'!$A$1"


--
Biff
Microsoft Excel MVP


Try this:

Enter this formula in A2:

="='C:\Documents and Settings\VENUS\Desktop\["&A1&"]'!$A$1"

Copy across as needed.

This will result is a TEXT string that looks like a formula.

='C:\Documents and Settings\VENUS\Desktop\[1.xlsx]'!$A$1

Select all the cells that hold these formulas
Goto Edit>Copy
Then, Edit>Paste Special>Values
Then, Edit>Replace
Find what: =
Replace with: =
Replace All

That's correct. You want to replace the = with an =.


--
Biff
Microsoft Excel MVP


='C:\Documents and Settings\VENUS\Desktop\[1.xlsx]1'!$A$1
this is a formula in the specific cell but i have more than 150
files.xlsx
and i have to merge it in one sheet can any one give me a way to
make
this
idea possiable
a b c d e
1 1xlsx 2.xlsx 3.xlsx 4.xlsx 5.xlsx
2 ='C:\Documents and Settings\VENUS\Desktop\[A1]1'!$A$1
3 ='C:\Documents and
Settings\VENUS\Desktop\[B21]1'!$A$1
4 ='C:\Documents and
Settings\VENUS\Desktop\[B3]1'!$A$1
that mean i will refer the name of the file in the furmula to the
cell
A1
B1
C1 etc.
i have tried many ways but it doesn't run
so kindly and expert tell me the way to do that with the file name
and
the
sheet that i give (1) for it names also in the same way