I have Sheet A, and Sheet B in column F on sheet A I have information. on
sheet B I want the information to be read in column A.

I have used the ='Sheet A!F1

But I want it to show as text not as a formula so that another macro can read
it if htat makes sense. any help is appreciated.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200810/1

If you format the cell as text before you type in your formula, then it will
appear as text not as a formula. Note that as you have typed it, it will
not be valid. You've missed out one of the pair of single quotes which
delimit the sheet name. It should be ='Sheet A'!F1.

Another option is to precede the formula with a single quote to show that it
is text:
'='Sheet A'!F1

If you omit the = sign, then again the rest will be stored as text:
'Sheet A'!F1
--
David Biddulph

"Darrell_Sarrasin via OfficeKB.com" <u33691@uwe wrote in message
news:8c74006d2600c@uwe...
I have Sheet A, and Sheet B in column F on sheet A I have information. on
sheet B I want the information to be read in column A.

I have used the ='Sheet A!F1

But I want it to show as text not as a formula so that another macro can
read
it if htat makes sense. any help is appreciated.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200810/1

maybe understanding.

with what your saying its going to read whats in the cell not display the
formula?


David Biddulph wrote:
If you format the cell as text before you type in your formula, then it will
appear as text not as a formula. Note that as you have typed it, it will
not be valid. You've missed out one of the pair of single quotes which
delimit the sheet name. It should be ='Sheet A'!F1.

Another option is to precede the formula with a single quote to show that it
is text:
'='Sheet A'!F1

If you omit the = sign, then again the rest will be stored as text:
'Sheet A'!F1
I have Sheet A, and Sheet B in column F on sheet A I have information. on
sheet B I want the information to be read in column A.
[quoted text clipped - 4 lines]
read
it if htat makes sense. any help is appreciated.

--
Message posted via http://www.officekb.com

What Iam looking for is to have text on sheet A auto transfer to Sheet B and
what ever is there stay as text and not the formula

I have a macro running right now that basically needs to read sheet b and
compair it to other sheets. but it is picking up the formula not the text
and therefore is not displaying the results properly.

So long story short if sheet a reads "john smith" I want sheet B to
automatically read "john smith" not the formula that brought it there.

Darrell_Sarrasin wrote:
maybe understanding.

with what your saying its going to read whats in the cell not display the
formula?

If you format the cell as text before you type in your formula, then it will
appear as text not as a formula. Note that as you have typed it, it will
[quoted text clipped - 12 lines]
read
it if htat makes sense. any help is appreciated.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200810/1

Copy, Paste.

Darrell_Sarrasin via OfficeKB.com wrote:

What Iam looking for is to have text on sheet A auto transfer to Sheet B and
what ever is there stay as text and not the formula

I have a macro running right now that basically needs to read sheet b and
compair it to other sheets. but it is picking up the formula not the text
and therefore is not displaying the results properly.

So long story short if sheet a reads "john smith" I want sheet B to
automatically read "john smith" not the formula that brought it there.

Darrell_Sarrasin wrote:

maybe understanding.

with what your saying its going to read whats in the cell not display the
formula?


If you format the cell as text before you type in your formula, then it will
appear as text not as a formula. Note that as you have typed it, it will

[quoted text clipped - 12 lines]

read
it if htat makes sense. any help is appreciated.

hehe that is the easiest, but its a complicated set up where I want a lot to
be automated. I have a bout 10 users and they want it as simple as possible.

so copy and paste is not an option. they want it automatically done.

Bob I wrote:
Copy, Paste.

What Iam looking for is to have text on sheet A auto transfer to Sheet B and
what ever is there stay as text and not the formula
[quoted text clipped - 18 lines]
read
it if htat makes sense. any help is appreciated.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200810/1

Record a macro that selects the cell, copies it, selects destination
cell, pastes it.

Darrell_Sarrasin via OfficeKB.com wrote:
hehe that is the easiest, but its a complicated set up where I want a lot to
be automated. I have a bout 10 users and they want it as simple as possible.

so copy and paste is not an option. they want it automatically done.

Bob I wrote:

Copy, Paste.


What Iam looking for is to have text on sheet A auto transfer to Sheet B and
what ever is there stay as text and not the formula

[quoted text clipped - 18 lines]

read
it if htat makes sense. any help is appreciated.

followed your advice.

This is the code I have
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 10/31/2008 by Darrell.Sarrasin
'

'
Range("G2:G101").Select
Selection.Copy
Sheets("TTU Completions").Select
Range("A2").Select
ActiveSheet.Paste
End Sub

when I run it the line of Range("A2").Select comes back as an error.
Bob I wrote:
Record a macro that selects the cell, copies it, selects destination
cell, pastes it.

hehe that is the easiest, but its a complicated set up where I want a lot to
be automated. I have a bout 10 users and they want it as simple as possible.
[quoted text clipped - 10 lines]
read
it if htat makes sense. any help is appreciated.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200810/1