Updating Data in other sheet after filteration (LukeM plzz attend it)

[usmanhere]

here is the link for my excel file. I want that when the sheet1 is updated i.e. entry made in the next row, row in sheet 2 must be updated automatically.

Now before updating the sheet2, the date filter is to be applied. i.e. the data is to be updated which falls between particular dates.

I have seen the LukeM posts and found very helpful. Thats y i asked him to respond. other members plz dont mind

https://hotfile.com/dl/150377777/754d0f0/updating_data.xlsx.html

 

[Luke M]

Hi usmanhere,


Would one of the techniques described here work for you?

http://chandoo.org/forums/topic/copying-table-contents-to-other-table-based-on-certain-criteria

 

[usmanhere]

that was my post. but didnt work.

 

[Luke M]

Can you explain what didn't work?

 

[usmanhere]

i have simplified my data base. now i just want a dynamic table. i have posted a new post for that too.

i reproduce here.

suppose we have two identical tables in two different sheets.

table2 is linked with table1. how can we make the table2 dynamic, that when we insert a new row in table1, the same row is updated in table 2.

may you please advise

 

[Luke M]

I'd go with the formula I posted before:

=IF(ROWS($A$2:$A2)>(COUNTIF($A:$A,">="&Data1)-COUNTIF($A:$A,">="&Date2)),"",INDEX(A:A,SMALL(IF(($A$2:$A$100>=Date1)*($A$2:$A$100<=Date2),ROW($A$2:$A$100)),ROW($A1))))


Confirm this formula as an array, then copy to the right and down as needed.


This formula isn't looking at a specific row, so you can add/delete as needed (provided your not deleting row 2 or row 100.