Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. tmr064

    Excel, look for complex formulas

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

    Excel page break question

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

    Copy and Paste

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

    Excel, copy names with a table?

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

    Excel, copy names with a table?

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

    Excel, copy names with a table?

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

    Adware loading from Tek-Tips

    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"!
  8. tmr064

    Adware loading from Tek-Tips

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

    Unlink a worksheet

    TiggerToo Try Edit|Links|Break Links
  10. tmr064

    Excel database and report question

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

    Excel inserting "=" in front when I enter a date

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

    Excel inserting "=" in front when I enter a date

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

    using dynamic named range

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

    using dynamic named range

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

    using dynamic named range

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

    need beginner info, what folders to put web pages in

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

    need beginner info, what folders to put web pages in

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

    Excel macro not pasting # of cells as relative ref

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

    In an Excel environment, when chang

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

    In an Excel environment, when chang

    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?

Part and Inventory Search

Back
Top