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
Move data within workbook27 Aug 2007 18:50 GMT2
I need to know how to move data from worksheet 1, A2 to D13 to next available
row in worksheet 2 of the same workbook using a command button.  Cells
contain text, currency, and dates.
Macro error when worksheet is protected27 Aug 2007 18:42 GMT2
I have the following macro in Excel 2000:
Private Sub Calendar1_Click()
   ActiveCell.Value = CDbl(Calendar1.Value)
   ActiveCell.NumberFormat = "mm/dd/yyyy"
Dynamic dropdowns27 Aug 2007 18:22 GMT3
-- What I need is in auserform a way of selecting a value from a dropdown
list and depending on the result 1 of 3 different lists of data being loaded
into a second dropdown list box in the same userform. I have seen
http://www.xldynamic.com/source/xld.Dropdowns.html  But cannot ...
Need help in creating a formula27 Aug 2007 18:16 GMT5
I need to create a spreadsheet where I take daily totals (mon-fri x 4 weeks)
and come up with a billing total of hours.  For instance we charge $1.75 for
a half hour and $3.50 an hour for care.  I need to be able to put in
something like 3.5 on a mon and say 2.0 hours Tues etc. ...
See Data behind Pivot Table27 Aug 2007 18:04 GMT2
I have a source sending me reports in Excel Pivot Tables that I don't really
want.  I need the raw data, and I keep getting Pivot Tables.  I've been
searching the help files for how to get the Pivot Tables off so I can see the
data behind them, and I'll I'm finding is ...
Excel 2003 Using the keyboard27 Aug 2007 18:02 GMT13
I need to use the keyboard in Excel rather than the mouse for health reasons.
Does anyone know where I can find a list of keystrokes for Excel commands.  
I'm not so much looking for keyboard shortcuts, it's for things like
accessing the "Name" box (above column 'A'), or filling a ...
Insert New row if Column G = "P"27 Aug 2007 18:00 GMT1
I can't seem to get this, but
if I wanted to run a macro that
would start at cell G50 and
move upward to Cell G18 testing for the
How do you get outlook to select from  list on a form27 Aug 2007 17:54 GMT1
I want to send an email to  a group of people from a listbox that has been
populated from selecting from another listbox (and sheet). How does outlook
take the new list and send the form or sheet to the people in the selected
box?
Help?! Format Cells for ALL CAPS27 Aug 2007 17:42 GMT1
I am setting up a template and need to format some cells/columns to come in
all caps for State abreavations.  I expected to find the all caps option in
the format text menu but did not.  The only info I've found gives me a
formula to pull in text from another cell and make it ...
Circular Reference27 Aug 2007 17:22 GMT2
I am working on an inventory spreadsheet. I am trying to get a total for each
item in a separate column. Each item has multiple rows due to the number of
locations. The formula I have tried to use =IF(A2=A3,V3=V2+U3,V3=U3) does not
work. (A is my item number column, U is my ...
tough cookie27 Aug 2007 17:17 GMT3
I have readings (hourmeters of water pumps) in random days. In column A i
have all days of the year, which means i have holes in my table. column B has
the hours when the readings were made and column C has the readings.
In column D i have the reading of a certain day minus the ...
Adding Dashes to a 25 digit alphanumeric cell27 Aug 2007 17:02 GMT7
I have a column of 30-5k consisting of a 25 digit alphanumeric code.  I need
to reformat these to have dashes every 5 characters. example:
XXXXXXXXXXXXXXXXXXXXXXXXXX
to
Excel background gridlines on worksheet-how do I remove from view27 Aug 2007 16:53 GMT8
How do I get rid of the gridlines that appear automatically upon opening
worksheet?
Excel graph legend27 Aug 2007 16:52 GMT2
In Excel 2003 I have created a graph with a legend for 3 x data series but
inadvertently deleted the legend for one of them.
I have looked everywhere - how can I reinsert this?
linear adjustment in excel27 Aug 2007 16:50 GMT3
I am trying to take a set of columns of numbers and adjust them so
they are all the same length.
I.e., i have data that looks like
1                            0.2454
 
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.