Creating another view of the same data without copy-paste

Y

yashgt

New Member
Joined
Jul 9, 2018
Messages
8
Office Version
  1. 2013
Platform
  1. Windows
In Sheet 1 I have columns:
Roll Num
Name
Marks

In Sheet 2, I need the same details to appear, but with the records in descending order of Marks.

In future, when more records are added in Sheet 1 or any records are modified or deleted, I want the table in Sheet 2 to be automatically updated.

How can this be done?
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
You must log in or register to reply here.

Similar threads

C
  • Solved
Recording a Macro that Copies & Pastes into Other Sheets
Replies
1
Views
306
AlanY
A
C
  • Question
VBA copy paste currentRegion historically to another worksheet
Replies
5
Views
221
Alex Blakenburg
A
T
  • Question
Viewing data rows from another worksheet in a portal
Replies
1
Views
148
kevin9999
K
I
  • Question
Move multiple rows from one table to another using conditional trigger
Replies
2
Views
485
ItsNursinTime
I
R
  • Question
2 column lookup formula to reference new data
Replies
1
Views
183
awoohaw
awoohaw

Forum statistics

Threads
1,215,424
Messages
6,124,817
Members
449,190
Latest member
rscraig11

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