straight text not formula

[Darrell_Sarrasin via OfficeKB.com]

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.

 

[David Biddulph]

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

 

[Darrell_Sarrasin via OfficeKB.com]

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
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.

 

[Darrell_Sarrasin via 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.

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]

 

[Bob I]

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

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.

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.

 

[Darrell_Sarrasin via OfficeKB.com]

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.

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]

 

[Bob I]

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.

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

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.

 

[Darrell_Sarrasin via OfficeKB.com]

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.

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]