Sort and filter

Hello everybody!!!

I have a spreadsheet with two sheets. The second sheet displays information from a number of columns in the first sheet using a simple formula. The first sheet has blank rows at the bottom so that it can be added to BUT, because the information is required to be displayed alphabetically, I've included a simple sort macro.

Now it gets complicated.

The second sheet is only required to show SOME entries from the first based on certain criteria [from the first] and I've included a simple filter macro. However, the second sheet will then have additional information, NOT required on the first, entered BUT, when the first sheet is sorted, the information already added to the second will then be in the wrong place.

Attached is a simple spreadsheet hopefully showing the problem.

Sheet1 lists (Columns B, C and D) the names, addresses and marital statuses of 16 people, sorted alphabetically. Sheet2 shows the same information using a simple formula AND ALSO the name of the spouse which isn't required to be shown on Sheet1. Clicking Button 2 on Sheet2 filters Sheet2 (Column D) to show only "Deb", "Mike" and "Vicky" and there respective spouses "John", "Jenny" and "Scott". However, if I then add "Bill", "1 The Crescent" and "No" on Row 20 on Sheet1 and then sort it alphabetically using Button 1, Sheet2 now shows "Colin", "Margaret" and "Tony" against the same spouses as shown previously. And then, when I filter Sheet2 using Button 2, "Deb", "Mike" and "Vicky" are shown again but their spouses aren't because they're now listed alongside "Colin", "Margaret" and "Tony".

What I need, if it's possible, if for Column E (and all other Columns on Sheet2) to be sorted in conjunction which Sheet1.

Thanks in advance.

Ed

Hi Ed,

I suggest you attach a 'real' file not some text you expect everyone to copy and paste and then let us imagine what you have.
A simple sample file with dummy data with what you have and what you want will suffice and make things easier to understand.

Just to see if I got you right.
In principle both worksheets are identical except that data can only be added in Sheet1 and Sheet2 is used to display the data but filtered and always in alphabetical order?
So along comes you funny boss and he/she enters new data but when sorting it will pop-up somewhere in an area already sorted but not (yet) visible in Sheet2 and you want the sheet to refresh, sort correctly and display the filtered values?
It sounds more like somebody wants you off the streets

Okay let me kwno if that's the main idea and I think I might have a simple solution (I hope)

It is a tough one, but it's good to be able to convince people that sometimes reconsidering is an option.
I had something but it messed it all up, so, thanks for letting us know.
If I do get it to work I'll post it to you anyway, who knows you'll get a promotion