Hi gang.
Is it possible to have a table of raw data on 'sheet1', then 'sheet2', 'sheet3', and 'sheet4' all show the same table of data, but sorted based on a different column? So that if I edit 'sheet1', then all the other sheets are updated automatically?
Thanks chaps, you're always very helpful when I get a problem like this!
Hi
Yes it is possible and straightforward to set up. If you post a copy of your worksheet on here and list the criteria for which each sheet is to be sorted, I will make it up for you.
Doug
Thanks Doug
I'd like sheet 2 to show sheet1's data but sorted based on column G
Then
I'd also like sheet 3 to show sheet1's data but sorted based on column E
But it's important that as I mess about with sheet1, sheet2 and sheet3 update without me!
Thanks in advance Doug, I'd be very grateful if you got this workin'! If you're gonna be doing anything other than formulas, could you give me the gist of how you solve it? Thanks again!
If you record a macro when on sheet 2 to sort the data to the format you want then copy the code in to that worksheet with the top line to run the code when the sheet is activated the sheet will be resorted each time you return to view it.
If you do not need different sheets it would work better using just one. Insert a shape at the top of each column you want to sort by to use as a button. Record a macro to sort by the first column and assign the macro to the button. Do this for all the columns you want to sort by. Now when you press the button the data will sort by which ever button you choose without have to change pages.
Last edited by BarryTSL; 02-02-2011 at 03:33 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks