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
Macro help28 Aug 2007 02:30 GMT4
I have a table with thousand of row of data. The column consists of part#
and operation, etc....
Within the data rows, there are multiple rows with same part#, but at a
different operations in numerical 10 to 999. I would like to create a macro
Disapprearing Zero28 Aug 2007 02:27 GMT6
Hello, If anyone can help.  I am using a excel for filling out time sheets
where I work and when I enter the start time of my job excel is kicking out a
number.  for example I need to input this 0830 when I hit enter or move to
next cell it turns into this 830.  Problem is that ...
Automatic update formula when worksheet 1 move to another excel fi28 Aug 2007 02:19 GMT3
I have 25 worksheets on excel 1. I decided to shift the first 10 worksheet to
another excel file (excel 2). But on excel 1, I have a summary page with
formula from some of the worksheet file. Is any way that the summary page
will update if I move the first 10 worksheet from excel ...
Creating a button in excel that adds one to a cell28 Aug 2007 01:12 GMT2
I am creating an attendance list in excel and need to know how to create a
button, that when clicked, adds on to the assigned cell. there will be five
buttons for every name on the list. One for each school day of the week.
Thanks for the help.
Reference to an Outside Excel Document28 Aug 2007 00:44 GMT1
Is there a way to have the data in an excel document be linked to another
excel document?
For example, I want to keep track of my charges and deposits to various
credit/debit cards.  I'd like to have an excel document for each card.  I'd
Average function not returning expected result28 Aug 2007 00:36 GMT4
I have a column of 25 numbers that include zeros that total 74.  I have
applied the average function and rounded the result to two decimal places.
ROUND(AVERAGE (number 1,number 2...),2).
The result that I am receiving from excel is 2.64.  When I use a calculator
Access macros in Excel - populate results in spreadsheet28 Aug 2007 00:30 GMT3
I've got a macro in Access that runs two Append Queries to a table.  I want
the resulting table to populate an Excel worksheet - can I use the Import
Data function in some way to do this?  I already use it to Import some
regular query results.
Using variables within a formula in the same cell.28 Aug 2007 00:14 GMT5
How do I make a formula with a variable (ex. 4+x), and make is so when I type
in a number into that cell it puts that number in as the variable? Is this
even possible? Thanks for your help in advance cause this problem has taken
way too much of my time already!
Formula is being added automatically28 Aug 2007 00:07 GMT1
I have a spreadsheet that our office uses to calculate payroll hours.  When
different users open it up (it is a shared worksheet) some formulas will
automatically copy.  What would be causing this?
how to convert the fraction to a percent28 Aug 2007 00:02 GMT1
how to convert the fraction to a percent plz
Summing a Variable Number of Cells27 Aug 2007 23:43 GMT1
I have a spreadsheet that calculates values for each year out to a given
date. If I want to know what the sum of some specific time period is and not
necessarily the entire column, how would I instruct excel to only add a
variable amount of rows on a specific column?
VBA SaveAs Value27 Aug 2007 23:33 GMT4
I have a startup macro on one of my worksheets.  It has the user input a
batch number into cell a1, and then it saves the file as the batch number.
The batch number is something like 01.ABC.255.  When I try to run the macro
listed below, the file saves as a .255 file instead of a  ...
Count column if heading exists27 Aug 2007 23:32 GMT4
Hi, I have a report that calculates passed, failed, and N/A results. These
are also the titles of the columns. If one of these columns does not exist
then the calculations fail.  I would like to know if there is a way to only
calculate these columns if they exist.
Logically Calculating Multiple Fields27 Aug 2007 23:08 GMT5
I would like to see if someone can help me with this calculation. If cell E2
is 10% or above, we would like cell H2 to add one for each cells of A2, B2
and C2 that have a score of 6 or higher.
Essentially:
Help !!! Office 2007 "Rows to Repeat at top"  how ????27 Aug 2007 23:03 GMT1
in the older version of excel, you repeat rows on top from the "File and Page
SetUp", in the newer version 2007 its not there, how do i do this ???  Any
ideas ???
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 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.