Update data automatically to other worksheet?

Current version: excel 2010

Hi to all,

Currently I am trying to enhance my excel files and do update from main worksheet to duplicated worksheet. I have a main worksheet and a duplicated worksheet. The difference between the 2 worksheet are:
•Main worksheet has all data (at least 35 columns), while duplicated worksheet only has a few data as not all are required (18).
•Main worksheet has no filter, duplicated worksheet has filter at a column.


The main question here is how should/what should I do so that whatever updated in the main worksheet could also automatically updated to the duplicated worksheet with any use of button. I don't want to use button for update as my worksheet has many rows and columns. I hope there will be expert to help me in this problem.

P.S: I may not be able to provide any SS as my excel files may contain confidentially information.

Thanks in advance!

Originally Posted by alansidman

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I've did it! I tried again by using the '=' formula. It's just that I have to drag across columns and rows in different set and not drag all in one go. Thanks anyway!