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 / New Users / May 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
use pull down menu to select a picture03 May 2005 12:39 GMT1
I use the Combo Box pull down menu buttons a lot.
I click on the Box, select an item from the list and the relevant data pops
up as expected. How can I make a picture pop up when I select an item from
the Combo Box List?
formula... PLEASE HELP03 May 2005 05:07 GMT2
I have what I think is a formula...on
Sheet 1  I have a total $ amount for items sold. I typed in L3+M2 (the L
column is profit and M is the total..NOW..on Sheet 2 I have the same thing
for different items,
How do you sort words in Excel by the number of letters in a word02 May 2005 23:42 GMT2
I have a list of 5,000 words that I need sort by the number of letters in the
word for my students is this possible to do?  The words range from 1 letter
to 9 letters in a word.                        
How do I calculate the age of a person?02 May 2005 22:39 GMT3
If I have the date of birth, how do I calulate the age of a person?
Thanks
Doug
Clear Comboboxes & Textboxes02 May 2005 22:29 GMT3
I have a userform containing various VBA controls such as comboboxes,
listboxes and check boxes.  I want to provide the option for a user to clear
the form.  I have tried the below code but get an error message stating
'Compile error - Sub or Function not defined'
Copying to Clipboard query.02 May 2005 21:42 GMT4
I need to copy a column of 40,000 numbers to the clipboard,
using Excel as a database, carry out 12-15 sorts
dropping the clipboard contents into vacant columns as I go.
After I try a sort, the paste option no longer offers.
Print Area.02 May 2005 21:39 GMT2
I set "Print Area" and print,
whereupon I choose "Clear Print Area"
and I suddenly am the recipient of sundry lines
of dashes throughout the sheet.
Sequential Numbering.02 May 2005 21:35 GMT3
I have a column of numbers in
assorted sequential but non contiguous blocks from 4 to 30.
I seek a formula to renumber them 1 and onwards,
until a lower number is found, whereupon they would begin again at 1.
How can I set different print areas in the same Excel sheet?02 May 2005 20:16 GMT2
I know very little about Excel since until recently all of my work was in
Microsoft Word.  However, people now email Excel documents to me to print and
I get more confused with each one.  
Is it possible to set three different-sized print areas in one sheet, each
Linking to External Data that has been moved02 May 2005 19:24 GMT7
Any help would be appreciated
I have this workbook that reads info in from data files (not exce
workbooks) which is then in turn used in another workbook t
calculate values. The problem is that these files were moved t
HOW DO i SYNCHRONIZE MULTIPLE WORKSHEETS IN EXCEL?02 May 2005 19:19 GMT7
I have 7 worksheets in a workbook.
all the worksheets have a lastname, firstname, employee ID in the A,B,C
columns of every worksheet.
I need to synchronize the worksheets so that when I click on an employee
Date Fields02 May 2005 18:06 GMT2
I have a spreadsheet that has 4 columns.
H=Month, ex 4
J=Day , ex 1
K=Year, ex 5
Data Validation w/custom + w/list02 May 2005 16:35 GMT4
Two cells, using data validation | custom... COUNTA($A1:$B1)<2
This works fine to prevent data in both cells.
But I also want to use a drop down list for the data selection in A1 and B1,
How can I do both?
Excel falsely asks me to save!02 May 2005 15:56 GMT4
Everytime I open a certain Excel doc, even if no changes are made, it asks
me if I want to save when I close it! Even if I open it and instantly decide
to close it!
Why does it do this and how do I get it to stop?
3 max values02 May 2005 13:27 GMT2
need advice how to get 3 biggest values of each row from table of 10 columns
into new table.
 
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.