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 TouchToneTommy 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: *

  • Users: FletchUK
  • Content: Threads
  • Order by date
  1. FletchUK

    Excel lookups - include a cells value as range name?

    Hi all, I'm trying to create a lookup and I want the name of lookup range to be dependant upon the value entered into a cell. For example, if the user enters the name "Robert" in cell A1 I want the lookup to check the range I've named Robert. If there was only one name the obvious lookup is...
  2. FletchUK

    Excel - AutoFilter Misses Bottom Row

    Hi All, A colleague has a problem in Excel XP which has completely stumped me! When she applies AutoFilter to a list the filter is not applied to the bottom row of data. We've formatted the row so it's identical to the ones above - no luck. We have even copied a row from above and pasted the...
  3. FletchUK

    Excel Filtered Rows - Change Font Color Of Row Number

    Hi everyone, We all know that when you apply a filter to a Microsoft Excel spreadsheet the row numbers change to blue to indicate that filters have been applied. Is it possible to alter this so they change to red instead? Thanks, FletchUK There are 10 types of people; those that understand...
  4. FletchUK

    PrintPage - but not the current page

    I have PrintPage button on one of my web pages which prints out the tables exactly as they appear on screen complete with borders etc. The problem is that although the borders look good on screen (they are white) they don't look so good when printed out (they are black). If I set up a new page...
  5. FletchUK

    Can Web Pages Containing Excel Classes Be Viewed By Everyone

    Hi When I copy an Excel table and paste it into a FrontPage web page table I notice that the html code includes xl classes. Does this mean that only people with Excel installed on their machine will be able to see the table or do web browsers automatically know how to interpret xl classes...
  6. FletchUK

    Sorting Data In A Protected Excel Worksheet

    Does anyone know if it is possible to sort data in a protected Excel worksheet? I have created a sheet which has a command button which when clicked runs a macro to automatically sort the data into the correct order (it's a league table.) Everything works fine until I lock the worksheet (to...
  7. FletchUK

    Control Source

    I am try to adapt the Inventory Control database wizard supplied with MS Access. I have successfully adapted the tables and forms but I am having problems with the reports. I cannot find the control source for one of the existing objects.....I have looked in the tables, queries and forms but...

Part and Inventory Search

Back
Top