|
Assign numeric value to a form check box?
I'm building a form to track survey responses. I've got five colums, one
for each response. The response for each of these is essentially a
boolean; Yes or No (True or False). The top of each column returns the
SUM of that column so I can get a quick glimpse of the survey results
for each response type.
I'd like to use a check box to record the responses. However, it seems
that check boxes do...
|
5 |
22.08.2006 17:02:52 |
|
|
Slow RowHeight behavior
Hi,
I have a very strange behavior : on the same computer under windows xp,
with excel 2003, but with two different logins, changing the size of a
cell with the RowHeight property takes either 2-3 seconds or is almost
immediate. The same time is taken when the height of a row is changed
with the mouse. It does not only occur when done by macro.
I checked carefully all the properties of the...
|
3 |
22.08.2006 16:28:22 |
|
|
Hid and unhide and clear contents for specific columns at the same time
I have a serious problem with excel programming and i am not able to
figureout how to do the following funtions.
I have 24 columns. names Jan -Dec ( Actual) then Jan- Dec (Forecast).
There is one reference cell A1 ( for current month).
- If A1= Jan, I want macro to hide FEB-DEC 9 Actual , and leave
FEB-DEC (forecast).
-If A1= FEB , I want macro to unhide FEB Actual and hide MAR-Dec (
ac...
|
2 |
22.08.2006 16:26:15 |
|
|
Merging two sheets
This is what I have
>
> Sheet 1 has two columns
> Col1 ; Col2
> Job; program ( combination of Job + program is unique )
> ABC4DX; ABC123
> ABC4DX; ABC475
> AXC123X; AXC123
> ABC135x; ABC124
>
>
>
>
>
> Sheet 2 (This is a super set, has many rows , some are matching to the
> sheet 1...
|
2 |
22.08.2006 15:20:09 |
|
|
Selection for Code
Hi, i will have a range, only celds than not have 999 for code
Example:
A B C
1 2 alfa 50
2 1 beta 120
3 4 charly 52
4 999
5 999
In this example the code wiil to select A1:C3, but if A4 change to 3 or
other number diferent to 999 o less, select A1:C4
This ...
|
5 |
22.08.2006 15:13:56 |
|
|
Shaded Area in Lieu of Excel Charts
I have a workbook with six worksheets in 3 pairs. Each pair contains a
'detailed data' worksheet and a 'summary' worksheet. The summary
worksheet summarizes data from the detailed data. The summary
worksheet also has a chart based on the data summary.
The problem is that the Excel charts do not display unless I click on
the shaded area where the charts should appear. Once the chart is...
|
3 |
22.08.2006 14:52:17 |
|
|
Pivot Table Help
Good Morning
I have a pivot table set up and all is ok
i have set up a macro to copy the data in the pivot table and to paste it
sumwhere else and to sort it
all is good, but when i save the spreadsheet and close it down and reopen it
and run the macro the pivot table shrinks down to 2 rows and 2 colums
how do i get my data back on show
Can anyone help
Thanks in Advance
...
|
3 |
22.08.2006 14:33:44 |
|
|
MATCH INDEX MIN and 2nd MIN
I have 8 suppliers with their prices listed in columns beneath their names.
With the help of many in here, I can achieve finding out who is the minimum
supplier and who is the 2nd minimum supplier.
Suppose all the suppliers are listed in columns D to K and some suppliers
haven't quoted for all parts listed and in certain sections I have 2
suppliers that did not submit prices for any par...
|
3 |
22.08.2006 13:23:53 |
|
|
Index Formula don't work..
Hello,
Need some help on this
I had a excel file dated 3 yrs ago...with the formula:
=index(Data!B3:k78,match(B3,Data!B3:B78,0),3)) working perfectly when I
open it. But when I used the formula on my new excel file, it is not
working, it show #N/A.
I try to use help session on this but couldn't get what i want.
Kindly help to explain the error...
Thanks
Stephen.
--
StephenL
--------...
|
3 |
22.08.2006 13:14:12 |
|
|
using cell references within file names in links
I am using a link in a cell (e.g. "[filename.xls]worksheet1'!$J$13"). I want
the filename.xls portion of the link to be from a cell (e.g., A1) rather than
to be hardcoded. I have tried a few ways to do this, unsuccessfully. Any
thoughts? Thanks....
|
4 |
22.08.2006 09:14:02 |
|
|
Provides extensive information for insurance consumers
Attempts to improve public understanding of insurance -- what it does
and how it works. The site is subdivided into sections for
"Individuals" (consumer info) "Media" (press info).
'insurance' (http://www.korgnoise.net/insurance/insurance)
'car insurance'
(http://www.korgnoise.net/insurance/insurance/car-insurance-1.html)
'life insuranse'
(http://www.korgnoise.net/insurance/insurance/life-insu...
|
1 |
22.08.2006 08:48:29 |
|
|
Pivot Table Question
Good Morning
I have a pivot table set up and all is ok
i have set up a macro to copy the data in the pivot table and to paste it
sumwhere else and to sort it
all is good, but when i save the spreadsheet and close it down and reopen it
and run the macro the pivot table shrinks down to 2 rows and 2 colums
how do i get my data back on show
Can anyone help
Thanks in Advance
...
|
1 |
22.08.2006 08:09:09 |
|
|
value for a cell
Hi,
I have one excel sheet the value for which is displaying is 192.32 but
cell value for it =RONE. I am unable to link the value wih 192.32 with
the name RONE. Is it a variable or something? PLease help out in this
regard?
Ashish
--
ashishprem
------------------------------------------------------------------------
ashishprem's Profile: http://www.excelforum.com/member.php?action=getinfo&...
|
3 |
22.08.2006 08:00:51 |
|
|
Convert Number to Word
Is there any Simple method to convert Number into Word (for instance
like 1400 to One thousand four hunderd)
--
Rup
------------------------------------------------------------------------
Rup's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37638
View this thread: http://www.excelforum.com/showthread.php?threadid=572539
...
|
4 |
22.08.2006 07:38:54 |
|
|
delete rows where that contain an empty cell
I have 3 columns of data....columns 1 and 2 all have data...where
column 3 contains an empty cell I would like to delete the row.
Can someone help me please??
....Lisa
...
|
6 |
22.08.2006 01:52:20 |
|
|
Time Table
hi members
i want to develop a timetable for teachers and their periods.
i want there should not be timeclash.
--
b166er
------------------------------------------------------------------------
b166er's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34912
View this thread: http://www.excelforum.com/showthread.php?threadid=573769
...
|
2 |
22.08.2006 00:54:46 |
|
|
Highlighted cells
I am adding a string of several cells. When I would cick on the cell i
had my forumula in it would put a color highlight around each cell
that was used in my formula. It is about 50 + cells now and when I
click in the formula cell nothing is highlighted . How do I get the
cells in my formula to be highlighted when i click in the cell with my
formula? thanks
--
layout
-------------------------...
|
2 |
22.08.2006 00:09:12 |
|
|
Who change my data
One file with many users. The data keep changing but don't know who did
it.
Can we find otu who did it beside asking each of them?
Thanks
--
lovina
------------------------------------------------------------------------
lovina's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=37726
View this thread: http://www.excelforum.com/showthread.php?threadid=573173
...
|
4 |
21.08.2006 23:53:17 |
|
|
Selection.Value = ARRAY Limit?
Hi folks,
I'm at a loss and I'm hoping someone could help.
Dim IA_Array(659, 229) As Variant
'In the code - I load this array with values
ActiveSheet.Range("E11:IQ660").Select
Selection.Value = IALead_Array
Sometimes VBA correctly pastes the entire contents of the array into the
selected range. Most of the time, it pastes #N/A in the last few columns -
(it always begins with col...
|
2 |
21.08.2006 23:13:03 |
|
|
Excel and Access Database Query
Hi
I'm starting with a Spreadsheet that is being used to represent the
financial and audit information for individual projects. 1 spreadsheet
document = 1 project.
I have a worksheet that is linked to an Access Database. I need the
information from this Spreadsheet Document to be filtered into a Formatted
Worksheet within another Spreadsheet Document.
Currently I have the Worksheet...
|
1 |
21.08.2006 22:11:23 |
|
|
Sequential Numbering
I would like to know the formula for making a cell be able to do sequential
numbering such as for purchase orders....
|
5 |
21.08.2006 21:20:26 |
|
|
Phentermine facts
*Phentermine* (marketed as Adipex) is one of two drugs in the 'Fen-phen'
(http://dic.blogopt.com/Fen-phen) anti-'obesity'
(http://dic.blogopt.com/Obesity) medication, the other being
'fenfluramine' (http://dic.blogopt.com/Fenfluramine) or
dexfenfluramine. Fenfluramine was withdrawn from the ' U.S.'
(http://dic.blogopt.com/United_State) market in '1997'
(http://dic.blogopt.com/1997) after reports...
|
1 |
21.08.2006 20:43:11 |
|
|
Distorted AutoShape Graphics
I tried to find a way to get Excel to refrain from distorting
AutoShapes when it prints. I found several queries but no good answer,
so I experimented a bit. To work around the problem, one must distort
the AutoShapes on the screen in order for them to look properly
proportioned on paper.
For example, if I draw an oval with height and width dimensions of 2
inches each (which is, of cours...
|
1 |
21.08.2006 20:33:32 |
|
|
How to convert Excel file to CSV Question
I need to create a csv file from an Excel file.
I attempted to create one by using teh "save as" command. But when I do
the resulting document looks the same. I expected it to look like a
text file with commas separating the cells.
What have I done wrong?
Thanks
...
|
2 |
21.08.2006 20:02:50 |
|
|
Validation Default Value
I'm using a validation list to populate cell B7 on my worksheet. The
choices on this list are dynamic and change based on the value in cell
H6. Cell B6 then shows a VLOOKUP value based on the contents of cell
B7.
The problem is that I often need to change the value of H6 and when I
do so it leaves the previous value in cell B7 until a new choice is
made from the drop-down list.
Is the...
|
3 |
21.08.2006 19:26:51 |