table1

  1. S

    Using a lookup table to populate a column in Source Table.

    Hi Here is what I am trying to achieve: I have a Table1 on Sheet1 in my workbook. I am trying to get a macro setup that looks up against Table2 (located on Sheet2 in my workbook) using the STATE and TYPE columns When the criteria matches the PRIORITY Value is copied from Table2 into the...
  2. D

    Vlookup and match?

    Two tables of data... I have table1 with headers which I need to do a horizontal lookup on to match table2 with the same headers I have a serious of columns of data in table2 which I then need to do a vlookup from - find a specific cell in a specific column, Is it possible to do this using a...
  3. D

    Trouble highlighting row data.

    <tbody> TABLE1 J A N U A R Y 1 2 3 4 5 6 7 8 9 10 TEAM1 X X X X X TEAM2 X X X X X TEAM3 X X </tbody> <tbody> TABLE2 TASK START DATE END DATE TEAM1 Y 1jan 3jan TEAM2 X 3jan 7jan TEAM3 B 9jan 10jan TEAM1 X 7jan 8jan </tbody> I am having issues with TABLE1...
  4. S

    [VBA] Copy/Paste Values to New Workbook and Separate Tabs

    So I have somewhat of a complex requirement that I need some help with in VBA. I currently have 1 Workbook (Payroll Tracking) which as you can imagine, tracks payroll numbers. Haha. What I would like to have it do, with a command button is to copy/paste (Values) from 1 table to a new workbook...
  5. T

    Approximate match / vlookup

    The problem I have involves looking for records within 2 tables. Table1, (the source), contains 100 records. Table2, (the sink), contains 1000 records. So to check if each record in Table1 is contained in Table2, looping would involve 100x1000=100,000 times (if I'm not mistaken). If instead I...
  6. T

    Matching and lookup

    I have two tables as per below. Table1 <tbody> Field1 Field2 Date Result 1 a 01/01/2010 2 b 02/01/2010 3 c 03/01/2010 4 d 04/01/2010 5 e 05/01/2010 1 a 01/01/2010 2 b 02/01/2010 3 c 03/01/2010 4 d 04/01/2010 5 e 05/01/2010 </tbody> Table2 <tbody> Field1...
  7. P

    Change query, updated column based on cel value

    I have "inherited" a database to maintain. In it is TABLE1 with a unique staff number, followed by several columns with the qualifications each staff member can have. In TABLE2 I have feedback from trainers. They fill this in to let me know someone has a new qualification. There is one field...
  8. C

    filter a formatted table based on value in another cell

    I have a formatted table named Table1. I have a validated drop-down list in cell B2. Is there a way to link the value in B2 to Table1 so that the table is filtered by column 4 to the result of the value in cell B2? For example, the user would select "Apples" from the list in B2, and Table1...
  9. H

    Complex Dropdown in a Cell

    I'm creating a Level of Effort Calculator. I already have some complex VBA macros that help add or delete specific data in the various tables across the worksheets in my workbook, so if VBA is required, that's no big deal. The summary of it all is that in table1, I have a dynamic Data...
  10. M

    Countifs matching two separate tables

    Hi I have this formula but stuck on the last condition. I want to count based on Client Name in current table where it finds a match to: table1 client name & is not OOS/Lost AND if the country is listed both on table1 matching a table in another sheet which is called 'Prority 1' this last...
  11. Jerry Sullivan

    VBA anomaly when filtering table from Worksheet_Calculate

    When the user filters Table1, my objective is to have Table2 on the same sheet filtered so that both tables have the same ID items visible. Since VBA doesn't have an event that is triggered when a table is filtered, I'm using the Worksheet_Calculate event which is triggered due to the presence...
  12. J

    New to DAX . . . simple RELATED

    i did this years ago, but cant replicate what i did. I have Table1 and Table2 and with a relationship of Column1 = Column1. there is only one column in table1 and two columns in table 2. All i want to do is bring in the value in Column2, called junk, into Table1. There are 500,000 rows in...
  13. C

    Sum fields in table1 based on a definition of that sum in table2

    I have a table of data similar to this (lets call it "table1"), containing it's own row and column references (in red - ie. different from the Excel col & row references) and also containing subtotal rows and subtotal columns eg: <colgroup><col style="width...
  14. B

    Need help with an access max/dlookup

    Hi Everyone, I'm an absolute novice at best with Access but am trying to learn. I am running the code below on a button in a filtered form. What I would like to do is run it after my last field is entered IN THE FIRST RECORD and I press the ENTER key creating a new record. In addition in the...
  15. D

    Merge 2 tables in different sheet

    Hello everyone, I have a quick question, I have 2 sheets with 2 tabels looking like this: Table 1 - sheet1 Table 2 - sheet2 I want to somehow do the following: Do all job in new sheet1 From Table1 (A column) find match in Table2 (E column) Copy content from Table 2 (D column) Paste it...
  16. S

    Copy data from one table to another - hidden columns

    Hi I have 2 sheets; Sheet1 has Table1 Sheet2 has Table2 Both tables have identical headings, however both have multiple columns (same) hidden to make ease of viewing I'm looking to create a macro that will copy the table contents of table1 into the last completed row +1 of Table2. Essentially...
  17. V

    Excel array index/match vlookup to another table and multiply results

    I have 2 tables: Table1 - FG parts with QOH <tbody> A B 1 FG FG_QOH 2 a 1 3 b 2 4 c 3 5 d 4 6 e 5 7 f 6 </tbody> Table2 - BOM of Comp related to FG and CompQtyPer <tbody> D E F 1 FG Comp CompQtyPer 2 f x 2 3 e y 2 4 d z 2 5 b x 3 6 c y 3 7 a z 3 </tbody>...
  18. L

    vlookup with structured table (Insert-->table)

    Hi Is it good idea to name insert a table (Insert-->table) on the sheet I am working with when I use Vlookup() function? vlookup(x, table1, 3,false) I thought it is not good idea because if the lookup value (x in this case) is not in the first column then I need to highlight the range to make...
  19. S

    Excel VBA renames table

    Hi, I have a macro that changes a range into a table. This workbook does not have any tables to begin with. I am creating new functions in the workbook, so I am adding some new sheets created in another workbook, which have tables 2,3, and 4 (Table2, Table3, Table4). When the macro is run I...
  20. L

    What's Wrong with My ORDER BY Clause???

    Hello I'm hoping somebody can educate me around this puzzle. I've been trying to sort descending on a basic calculated field within a basic query. The ORDER BY clause refuses to work however (keeps prompting for parameter values to be entered) unless I use the field position indicator...why...

Some videos you may like

This Week's Hot Topics

Top