With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Tuesday, February 19, 2013
yogi_Sort Merged Data In One Sheet Based On Sorting Of Data In Another Sheet
Google Spreadsheet Post #1036
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Feb 20, 2013 user Soundfx4 said:(http://productforums.google.com/forum/?zx=1w1p4geyesws#!category-topic/docs/spreadsheets/6PI7MuIvgN4) Sorting multiple sheets with Column A Linked (Sheets 2, 3, and 4's Column A reflect sheets 1 Column A)
I found my exact same problem worded BEAUTIFULLY by another...unfortunately it was unanswered and closed. So I'm borrowing what he said, and including a picture for a visual reference. And hopefully this gets answered.
Using one worksheet, and multiple sheets, on sheet 2, 3, and 4 I have filtered Column A so that it is the same across every sheet following the Column A in sheet 1. Now, the information on Column B, C and so forth are different for each sheet. The information on Column A is set to be alphabetical. Thus, when I add a new line of data to Column A sheet 1, it appears on Column A of each sheet. But when I sort it in sheet 1, only the columns B, C, and D of sheet 1 sort in accordance, while sheet 2, 3, and 4 only Column A is sorted alphabetically but the the following columns did not sort along with it... so the subsequent information is now mismatched.
How can I make it so that Columns B, C, D and so forth of sheets 2, 3, and 4 sort in accordance keeping all the information correctly in line?
Check out sheet 1 and 2 (I've color coded the rows.) and then select all of sheet one, right click column A, Sort Range, check has header (vendor), A > Z and then click sort. Sheet 1 will sort properly, but sheet 2 will only sort Column A.
I need all of sheet 2 to sort in the same way sheet 1 did.