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 / July 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Can my excel doc be made into a calendar?27 Jul 2006 17:30 GMT1
I have an excel document that is fairly large in my opinion, is there a
way to make the information in the excel doc populate a blank
calendar??
Will need to take a combination of v and h look-up
Importing data27 Jul 2006 17:19 GMT2
I'm building a datbase using Filemaker Pro for Macs.  I can import data
from an Excel spreadsheet into the datbase pretty seamlessly.  I would
like to send out an excel template and have people fill in the needed
data (names, phone numbers etc.)  I would like to merge all this info
Vb ranges - Newbie question27 Jul 2006 16:51 GMT3
I am defining a range in an application:
Set rnge = range("csv_update")
this works great as long as the code is executed from the worksheet that the
range is on. I would like to hide this sheet and execute the code on a sheet
Cell/Worksheet references27 Jul 2006 16:04 GMT2
In Excel, how can I use the contents of a cell in a formula to direct to
a specific worksheet.
I have several worksheets and I want to extract the contents of a cell
on a specific worksheet by using the contents of a cell to name the
Excel can't find file27 Jul 2006 16:03 GMT7
I had an Excel file on my desktop, but when I moved it (cut and paste,
copy and paste, or move with mouse) I get the following error (No Code)
when I try to open the file.
-'C:\file location.xls' could not be found. Please check the spelling
Array Formula27 Jul 2006 15:50 GMT5
I need a formula to count disctints like =
SUM(1/COUNTIF(C26:C46,C26:C46) but I need conditionals in the range and
criteria of countif.
I've tried this, but its not working.
Range name table27 Jul 2006 15:44 GMT4
I want a list of all the defined names and their cell references.  This used
to be done in Lotus by Range/Name/Table.  I can't find the equivalent in
Excel.  Can it be done.
Thanks.
Averaging compound numbers, e.g. Blood Pressur27 Jul 2006 14:15 GMT13
How does one average blood pressure readings?  Please give an actual
example, such as 152/65.
Problem with minutes27 Jul 2006 13:38 GMT2
I have got a rota for bar staff, i have done that in excel.
Day | Staff No. | Staff Name | Start Shift | Finish Shift | Hours |
Minutes |
Mon | 1 | John | 12:00 | 17:00 | 5 | 0 |
Exporting add-in containing dll functions to other computers27 Jul 2006 12:42 GMT1
I developed an add-in for excel 2000 containing wrapper functions for a
dll I made as well. Now I'm trying to export this add-in to another
computer by copying the add-in to the other computers add-in folder(ie.
C:\Documents and Settings\"YourUserName"\Application
Excel slow down27 Jul 2006 12:41 GMT3
i have been using excel to fill in weekly time sheets, one sheet per week.
All the workbook contains is a few formulas to work out and total my decimal
hours each day, and a short macro to copy and clear a new sheet for a new
week (with a userform to get the week start date).
Convert text to time format27 Jul 2006 12:15 GMT2
I am unable to convert a piece of text that i copy paste from an
external source to time format. Suppose I copy, "July 24 2006,  05:31
PM" and paste the same in excel it just assumes that that the entered
data is text and I am unable to format the same. I need to convert this
sheet names27 Jul 2006 10:00 GMT6
What returns the name of a worksheet in a workbook if you are in the
workbook.
for instance: findit(1) gives the name of sheet 1.
Thanks
Problem vertically aligning multiple rows with tickboxes added using VB.27 Jul 2006 09:30 GMT4
I searched for days to find the solution to adding a column of
checkboxes down a table with 500 rows in it - a checkbox at the end of
each row. The good news is that I eentually found that someone had
posted a little VB code that did it nicely.  I used some additional
Excel 2003 upgrade27 Jul 2006 08:53 GMT3
What is this product on sale at the moment called 'Excel 2003 upgrade'?
I have a workbook written in excel 2002 which contains lots of vba
control elements and Visual Basic elements such as common dialog
objects (it took me 4 months to write!)
 
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.