Search results for query: *

Thanks guys! Skip always appreciated. I'll give some thought to this. These used to be separate files and I'm grouping them together as one. I'm going to reread your post adn see if i can understand it and apply it. I think that Orientation only takes place 2 weeks out of the month and that...

I'm having some date formatting problems. I've looked at the following thread but was not able to resolve my problem. http://www.tek-tips.com/viewthread.cfm?qid=1409951 My excel file is found at this location. I could not upload it while on my work computer...

have a column of cells where users put in "Y" for yes and "N" for no. However, when i count the Y's and N's, if there is a space after the letter, it will not count the character. I can't depend on users to remove the spaces,they are not that computer literate. Besides spaces are hard to see...

Thanks. I did revise these files once. So I may have made a mistake. That is why i don't like making multiple revisions quickly. So maybe its my fault. Skip, you are wonderful guy. So i can't complain. :-)

It does look like something is wrong with the links. But i don't know why. It have the whole path showing. But when they were created it only have the abbreviated path. I'll try to do a search and see if i can change all the paths back but that will be a lot of work because i protected all the...

Message: "This workbook contains links to other data sources. - If you update the links, Excel will attempt to retrieve the latest data. - If you don't update the links, Excel will use the previous information. Note that data links can be used to access and share confidential information...

I think i understand circular reference. But i don't understand why Excel decides for itself when to change a formula i didn't ask to be changed. Thanks for the reminder on absolute reference. I've used that before. I forgot. But i still don't understand why Excel changes formulas just because...

One stupid thing i hate about Excel is the circular reference. Maybe it has a purpose but i don't see one. All i do is cut and past info in one cell to another and then the formula becomes a circular reference. How can i avoid this? Does protecting the sheet prevent circular references from...

Thanks Skip. You are right. I tried it again and it worked. But I know i had all my pages selected when I went through my worksheet and locked the cells i wanted protected. Well, i guess i'll try it again. Thanks. Maybe I did something wrong.

Similar data on multiple sheets--Yes! Each sheet looks exactly the same. Much of it is tabular--a way of calculating Y and N. I would rather create a db and have an application store the info, but that would take more time. So using Excel has been the easy solution for now. I was ot able to...

What appears to work is... If i format a sheet and unlock destinated cells and then cut and paste the worksheet on different tabs, the format is maintained. That way i don't have to format or unlock cells on each sheet. The only problem is that i will have to redo all my formulas yet again and...

I found this article on the Internet. http://support.microsoft.com/kb/142111 But how do i lock and unlock cells on multiple sheets. I'm more concerned about this. Even if i can protect the sheets it matters little if people can't enter any information on the sheets at all. The whole purpose of...

I was trying to protect multiple worksheets at a time. So i selected the tabs at the bottom and started unchecking the Locked check box after going to Format Cells. But what i found out was that it was unlocking the first sheet but not all the following sheets. I have 40 worsheets in this book...

I thought i replied to you man, i don't know why my reply didn't post. Uhh... I just wanted to be clear about what app i was using because i wasn't clear. I still didn't state which version which is also important. Thanks!

Sorry, I'm talking about MS Excel, I often forget that this is an MS Office forum. I'm working in Excel and I've never been able to change page breaks in normal view.

Is there a way to set page breaks for multiple sheets? I have 40 sheets and a total of 900 pages per sheet. Selecting all the tabs and trying to adjust the page breaks in Page Break Preview doesn't work. will changing the margins for all the sheets work? Any suggestions? Thanks!

The range was B7:B24 but i had several rows of records. I went to the right most end of the worksheet and started over on the next row. So I had 60 rows with what 17 criteria each.

Thanks Geoff. That helped. It has to do with relative cell reference. I typed this into the Search on MS Excel and clicked on "Switch between relative, absolute, and mixed references" The Dollar Sign defines what is relative and what is absolute. So if i want the column to be Relative, then i...

Thanks but i don't know how to make it relative. Also I'm checking a range of cells in each column about 10 or so not just one. I selected teh range of record numbers. I clicked Conditional formatting. Under Formular IS I clicked and so that an equal sign appeared. I clicked B7 (rather than...

I have a row of records. Underneath each row are criteria that the records must meet. If i put an N in one of the spaces, I would like for the record number to highlight in a different color. The formular i have is =COUNTIF($B$7:$B$24,"N")and it works BUT ONLY FOR THAT ONE COLUMN. How do i...