Table to Table

Evapar18

Board Regular
Joined
Aug 3, 2018
Messages
54
I have two tables one on sht 1 and one on sht 2. Its nearly the same table, except sht 1 has detailed information about the people and sht 2 is just the first and last name.

What I am trying to accomplish is when I add a new name or row to Table 1, table 2 will update with the new row and within that row, it will use the formula I already have in the other cells of sht2. Which is linked back to table 1.

What I did find when I added a row to table1 sht 1 manually and then added a row between the same two names on table 2 it would pull the wrong names in. When I reviewed the formula it would pull in either the row above or below, not the one I need unless I go to the name above then add the row above that. See the attached video. It just does not make logical sense to me.

Video:
http://www.screencast.com/t/CMGwB2HSa

File:
https://drive.google.com/file/d/1Ek35B40ZDMj29D6Ft1-3ULxOHnsFYh88/view?usp=sharing
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
11,003
agepretend sheet 2
billjones21billjones21
fredsmith33fredsmith33
tomjones69tomjones69
sidvicious99sidvicious99
bill is obtained by
when I added sid vicious he appeared correctly in sheet 2=IF(A2="","",A2)
you can drfag down the formila in sheet 2 as far as you want

<colgroup><col span="12"><col><col span="3"></colgroup><tbody>
</tbody>
 

Evapar18

Board Regular
Joined
Aug 3, 2018
Messages
54
So the cells in sheet 2 looks like this

Code:
=IF('GEASWUG Contact List'!$B2="","",'GEASWUG Contact List'!$B2)

That does work, but now my sort button fails error message: "Auto filter method of range class failed":

Code:
ActiveSheet.ListObjects("Table4").Range.AutoFilter Field:=13, Criteria1:= _
        "1"

The criteria is "1" and it's set to "Table 4", what could be the problem?
 

Watch MrExcel Video

Forum statistics

Threads
1,109,009
Messages
5,526,258
Members
409,689
Latest member
martin_br

This Week's Hot Topics

Top