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 Wanet Telecoms Ltd 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: CEN7272
  • Content: Threads
  • Order by date
  1. CEN7272

    XL 2K - Is there a limit on how many func. can be used in a formula

    Lately I've been running in to a problem where seperate parts of a formula work but when I try to put them together I get error messages...WHY!!! -Clay claysdays.blogspot.com
  2. CEN7272

    XL 2K - Shortcut for Tools\Options...

    I know this isn't a big deal and I know I can always use Alt+T and then O, but I was wondering if there was any other shortcuts for this...if not...is there a keyboard shortcut for viewing page breaks? -Clay claysdays.blogspot.com
  3. CEN7272

    XL 2K - Function prob...using Sum & Indirect

    First off, cell B1 contains the name of a sheet (sheet1) and cell B2 contains the name of another sheet (sheet7). I want to get the average of cell B6 from sheets 1-7. I can accomplish this by using the following formula: =SUM('sheet1:sheet7'!B6) however it may not always be sheets1-7...
  4. CEN7272

    I want to vlookup from the rightmost column of the range

    I would like to lookup something in the right most column and return the contents of a cell to the left of it. I figure that I could do an offset to go to the left, but I don't know how to lookup sometihng and just return the cell reference (to plug into the offset formula) Maybe I'm going...
  5. CEN7272

    Please say there's a solution!!!! Macro/VBA Excel problem

    I have (or had) a workbood with loads of code that I've been working on for the last 2 weeks. I have a back up of it as of 3 days ago, but I've done alot today and yesterday. I think that I copied some code and pasted it at the bottom of a macro...it was supposed to be temporary, but I...
  6. CEN7272

    How to link a cell to AutoFilter "custom" criteria

    I'm not new to Excel but just starting to learn about VBA. I tried recording a macro but it isn't working and I don't know enough about the expressions to correct it. I need to copy the contents of a cell and paste them into the custom search of the autofilter as a "contains" search. Here is...

Part and Inventory Search

Back
Top