Is it possible to autofill and sort between worksheets?

[waitn4thewknd]

Ok, I hope I explain this properly.

I have a workbook with 3-4 worksheets. On Sheet 2 and 3, column A and B are the same on both sheets. When I enter something into Column A on Sheet 2, I want it to also appear on Column A on Sheet 3. I know you can do that by ='Sheet name'!A2 etc. Is there an easier way?

Next problem. If I am on sheet 2, and I sort either column A or B, how can I get it to do the same on sheet 3 and keep the rest of the information in that row with it? An example would be:

on sheet 2
Column A Column B
AZ45 501A
AZ46 508C
AZ47 501A

and on sheet 3
Column A Column B Column C Column D Column E...
AZ45 501A Karen 4 MC
AZ46 508C Ralph 2 GR
AZ47 501A Marcy 1 MC


So if I am entering info into Column A and B on sheet 2, it goes over to sheet 3, and if I sort Column B on sheet 2, it NEEDS to sort Column B on sheet 3 and keep the row of info all together. (I think it falls under "Expand section")

Is this even possible? And if it is, can you please tell me how to do that?

Thank you!

 

[Andrew Poulsom]

Not an answer to your questions, but why do you need to duplicate your data?

 

[waitn4thewknd]

Part of tracking information, each sheet has other information that goes with the 2 tags, and those 2 tags are what we sort by often.

 

[JASONRUBALCAVA]

the ='Sheet name'!A2 is the easiest way..you only need to make the formula once. then copy it down.. as far a sorting. yes you can do both sheets or multiple sheets a the same time as long as the columns are made with the same name..(you said that both A and B are named the same).. you just hold down the shift key high light the sheet/s you want to sort then on the sheet.. highlight the ONE cell and not the whole column.. in whatever column you want right click sort and sort either AtoZ or ZtoA .. this will sort all the highlighted sheets

if this isn't what your looking for. maybe paste on here what you already have done.. so we can see what you need.. good luck

 

[waitn4thewknd]

Ok, I did that and it sort of works. Yes, it does allow me to sort on both sheets, and that is what I want, however... when it sorts on sheet 3, none of the other information in the other columns that are on that row, go with that value, and I need them to. Am I just asking for too much?

 

[JASONRUBALCAVA]

is should sort as long as the cells are side by side.. there can't be any blank cells in between... if there is you must first make it into a active table.. so that way if sort it will take the cells that are empty as well. it's easy to make into a table.. go onto the sheet you want. click on your data.. then make sure your on the insert ribbon. then click on insert and click on table.. highlight the entire table that you want.. make sure you the "my table has headers" then click ok.. your data will then turn colors.. and now you can sort even the blank cells next to it..