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

    Sorting Envelope Addresses by Surname in Word 2000

    Hello In MS Word 2000, select Tools/Envelopes and Lables and then click Address Book. This displays the Outlook Contacts names and addresses. Whereas it is possible in Outlook to sort and select by surname, this does not seem to be the case in Word where the preference would also be to select...
  2. Caldew

    Data lookup between sheets using a lookup reference

    Thanks, I will also have a look at conditional sum formulas.
  3. Caldew

    Data lookup between sheets using a lookup reference

    Thanks for that. Yes I did consider a pivot table, but it is not appropriate for the type of formatted output I am looking for. However, I have, I think, solved the problem, using SUMPRODUCT. Many thanks.
  4. Caldew

    Data lookup between sheets using a lookup reference

    I have a 2-sheet spreadsheet: Sheet 1 contains data which is refreshed using ODBC. Col D contains report codes (each code might be repeated several times in col D). Sheet 2 is to be used to report on the sheet 1 data, accumulated by report code - effectively sheet 2 is a P&L account based on...

Part and Inventory Search

Back
Top