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 / October 2007

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
Update Values from a Userform29 Oct 2007 19:03 GMT1
I'm trying to update some information in ms access from a useform in
ms excel. My problem is that I don't known how to do for the vba code
understand the values in my form...
This is the code:
Log changes to Excel file29 Oct 2007 18:14 GMT3
Is there any way to keep a track of changes made to an Excel file?
I need to make a file that is open for changes to several people.
But, I need to keep track of who changes what when.
My ideal is to have a kind of logfile that keeps track of the user,
Excel macro for cell merge29 Oct 2007 15:59 GMT1
I used to use Lotus 123 when I was working ages ago.  I have Excel 97
and know next to nothing about using it.
I have imported my checking account records for one year into an
Excel worksheet.  The first column is called Post/Tran and there are
Return subset to drop down box29 Oct 2007 15:28 GMT3
I work at a production plant. We have 3 shifts.
I have a workbook to track production.
On the opening sheet of the workbook I would like each supervisor to
input which shift (1, 2, or 3) they are inputting data for via drop
Extracting email addresses from spreadsheet29 Oct 2007 13:49 GMT1
I have a spreadsheet that has a column that is a series of email addresses.
The names show up when I look at the spreadsheet but they are linked to the
email address.  Is there a simply way to make a distribution list from this
spreadsheet?
Prevent formulas changing when moving value29 Oct 2007 12:06 GMT3
Since my place of work moved to Excel 2007 I regularly run into this kind of
problem.
I am filling in a timesheet with columns for monday-friday (columns D to H).
There is a total column at the end (I). The formula in the total column is
Formula Query29 Oct 2007 11:44 GMT2
I am using a formula to count the number of occurances of an entry - in an
ever expanding list of data.
The formula that I am using is as follows:
=COUNTIF(ActualWeight,">=20")-COUNTIF(ActualWeight,">29")
Can't insert rows - "Cannot shift object off sheet"29 Oct 2007 11:15 GMT1
I am using Excel 2007 and have just loaded a spreadsheet created in a
previous version which is running in Compatibility mode.  When I try to
insert a row I get an message "Cannot shift objects off sheet".
How do I insert rows on this sheet?  No problem with another workbook ...
Excel add-ins - "xla could not be found" - stop message29 Oct 2007 02:59 GMT2
Recently I started using Excel add-ins (xla files) -- which I have
found very handy. For example, I have an add-in that can add a
contents page to my workbook, or the list the file contents of a
folder, etc. The trouble is, if someone, who doesn't have same xla
Excel 07 - Failure to Open Correctly29 Oct 2007 02:33 GMT10
I have the same problem with Excel 07 on Vista and it is becomming more
frequent.  When you start the application a blank window appears without the
normal Excel header bar, but with an out-of-focus top bar with 3 icons where
you can display a different magnification of the blank ...
Indirect and Concatenate to return Names29 Oct 2007 02:20 GMT3
I had another post which was very gratefully answered concerning the
use of INDIRECT to return a list of employees who work on a user-
chosen shift in the form of a list box.
Now I am wondering if the employees names are broken up into FirstName
How Do I Access Office 2003 Programs after I Upgraded to Office 2007?28 Oct 2007 23:07 GMT2
I had a need for accessing Access 2003 and Excel 2003 after I upgraded to the 2007 versions of the programs.  I'm sure there must be something to allow me to do so, where did the upgrade entirely erase/delete what is now an obsolete program?  Is not the data and programs I need, ...
finding pivot table base data28 Oct 2007 21:40 GMT1
I have been forwarded an excel sheet which contains many tables. However,
the tables have similar headings. It also has a couple of pivot tables. My
problem is that I want to know on which particular sheet of data a
particular pivot table is based on. Is there a way to find out? ...
Sorting/Locking Header28 Oct 2007 21:32 GMT7
I am trying to be able to sort and not have my header sort with it.  I want
the header row to be locked.  I've used the excel help where it says to click
Data, Sort, then My Data has Header Row.  I then click ok.  But, then it
defaults back to No Header Row.  How do I make it ...
sum if28 Oct 2007 21:29 GMT3
I want to add the values from cell A1 to A6.  However, if any values is
greater 8, I must minus .5, then add them.  If they not greater 8, then just
add them to the total.  How do I do this in an sum if statement?
 
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.