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

    Excel data selection

    Hello all, I have a really messy Excel file and was wondering how I would go about selecting data based on the following example (VBA code would be good): A B C D E value 1 n 100 2 n 200 3 n 200 4 n 400...
  2. celestedeeva

    Selecting data in Excel with VBA

    Hello all, I will be receiving multiple Excel files - they will all have the same format as to where the data is as follows for each file: Type 1 Name 12 John 12 Jane 12 Anyone 34 Mike 34 Celeste Type 2 Name 45 John 45 Jane 45 Anyone 99 Mike 99...
  3. celestedeeva

    Access SQL query to update field

    Hello all, I have a field with the following inside each row stored as text. ID Value 1 21 34 5 2 21 5 3 21 34 I need to do two things 1st I need to update the field "Value" to: ID Value 1 21,34,5 2 21,5 3 21,34 2nd I need to create the table to represent: ID Value...
  4. celestedeeva

    Need help creating a tables

    Hello All, First off many thanks for any help provided. I have one table as follows: Unique ID Purchase Type 1 a 1 b 1 c 2 a 3 a 3 b 4 a 5 a 5 b 5 c Table 1 - need a query to...
  5. celestedeeva

    Query to adjust table

    Hello all, I have the following table Type QTY 1 50 2 1000 3 600 5 800 9 1000 12 2500 50 1000 51 1000 55 20 What type of query could I run so that I would end up with the following? Type QTY 1 Distribution 50 2...
  6. celestedeeva

    Application.GetOpenFilename as new worksheet in current workbook

    Hello all, How do I use the: Application.GetOpenFilename("Excel files (*.xls), *.xls") so that the selected Excel file is opened into a new worksheet of he current workbook with the worksheet name the name of the selected excel file from the Application.GetOpenFilename("Excel files (*.xls)...
  7. celestedeeva

    Manipulating data into multiple rows

    Hello all, I have the following table: UniqueID ID1 ID2 ID3 ID4 1 A B C 2 B C D E 3 A C 4 C D E I would like to make the following table: UniqueID ID 1...

Part and Inventory Search

Back
Top