automatic text copying
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: automatic text copying

  1. #1
    Guest

    Default

     
    I would like to do something like the following:

    type in some text in A1
    have the text automatically be copied to cell g10

    I can do this using a formula, but it leaves a "0" in g10 if A1 is blank. I'd prefer not to have the "0" there. Is this possible?

    Thanks.

  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    This will help:
    =IF(A1<>"",A1,"")

    It works like this:
    IF cell A1 is not equal (<>) to nothing ("") show A1 otherwise show nothing ("")

    I recommend using the IF function for many things it's extremely usefull.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com