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 MI     www.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.

The problem:
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?

Thank you!
Attachments (1)
163 KB   View   Download
Here you go!

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.

Is it possible at all?  Thanks!
here we go