Reordering data duplicated across two worksheets?

T

Tristram_ZX81

New Member
Joined
Jun 22, 2021
Messages
48
Office Version
  1. 365
Platform
  1. Windows
I've put a basic formula on Sheet2's A and B columns so they show exactly the same data as columns A and B in Sheet1. But Sheet 2 now won't let me sort the same data from smallest to largest; it will only show the same order sequence as Sheet1. Any idea how to get round this?
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Sort by date Sort by votes
What formula are you using to display the data from sheet1?
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question Question
Multi column data sorting problem
Replies
8
Views
335
Peter_SSs
Peter_SSs
S
  • Solved
Delete rows before a certain time
2 3
Replies
26
Views
900
Joe4
Joe4
R
  • Question Question
Data Validation with Keyword search
Replies
9
Views
139
Cubist
Cubist
N
  • Question Question
Index Match after sorting
Replies
1
Views
653
Eric W
Eric W
J
  • Question Question
Pulling Data From ~300 Individual Sheets Onto a Master Sheet
Replies
1
Views
253
ranman256
ranman256

Forum statistics

Threads
1,224,820
Messages
6,181,161
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top