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: DanaPach
  • Content: Threads
  • Order by date
  1. DanaPach

    Can you sort by color in Excel

    Hello! I have a question (not sure if even possible). I have a spreadsheet that I am seperating the types of data by colors. For example: Duplicate records are pink, records that do not need modification in peach, and updated records in yellow. Is there any way to sort the data by color...
  2. DanaPach

    EXCEL-NEED TO LINK FIELDS

    I need help. Here is the situation. I have two spreadsheets, Location & Equipment. In both spreadsheets, I have an equipment field and location field. However I need to change the locations within the Locations spreadsheet. I want to change the locations within the Location spreadsheet, and...
  3. DanaPach

    Need to find duplicates in Excel Spreadsheet

    I have a spreadsheet in Excel that contains company names and addresses. I need to find the companies that have the same address. I will also need to delete the company names if they are duplicated. Please help me with VB or please give some direction. I greatly appreciate anyones help...
  4. DanaPach

    Seperate Data in Excel

    Hello, Another situation I need help with, I'm needing to seperate the following into 3 seperate fields, as opposed to one. This is the current format-in one cell Mesa, AZ 85204-6632 Need the City, State, and Zip seperated. I have over 20,000 records to seperate and need a quick way to do...
  5. DanaPach

    Seperate Data in Excel

    Hello, I need help seperating data within a cell in Excel. I need to seperate the Code and the description. I would like the Code to be in one cell and the description to be another cell. For example: 2095ManufacturingCOFFEE EXTRACTS is combined in one cell. I need 2095Manufacturing to be in...
  6. DanaPach

    Get Rid of Default Error Messages

    I have written an event procedure for 'On Not In List' for a Combo Box - to bring up an error message that I wrote. However, once they click ok on my error message, Access brings up it's own error message right after mine. How can I stop it from doing this?? Any help would be greatly...
  7. DanaPach

    Need help with Filters in a Report

    I am adding a filter via VB directly into the 'Filter' under the 'Data tab'. It is working, however, I need to add 2 types of criteria but don't know how to set this up. The reason I am adding this filter in the report is because it is reading from a crosstab query - and does not recognize a...

Part and Inventory Search

Back
Top