Search results for query: *

In a workbook used to track rental income, one column shows the expected income amount for a month. On rare occasions, i will indicate that an additional amount is due by adding the additional amount to the standard rent. On rare occasions, I forget to remove the additional amount in the next...

I would like to have a bottom border on the cells above each page break. Is there a way to test for page breaks using conditional formating? Or, if there is a standard number of rows per page, can this be used? Thanks

Paul, if the two pages are in different files, do the copy as you did initially, then use Edit|Links to take off the references to the first SS and point to the current file and Excel will do the work.

Skip, The copy-sheet process worked perfectly, and saved lots of key pounding. What I have is the typical old kludgy SS that started with a voucher/report that was used to pay rents every month. Subsequently, it needed to extract some of the same info to generate text type flat file to upload...

Skip, the table, or more properly, a formatted report, contains more than 150 vendors to be paid monthly. Each vendor payee cell is "named" so that I can jump to that part of the report using the "name box" at the left on the formula bar. The "payee" cells are separated by other rows with data...

I would like to copy series of tables along with any Named Cells within those tables to another spreadsheet. The destination SS already exists and includes some complex, protected imbeded macros. Is this possible? Thanks Tom

Thanks, Corgano, It's about 10 days since my troubles started. A techie ran both Adaware and Spybot on my PC and cleaned up a bunch of stuff. I guess they weren't up-to-date because "it's back"!

I was just reviewing the Microsoft: Office thread and now I have an unwanted "searchbar" and advertising popping up. Anyone else having this problem?

TiggerToo Try Edit|Links|Break Links

A number of contributors ( XLBO, SkipVought and KenWright come to mind; I apologize to those I don't remember ) have made an effort to help others learn the benefits of using the database and pivot table approach to collecting and analyzing volumes of data. The concept is excellent. My question...

Andy, thanks, that saved hours of frustration. I never would have figured that out, although I should have made the association because it was in fact a converted 1-2-3 spreadsheet. I appreciate your help. Tom

I am using W/XP and Excel 2002. In one sheet only of a 5 sheet file, when I enter a date, i.e., 4/13/4, Excel makes it =4/13/4. Other sheets and other files are ok. What setting is causing this? I have reviewed Tools|Options and did not see anything obvious. The cell formating is set to a date...

Thanks, Ken, =rows() and =columns() gave me what I needed. Tom

Thanks, Tony and Skip. Skip, I had already used that FAQ. It was what prompted my questions. As far as entering the range name in a cell, I was just trying to verify that I had done it right. Any suggestions for that? Thanks Tom

With a base of Win/XP Prof. and Excel 2002, I entered some test data in A8 thru F15, did an insert/name/define, used a name of "testrange" (w/o quotes), and entered the following formula; =OFFSET(Sheet1!$A$8,0,0,COUNTA(Sheet1!$A:$A),6) in the refers to field. My questions are; 1...

Thanks, Jason! Great site. Do you or anyone else know of a description of the folder structure for IIS, i.e., what files go in what folders? How do the folders work together? Can you just write/copy HTM files to these folders? Sorry for the basic nature of this. Thanks

Is this the proper forum to request web beginner info? If so, where can I get how-to descriptions of where/what folders to put web pages for a new web site? We have a W/2000 server running, with IIs service running. What non Microsoft technical websites offer this kind of info? Thanks

I read this solution in the Ozgrid site; 1. hilite column A cells 2. Ctrl+g ( edit | goto | special ) 3. select "blanks" 4. select "ok" 5. press EQUAL (=) key 6. press UP ARROW 7. hold CTRL and press ENTER key

Mike, thanks for the explicit info. Now I know what to save in some other folder. The tech said "I didn't know that you could change that stuff!" Because I change the toolbar a fair amount, this info will help in the future, and a star to you for taking the time to respond. Also, I...

In an Excel environment, when changes are made to the standard toolbar, such as adding a button with a macro assigned, where is this information recorded, and can it be retrieved after a technician has uninstalled the previous version of Office, and installed a new one?