I have a form that I want to automate. I have several names in a drop down
box. I would like for each person named in the box to click on their name,
input their data, then send it to (populate) a spreadsheet list and close.
When the next person selects their name from the ...

I have to manually calculate the time someone has worked using timecards.  Is
there a formula where I can plug in the time and get the answer?  I saw one
question where this was posted but it didn't help.  For example, he worked
from 7:40 AM - 11:37 AM and then came back to work ...

Hi,
I received a file with a macro that creates a interactive form for changing
data.  My problem is that everytime I want to use this macro in a new
spreadsheet it alway opens up the spreadsheet where the macro was created.

my new problem is that the if statement doesn't like the wild
character... ie)  =SUM(IF(A1:A6="chips*",B1:B6,0))
Any way around this??
Thanks

Need to create an Excel Timesheet that calculates the hours and minutes
worked daily, based on the time-in/time-out. Then allow the calculated daily
time to total for the week. Am having to make Excel jump through hoops so
far. Any ideas/suggestions?

When I open a workbook, one formula may or may not show the #VALUE
error. After pressing F2 and <Enter>, the formula is calculated
properly. I have tried using the CTL+SHIFT+ALT+F9 to try to refresh the
dependency table and then saving the workbook. Upon reopening the

Does anyone knw why the 'Compare And Merge Workbooks' facility under the
'Tools' menu is never available (grayed out), and how to make it available
please?  It sounds like it could be quite useful, but I haven't got the
opportunity of using it.

Help!!  I have a spreadsheet which is linked to about 30 other
spreadsheets.
Most of the functions are just 'sum's and 'sumif''s.
When I have all spreadsheets open, the values are updated in the main

I want to see the souce field for each of page field,row field,column field
and data field of pivot table. if I right click on the pivot table and  
select the field settings property , I could get the "source field" on the
top only for data fields . I couldn't see the source for ...

I am trying to create a formula that will look for a value on another
worksheet and return a number of values from the same row of each
instance it finds....
The worksheet I am linking to is formatted as follows...

I have created a series of reports from a common table using custom
views.  I want the title of the report to change based upon the view
selected.  Is there any way to have a cell display the view that is
currently being applied.  I know that i can change the header / footer,

How do I report problems to MSoft?
Example: Formating boarders are translated from Excel 2003 to Excel 2007 as
text boxes.

This is the formula to calculate if assessments have happened, going to
happened or hasn't happened
=IF(NOW()-AF2=0<>365,"ASSESSMENT CARRIED OUT THIS
YEAR",IF(NOW()-AF2<0,"ASSESSMENT PLANNED FOR THIS YEAR BUT NOT CARRIED

I have given a data validation for A1. The column is validated to
accept the data only if B1 is true.
The issue is, when i drag down the validation from A1 till A100, the
validation is not changing respectively.

am new to the group (few days old), so apologies for any repitition -
pls guide me to the previous strings in that case.
I am aware of J-Walk's SheetOffset function for obtaining a particular
cell/range reference from a different worksheet. what i'm looking for