Advanced Filter

[AlexJH]

I need a spreadsheet that has one master sheet, with all the data stored.

I then need another sheet which has several tables on, these tables need to be automatically updated using the master sheet, the data in the rows from the master sheet needs to be copied to different tables on a seperate sheet according to the value in one of the cells in the row, for example:

If a cell has between £10,000 and £20,000 the entire row is copied to sheet2 and placed in the £0-20,000 table, but it also needs to be left on the master sheet.

[aravindhan_31]

Hi,

Please send the sample workbook

Arvind

[rwgrietveld]

I've made something that I think is what you need. I have made more than just one range.

Please Login or Register  to view this content.

[AlexJH]

Heres an example.

I've tried that code, but was not successful, couldn't figure out what i was doing wrong?

[rwgrietveld]

Than this

Please Login or Register  to view this content.