Table to Table

Evapar18

Board Regular
Joined
Aug 3, 2018
Messages
86
Office Version
  1. 2019
Platform
  1. Windows
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
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).
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>
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,194
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top