table1

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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