copy sheet

[auto]

hi, everyone!
i wonder if & how i can make that when i have a sheet let say MyDatabase where all my stuff is in there, then i want that the same stuff should be in another sheet (tab) named Filter1, where i want to make a filter on the data, then another copy named filter2 and place there a filter as well, and here is my question, how can i make that when i change info from sheet MyDatabase should it be applied to all sheets & their filters automatically?
any VBA for that?

 

[patel45]

instead of copyng the sheet MyDatabase to others you can prepare others sheets with formulas i.e
in A1 of sheet2 put formula =MyDatabase!A1 and so on

 

[auto]

thank you very much for your reply, but the problem with that is, when a record (row) in mydatabase is getting deleted then, all others gets a N/A, & also when a row is being added with info in mydatabase it will not appear in others, unless i do manuely again the formula on that row,
in addition please note, i have 2000+ rows, & 12 columns, so i look for the most easiest way to do it.