How can I hide letter in a cell?
I am trying to hide a letter in a cell, and when the cell is filled in with
black, then have the letter appear. I am doing this on a reservation form.
So make the text white? That way, if the cell is filled black, it'll show.
"Linds" <Linds@discussions.microsoft.com> wrote in message
> I am trying to hide a letter in a cell, and when the cell is filled in
> black, then have the letter appear. I am doing this on a reservation
Chang...Saving Excel Docs as a 'Variable' Name
Is there a way to save an excel document, by a macro, that names it by a cell
within the document?
Also, is there a way, again using a macro, to open up specific files based
on cells within the document?
nm, got it.
> Is there a way to save an excel document, by a macro, that names it by a cell
> within the document?
> Also, is there a way, again using a macro, to open up specific files based
> on cells within the document?
nm, got it.
> Is there a way to save an excel document, by a macro, th...summing cells based on "like" value and cell color
Is there a way to look at a column and if the cell begins with
01,02,03....98 and the cell color is either yellow or pink to sum those
just those cells?
So what I'd like to do is sum all the cells starting with 01 that the
cell background is yellow,
then sum all the cells starting with 01 that the cell background is
Any help would be greatly appreciated.
You will need VBA to count by colour.
Bernard V Liengme
remove caps from email
<firstname.lastname@example.org> wrote in message
news:1157548360...Inserting a cell in the header.
We are trying to get a cell in the header of a sheet. Can this be done?
Example would be in our sheet in D9 is TFF. We want whatever is in D9 to go
in the header. I'm not sure this makes sense.
You could do this with a macro linked to the worksheet_change event.
Insert the following code into the macro sheet for the sheet with the
cell if interest.
Private Sub Worksheet_Change(ByVal Target As Range)
For Each Cell In Target
If Cell.Address = "$D$9" Then
ActiveSheet.PageSetup.CenterHeader = Cell.Value
Research Scientist with ...Mutiple Cells highlighted
When ever I try to select one cell on a Excel worksheet
multiple cells are highlighted. It's like the right mouse
button is been depressed, but it's not and the mouse is
working fine and I even tried a new one. Thanks.
Look to see if "EXT" appears in the status area in the lower left corner of
the Excel window. It is next to the Caps Lock and Number Key lock
indicators. If "EXT" is displayed, that means you have the "Extend
Selection" option turned on. This causes Excel to select a rectangular
bounded by the previous cursor position and wh...Line break in cell, char(10) square settings?
I have a problem regarding the char(10) square that appears when you press
"alt enter" to get a line break in a cell. (When using Wrap text)
When I use a cell reference to a cell with a line break the Char(10) square
appears in some of my excel xp or excel 2003 installations but not all of
I have tried to find some settings for this but I have not.
I need the squere to get the line break back when I send the information to
a database and back
Do you have any suggestions?
The square is what char(10...How to create a formula that results in a blank cell if required
I have a spreadsheet that is to be populated during the course of the year.
I have a column which totals the number of days worked on a particular task
and have copied the formula down the sheet for the number of entries
Obviously, as the sheet is currently unpopulated, I do not want a whole load
of zeroes listed in this column when the other cells in the sheet (which are
used in the calculation) are currently empty.
ie) what I have is (as a simple example)
A B C
Hours Total Hrs Total Days
37 37 5
...Color shading on cells with same numeric content on three digit ce
Has made a numerical database containing three numbers in each cell and
includes zeros, double and triple digit content. Note that leading zeros
unseen and now having thousands of cells on my database. How can I command,
(ex: 123, 132, 231, 213, 312, 321) be look up and color shade?
Assumptions: A1 contains the 3 digit 'code' to enter. Note: If this is
entered as text, then you don't need the A2 line, and just change all the A2
references from A3:A8 to A1. The first solution is if the numbers you are
comparing your 3 digits to are actual numbers and not text.
A2: =TEXT($A$1,...coping with empty excel cells in the xml document
I have an xml document that has been created from an excel spreadsheet. In
the s/s there are some empty cells however these are not captured in the xml
file. All that is added is for the cell after where the empty cell should
be, it has an extra attribute: "ss:Index="6", where it is the 6th cell in
the row, and cell 5 had no entry.
I'm wanting to pick out a particular cell from a particular column however
just iterating through the cells is going to give me invalid values where
there should have been empty cells.
Does anyone know how to handle this?
I've tried ch...Cell address
I want to do something like Offset(vlookup(a1,range,1,false),1,1). However I want the lookup function to return the cell address instead of the value. Any suggestions?
For everyone's benefit keep the discussion in the newsgroup.
"Tasha" <email@example.com> wrote in message
> I want to do something like Offset(vlookup(a1,range,1,false),1,1). However
I want the lookup function to return the cell a...excel
I have a total of 20 worksheets. The worksheet names are "q1", "q2"
"q3" ... , "q19, "q20" (all without the quotes). In each sheet, I wan
cell A1 to contain the name of the worksheet.
When I change the name of any worksheet, the content of cell A1 (in th
particular sheet) should also automatically change to the new name o
Message posted from http://www.ExcelForum.com
If you place the following code into vba it should work. What it does i
after you have changed the sheet names goto tool and there will be
command there called re...What does the 8.43 and 12.75 represent in height and width of cell
In working with excel I notice that the default width (8.43) and default
height (12.75) seem to be visually different. What do the numbers represent?
Height is measured in points (72 points to the inch)
Width is measured in points (12 points to the inch)
> In working with excel I notice that the default width (8.43) and default
> height (12.75) seem to be visually different. What do the numbers represent?
Row heights are measured in points or pixels. There are 72 points to an inch
and "maybe" 96 pixels to the ...Display items with they appear in different sections of a table
I have an Access VBA Form that uses information from various tables.
The form I have used uses a subform.
I am trying to set up a query so that it displays what work an employee has
done. The user would select an employee from a list. That selected Employee
would be listed in the main form.
EMPLOYE: joe smith
Joe Smith was assigned as employee1 on one job, employee2 on another job,
and employee3 on the other.
The list should display all occurances.
The Query returns a value from the table form the employee 1 field. However,
a job can have up to 3 emplo...Get column name and data type from closed workbook
Good day Group,
Found the code below from this group that helps me to retrieve the Sheet
a closed Workbook. Is it possible to get the name of the columns (fields)
a Worksheet in a closed Workbook in the same way? Is it posssible to get
the format (data types) of each column? As new to this I�am grateful for
Dim cnn As ADODB.Connection
Dim cat As ADOX.Catalog
Dim tbl As ADOX.Table
Dim lRow As Lon...Insert cell contents into header/footer
I would like to know how to insert the contents of a particular cell (in each
worksheet) into the header/footer for the corresponding worksheet.
Private Sub Workbook_BeforePrint(Cancel As Boolean)
.LeftFooter = Range("A1").Value
'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code
"joeeng" <firstname.lastname@example.org...Employee Name change affects AD, Business Portal and GP
Anyone have a good process to follow when an employee changes their last name?
The IT department has changed her name in AD and now portal is broken, I
suspect I can simply delete and recreate the account in Portal and all the
underlying transactions (timesheets and expense reports) will stay linked.
For PDK and GP we've included part of the last name in the ID so we'll need
to go with the Professional Services tool to fix that.
Is there a recommended order to do all this or am I missing anything?
...Using a Table as a Referance
Hi, I was wondering if there was any union code that i could use to use a
table as a reference. what i mean is, if i had a main table that was related
to this reference table by the primary key, and the reference table had
fields choresponding to things in the in main table. this way, any one
record in the main table would have a value in the reference table determined
by two of the fields in the main table.
i just realized how amazingly confusing i made that, so i will try to
Joe - A - 1
Sally - B - 2
Kari - A - 2
-- - 1 - 2
A - x - y
B - z -...Copy same values to several cells
I am using Excel 2003 to do some temperature modelling. I have a long list of
daily average temperature. I want to create a new list where the each day is
divided into periods of 6 hours and each cell is linked to the belonging
daily average temperature. In my new list I want to connect the first five
cells to the first cell in old list, then connect the next five cells to the
second cell in the old list and so on. Since I am working with 10000 of data
I need to find a method that can be copied down the coulomm.
Say the old list is on Sheet1, Column A.
Enter this anywhere in Sheet2, a...change cell colors after comparing against an answer row
I have users' answers in multiple rows. my top row has the right
Each column represents answer to a question.
How can I compare the all the rows against the right answer keys and
give a highlights on all the wrong answers?
A1 to A10 is the right answers for question 1 to question 10:
B1 to B10 is the answers from one user. In the example blow, I'd like
to compare 2 rows and highlight the B2 cell in yellow (for it's the
.... continue with the rest of users.
How can I do that?
Select B1:Z10 (or through th...Display a summary sheet, for several tabs
I have an Excel 2003 spreadsheet that had 12 tabs on it, one for each
member of the team. On this tab, they record details of specific
calls that they have taken, including the date that the call was taken
What I want to do, is include a summary tab that will show for all
tabs, the date and the summation of all financial values from the
So, for example, if the first three tabs show the following
Tab Date Written Off
1 10/10/2008 250.00
1 10/10/2008 175.00
25.00 ...Reference to content AND formating of target cell
=I am the <b>best!</b> (<b>...</b> means bold letters)
Returns: =I am the best! (without bold)
What can I do so that the exact formating (eg bold, font size, font color,
backgorund colr etc.) will be preserve as well?
- I'm using Office XP
- I'm using Windows XP
"Ninja Stevie" <email@example.com> ???
> conditional formatting.
Sorry, but how is it possible to do what I want by conditional ...text bo x with value from cell on other sheet
I have a chart - at bottom of chart I have cells with
value form other sheet.
I am trying to ficx chart someone else made.
Can I pout a cell reference to another sheet in atext box
to get alignment
To get a textbox with a cell reference, select the chart, type an equals
sign, then select the cell with the mouse. If the cell is on another
sheet, you can navigate using the sheet tabs. If it's in another whole
workbook, navigate using the Windows menu.
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
___...Copy cell to another worksheet
I am populating cells C5 thru C100 on my sheet Case Report. I woulld
like the same information to populate my Time sheet in the A1 thru A95
range automatically. Is this possible?
This is possible,
but the cells what you selected must be continuous.
* �����ഺ���ٵ�ʱ���и�Ů��ԸΪ��ȥ���� ���� *
* ����־�ᶨ�ض���˵����Ҫ���ٲ����ң��Ҿ�ȥ���� *
* ���������ʵ���ʱ���и�Ů��Ը���ҹ�����Ȫ������ *
* �Ž�ƽ ...Company Name Problems / SBS
I'm installing standard on a new Win2K Small Business Server from the Action
I sent in the Activation and was given a key for "Riddle, Inc."
Install tells me the Riddle, Inc. already exists and I saw other posts
indicating the chars like ".," are a problem.
Do I need to request a new Company/Key? Looks like uninstall reinstall is
required to change name (with manual SQL deletes)?
Also I have MSDN which I'm told has Pro. How to I get a key for it?
How can you tell one distribution from the other? Both just say CRM Server
1.0. Is the difference just the...Display results based on a date range
I’m trying to creating a form that will display info from my table called
“tblCalls”. I would like the info to be display between to a “Date” range
entered by the user. Within my “tblCalls” there is a field that contains the
date of each record.
In my form called “frmCallLog” are the two textboxes, in which the user will
enter the desired date ranges “Calls from [textbox “8/20/06”] through to
[textbox “8/20/07”].” The form will then auto populate with the results.
There are many textboxes that will at that time auto populate with results,
such as, how many times does “Jason”, “Bob”...