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

[DudeFromAccDept]

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.

[oldchippy]

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

[DudeFromAccDept]

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?

[darkyam]

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.

[DudeFromAccDept]

What if its: Electricity!E144?
Would the replacer make it: Flectricity!F144?

[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!

[oldchippy]

What if its: Electricity!E144?
Would the replacer make it: Flectricity!F144?

Not if you Find !E and Replace !F

[oldchippy]

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