Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / General Excel Questions / August 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Conditional Drop Down Boxes29 Aug 2007 22:38 GMT1
I am trying to set up a worksheet for a pipeline report.  I need to set up
Conditional Drop Down Boxes that are contingent upon the drop down Choice in
a previous Drop Down Box.  The problem is that I have to set up more than one
Dependent Drop Down Box for the same master Data ...
Please help. Remove dups automaic of same name,price,month.29 Aug 2007 22:24 GMT6
I have a spreadsheet called Book1 with 2000 lines.  
Where there is a dup in rate , name and month I want to remove the dup  
lines from the spreadsheet.  Keeping just one line.
If the price is diff but same month, name and rate i want to keep in the
Attaching Macro to Cell instead of button?29 Aug 2007 22:20 GMT2
I have a cell that is a list. Instead of attaching a Macro to a button, I
would like it to run everytime a new selection from this list is selected. Is
this possible? If so, how?
Much thanks!
VBA/Excel help - Coding ComboBoses......29 Aug 2007 21:57 GMT2
Perhaps someone can help me..........
I have the following code written in VBA.
Private Sub SupervisorComboBox_Change()
Sheets("Sheet2").Range("C1") = SupervisorComboBox.Value
erase page #129 Aug 2007 21:34 GMT1
how do i erase the large page "#1 in the middle of the spreadsheet
Insert blank column every other column29 Aug 2007 21:05 GMT2
I have many columns with data A:ACW and I would like to insert a empty column
between every other columns so i could enter data. is there any way i could
run a macro to do that?
thx.
Hyperlinks won't work when file is viewed in email29 Aug 2007 20:54 GMT2
I have a hyperlink to another file in an Excel workbook, which works fine
when opened from within Excel.  However, if I send the email as an attachment
and a user opens and views (doesn't save) the email, the hyperlinks won't
work.  Any idea why?  Thanks.
Linking Cells29 Aug 2007 20:28 GMT1
When linking cells from one tab to another, where the cell from the source
cell is blank, the return value shows a 0. How can I get that to be blank as
well? Same issue with dates, when the source cell is blank, the date returned
is 1/1/1900. I need a blank there as well.
Selecting Page Tabs29 Aug 2007 20:24 GMT2
Is there a keyboard shortcut to selecting page tabs (sheets) in Excel?
Problem with dates in excel29 Aug 2007 20:14 GMT9
I have been working on a spreadsheet for a couple of months now and in
the past two day I have begun having a problem when entering the date
in to a cell.
Everything was working fine
conditional formatting max29 Aug 2007 20:07 GMT13
I  am using excel 2003 and would like to use conditional formatting to
highlite  the 120 day column with the highest % for each site regardless of
month.  For example  for Phil it would be 98.16, for Mech it would be 96.42.
Any help would be much appreciated. Thanks.
Building criteria string for Advanced Filter variable not resolvin29 Aug 2007 19:52 GMT1
I am building a criteria string for an Advanced Filter feature.  The string
values exist in a spreadsheet.  I need to prepend ="= and append a trailing
quote.  When I do the varialbe myCriteria does not resolve.  Here is the code
snippet:
Add-in files filling up My Recent Documents - Excel 200729 Aug 2007 19:48 GMT1
Recently upgraded to Office 2007.  After I activated a few Add-ins in Excel,
the add-in files (*.xla and *.xlam) appear in Start=>My Recent Documents,
which basically renders "My Recent Documents" useless since it happens every
time I start Excel.  Any idea how to correct this ...
Insert symbol in front of value29 Aug 2007 19:46 GMT3
I have a basic formula of =Sum(J2-I2) for an entire column and I am needing a
specific format.  
If the sum equals a value greater than the value in cell J2 place a + sumbol
in front of that value.  
Asynchronous call (macro)29 Aug 2007 19:41 GMT1
I want to execute 2 subs (Macro1 and Macro2) at the same time, how can I do
it?
I don't want to wait for the end of Macro1 to execute Macro2
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.