+ Reply to Thread
Results 1 to 8 of 8

What do the ' ' stand for like in 'Basic data'!C$12

  1. #1
    Registered User
    Join Date
    03-20-2008
    Posts
    21

    What do the ' ' stand for like in 'Basic data'!C$12

    I couldn't search for it, sorry.
    What do the ' ' stand for, like in:
    'Basic data'!C$12

    Bonus question:
    What does the ' stand for in:
    'Entry in THOUSAND currency units

    I would really like to go deep into some good Excel book but I am running Open Office at home (sux!) and at work I rarely have time.

    Thanks.

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Hi,

    First answer is 'Basic data' is the sheet name followed by the cell reference

    The second question is ' is used before a text entry in a VBA module, it's not used by the macro it is there as an information label
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    03-20-2008
    Posts
    21
    Thanks for answering. I am not sure I got it.
    What is the difference between: 'Basic data'!C$12 and Basic data!C$12 ?

    Also, I have these columns... Each colmn has cells filled with something like: blahE8 then, below it, blahE9 and etc... I need, in every cell, to change blahE8 to blahF8.

    Is there a quick way to do this?

  4. #4
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191
    When a worksheet has a space in the name, you need single quotations around the name. If there is no space, you can refer to the worksheet without quotations.
    For your second question, highlight the column, Ctrl+H, E in the first box (or !E, if the "blah" refers to another tab) and F (or !F) in the second, then Replace All.

  5. #5
    Registered User
    Join Date
    03-20-2008
    Posts
    21
    What if its: Electricity!E144?
    Would the replacer make it: Flectricity!F144?

  6. #6
    Registered User
    Join Date
    03-20-2008
    Posts
    21
    Also, what difference does it make if I make it "search by rows" or "search by columns"

    Sorry for the noobness. I used to be able to make pretty clever pivot charts and all. Dunno where that all has gone!

  7. #7
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Quote Originally Posted by DudeFromAccDept
    What if its: Electricity!E144?
    Would the replacer make it: Flectricity!F144?
    Not if you Find !E and Replace !F

  8. #8
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,099
    Quote Originally Posted by DudeFromAccDept
    Also, what difference does it make if I make it "search by rows" or "search by columns"

    Sorry for the noobness. I used to be able to make pretty clever pivot charts and all. Dunno where that all has gone!
    None at all, you can search by rows or columns, or even select a range rows and columns together

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1