Recent content by tmr064

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