i have to keep individual files on each piece of equipment.
i am looking for a way to search a directory to see if the file exists.

Hi, I am experiencing some difficulty with what appear to be hidden
range names in my workbooks. I am copying a sheet in the same workbook
and keep getting the message that range in the destination sheet
already exist. I then have to press the Yes button or redefine the

I am trying to set up a calculation to round dollar amounts up or down.
Cents are not included in the calculation and the cells have already been set
to not do decimal places. I have gone through the existing rounding posts and
found several helpful items that will work with ...

I have a spreadsheet that has numbers entered as text.  (I don't know
why they did it!)  I want to convert these to numeric values so I can
sort properly, add, etc.  When I use =value(L2) I get an error.  Can
anyone help?

How can i count nos. those are >60 and <100 for a particular Branch.
(so there are three criterias >60, <100 and Branch also)

I am creating a timesheet that totals daily as total hours/ minutes worked
(4:06). We round to the quarter hour (up or down) based on the 7 minute
window.
4:01 to 4:07 would be paid 4 hrs. - 4:08 to 4:15 would be paid 4 hrs. 15

The task is blatantly basic ... but, nothing I've tried, to cure the #value!
err, works ??

I am using Excel and I need a function that look up a valule in column A and
returns the Text value from B, C, and D.
Here is what I am doing I got 8 sheets with people's names and in column A
on each of these sheets I have a value let say 1J, 2J, 3J, etc to 20J this

I would like to round numbers down not only to integers but also to 0.5 values
eg 6.7 would be 6.5 and 6.4 should be 6.0.
appreciate your help
Peter Lansberg

I have a dynamic drop down validation List, which comes from another
spreadsheet list and have a few random blank cells in it. I need to
drop these blank values from the List without making any change in the
parent list. I may also have some duplicate values in the List and need

i have done a rota for times work starts and finishes,and also a formula for
amount of hours worked in a week,but when i enter al(for annual leave) it
messes up my formula,is there ne way i can get AL to equal 5 hours worked

I have a workbook with about 40 tabs/sheets.  Nearly all of them are pulling
data from one source or another.  Therefore, nearly all the cells contain an
actual formula.  Plus the file is set to 400 rows for each of the sheets/tabs
to allow ample space for the actual entries ...

I have a rotation list that I would like to have automated.  I work a 7 day
rotation.
a1, a4, a7,  needs to rotate. a2,a3,a5,a6,a8,a9,a10 move down one spot
a1-  Jill            amy       Andy

I am trying to create worksheet that will print in sections - for instance if
I have 2 rows to print on page 1 and 4 to print on page 2.  Can I set page 1
to always print on that 1 page no matter how many cells I add?

I am using Excell spreadsheets and when I tried to open it from my documents
it went to a page which was not encoded. So I went to new documents and
opened it but now it wont let me pull down the menus ie file, edit, tools etc
it looks like a shadow has dropped down but nothing ...