Excel 2003 add List to Combo Box from Control Toolbox
Wed, 28 Apr 2010 02:51:01 -0700
Hi,
How can I add a list of data to an combo box created through the control
toolbox (not from the forms toolbar)?
Thanks,
Koen ...
|
Can I call a UDF in one add-in module from a UDF in another?
Tue, 27 Apr 2010 21:01:38 -0700
I have several personal add-in modules. One of them contains utility
functions (UDFs) that I would like to be able to call from the UDFs in
the other modules.
I put the following code in one of the add-in modules:
Public Function a_1(n)
a_1 = a_2(n)
End Function
Public Function a_2(n)
a_2 ...
|
Averageifs- calculate TV programs rating from various channels
Tue, 27 Apr 2010 14:53:28 -0700
Hi all,
I'm trying to use averageifs on the following situation:
I have 3 criteria columns- date, start time of a program and finish time of a program (no problem with this of course) and 10 columns of rating data to 10 different TV channels in any time of the day.
In anoter sheet I've got a table whice include ...
|
Conditional Formatting across different worksheets
Tue, 27 Apr 2010 14:42:47 -0700 (PDT)
Hello everyone,
I looked over the internet and in this forum, but I have not found a
solution to my problem (perhaps I did not understand the solutions
that were presented on the Internet). Anyway, this is the problem:
I have two sheets, one that I use as a control (i.e. a back up) that I
will call Sheet 2 ...
|
Conditional Formatting across different worksheets
Tue, 27 Apr 2010 14:22:02 -0700 (PDT)
Hello everyone,
I looked over the internet and in this forum, but I have not found a
solution to my problem (perhaps I did not understand the solutions
that were presented on the Internet). Anyway, this is the problem:
I have two sheets, one that I use as a control (i.e. a back up) that I
will call Sheet 2 ...
|
Autofill formulas when adding rows in tables
Tue, 27 Apr 2010 13:49:01 -0700
Is it possible to have the formulas you are using in a column automatically
appear in the new cell in the column when you add a new row? I swear I saw
this demonstrated in a video but they did not explain how to do it.
I just converted a table of data to an Excel Table (using Format as Table
command); took ...
|
Excel 2007 - Wrapping Issue!!
Tue, 27 Apr 2010 06:26:34 -0700 (PDT)
Original post:
http://groups.google.com/group/microsoft.public.excel/browse_thread/thread/23fa6398a8747c97/b01098814db13a95?lnk=gst&q=excel+2007+cut+off&safe=images#
I'm having this exact same issue!! It's been driving me insane and the
IT Help Desk people at my work are useless. Does anyone know anything
abo ...
|
|
|
Re: SUMPRODUCT using Time between two values
Mon, 26 Apr 2010 23:19:57 -0700 (PDT)
On Apr 24, 1:15 am, Finny <conorfinne...@gmail.com> wrote:
> Thanks in advance for any help you can provide me. I have a sheet
> with the following layout of data (shortened here and changed for
> obvious reasons)
>
> Venue Date Event Start Event End
> Act
>
> Disney 4/13/1 ...
|
Collapsing Cells
Mon, 26 Apr 2010 10:35:10 -0700 (PDT)
I have a spreadsheet that has data I want to extract that resides in
every 4th cell down. So for example:
Row 1 - Name
Row 2 - Address
Row 3 - City State Ziop
Row 4 - Phone Number
It is row 4 I want to extract and I am looking for a way to extract
ONLY the data in each 4th row into a spreadsheet that will ...
|
Range Vlookup
Sun, 25 Apr 2010 20:28:22 -0700 (PDT)
Hi Every One,
I hope you all are doing well, I required your help to resolve my
issue in
excel.
On single worksheet i have two different sheet name as 1.IP Range 2.
Result.
Question:
EG:IP Range
Start IP End IP Area
192.168.1.4 195.182.254.254 AG
10.15.33.10 ...
|