|
anyone have sample of IT daily logbook?
I am about to establish the IT Logbook using excel. Does anyone offer a
sample for that?...
|
5 |
10.08.2006 04:07:01 |
|
|
How to format cells in upercase entry
Hi
I read the post for this question (8/8/2006) and Gord Dibben's answer works
great.
Original Question:
I need to format a column so that all cell force any text entry to uppercase.
Gord Dibben's Answer:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Column > 8 Then Exit Sub
On Error GoTo ErrHandler
Application.EnableEvents = False
Targ...
|
2 |
10.08.2006 02:51:01 |
|
|
A Linking Problem
Assume I have a column of numbers, in a file named Source. (range is B2:B10).
These cells are linked to a column in a file named Destination(range is
E2:E10).
If I add a new row 5 to the source, is there a way I can get the previously
linked cells in Destination to continue to display the correct values.
After adding the new row 5 in source, rows in Destination below row 5
display values ...
|
2 |
09.08.2006 23:42:00 |
|
|
cntl+f does not find data that I can see in chart
I have two spreadsheets. In ss 1 there are names that are linked from ss 2.
When I use ctrl+f to find the names, they are not found, even though I can
see that they are there. Any help is appreciated.
...
|
3 |
09.08.2006 21:34:20 |
|
|
autofill alphabet in column
Hi there,
Want to enter column a1..a26 alphabetically. I'm sure I can do it using fill
on the edit dropdown, but can't seem to get it to work.
Any solutions out there?
Thanks in advance
--
Bobby...
|
5 |
09.08.2006 21:27:42 |
|
|
Creating a drop down list
i want to create a column (A1) where i can choose from a list of clients
How do I create this list and keep it hidden?...
|
2 |
09.08.2006 20:45:28 |
|
|
='DataEntry '!K29
I am trying to copy a cell on Sheet 2 onto Sheet 1 and all I get is the
formula not the text. Help please?...
|
4 |
09.08.2006 20:05:08 |
|
|
Vlookup ref!
We are doing a vlookup for a date cell in both workbook which is in column D
this is the formula
=VLOOKUP(B10,'C:\Documents and Settings\Administrator\My
Documents\[calling_.XLS]Customers'!$A$4:$I$58,4,FALSE)
but we are getting a #REF!
both are date fields also it is in row 30 column d?...
|
3 |
09.08.2006 19:40:48 |
|
|
Construction Industry
People, i need help with some spreadsheets regarding construction
industry supply of materials, verifications etc, if any one has a
spread sheet available, any help will be appreciated.
Thank you,
Best Regards,
--
imran.zafarkhan
------------------------------------------------------------------------
imran.zafarkhan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3...
|
2 |
09.08.2006 18:51:27 |
|
|
Can you access the old-style Help Index using Excel 2003?
I've recently obtained Office 2003 for my work laptop, and to say the least
it is getting on my nerves! When I want to access Help, I want a nice little
index of terms that I can search against that is intuitive, user-friendly and
allows me to have a browse around the subject.
Is there anyway of getting this old-style help functionality working within
Excel 2003, which so far has produ...
|
2 |
09.08.2006 18:31:02 |
|
|
Go to > Special > Visible cells only
Columns A, J, K and L are visible.
Columns B to I are hidden.
When I select a few rows using the shift key, click "visible cells only,"
click copy icon and paste icon, I only got column A pasted. I am surprised
not to see J, K and L because to me they are visible as well.
What have I missed? Appreciate explanation.
Epinn
...
|
2 |
09.08.2006 17:41:36 |
|
|
Hide a text box
On sheet 3 of my workbook I have created a button (button 62) and a text
box (textbox 63).
What I want to do is use the button to toggle the text box on and off.
By that I want to be able to show the box or hide the box.
I have tried to copy code from the MS Visual Basic Help but it did not
work, basically because I have no idea what I am doing.
Can someone lease help?
Orf Bartrop...
|
7 |
09.08.2006 13:41:06 |
|
|
Setting the focus
I have created a spreadsheet requiring data to be entered in a set
order. By that I mean the first entry will be in the first blank cell in
column "B".
On pressing "Enter" I want the focus to move to C, D, E, F then M, N and O.
Two questions:
How do I get Excel to open with the focus in the first blank cell in
column B?
How do I set the movement of the focus on pressing "Enter"?
The cel...
|
5 |
09.08.2006 04:36:40 |
|
|
i formatted an excel sheet, to fit my page, how do i add a page?
I am really new at excel and I used page breaks to make a log in sheet how I
need, now it says Page 1, and i filled up the name column how do I add
another page with the same format?...
|
2 |
09.08.2006 02:26:23 |
|
|
Names too long?
Hi Everybody,
Starting to draw out a new database and in the past I have had problems in
certain areas of the database seeing the whole field name. I can see this
may be a problem with the names I have below since they would all look the
same if cut off but I tried to make them short but descriptive. Perhaps
it's in the expression builder section and or other places...Anyway, are
there a...
|
8 |
09.08.2006 01:46:59 |
|
|
How to reduce table?
I have a table with over 5000 rows. However, only about 2500 rows contain
info, the rest are empty rows (one row with info, next empty, etc). I
deleted a few rows by clicking on them and holding Ctrl key. But is there a
way to delete several hundreds of empty rows at once? If there is, may
someone please tell me how to do it!
--
Ilya Zeldes
Fort Myers, Florida
...
|
10 |
08.08.2006 23:06:25 |
|
|
can i setup if, then statements to change the color of a row
I would like to use if and then statements to recognize P, O, or C
if the cell has P, O, or C I want the row to change colors Blue, Green, Red
Is this possible...
|
8 |
08.08.2006 22:59:33 |
|
|
How to remember shortcuts in excel?
Shortcuts keys in Excel are always assigned based on the first letter
of the menu item.
For example. to open a new file the shortcut is CTRL + N, N is the
first letter of the new command.
For more details, see this post
http://xlmaster.blogspot.com
...
|
7 |
08.08.2006 22:49:01 |
|
|
formula for cell
I have many cells with descriptive text, does anyone know of a formula
where I can take for instance a cell with 500 characters and take only
the first 30 and paste it in to a new cell.
I have used a formula thanks to Gary
=left(a1,len(a1)/2
which has worked for other uses I have--now I need to extract only the
first 30 characters of a description and I have thousands of cells in
my des...
|
5 |
08.08.2006 22:27:47 |
|
|
Convert PDF to Excel columns
Help ! Ive copied a price list of a PDF file and need to put it back
into original columns in an Excel file.
I tried Text to columns but as the descriptions vary in length it didnt
work & to do manually would take a while cause there is about 800 to
do.
The columns need to be set out like this -
Number. Code. Description. EACH. Price.
First few below
:confused:
1 BB-1a Open/check/sea...
|
4 |
08.08.2006 21:58:24 |
|
|
Number permutations
Hi ppl, (first post so forgive obvious mistakes)
I am after the code, formula (not sure what it's called) to be able to
for example put in cell 1 a number in cell 2 the number of permutations
that will make up within a given field. Confusing? yes I thought so. I
want it for a betting sheet.
So for example a 'yankee' which is 11 bets consisting of six doubles, 4
trebles and 1 accumulator.
...
|
2 |
08.08.2006 21:17:21 |
|
|
sqa result 2006
Could i get the SQA results 0f 2006.Thanks....
|
2 |
08.08.2006 19:15:54 |
|
|
How to fix application errors
...
|
2 |
08.08.2006 19:12:46 |
|
|
How to override "Too Many Cell Formats" error comment.
When working on excell, how can I override this "Too Many Cell Formats"
comment? ...
|
4 |
08.08.2006 17:51:22 |
|
|
number input
Wht is it that Excel does not accept a zero as the first number of a 5 digit
zip code? How do you get Excel to accept it?...
|
3 |
08.08.2006 17:20:56 |