waitn4thewknd
New Member
- Joined
- Apr 30, 2013
- Messages
- 3
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!
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!