Sorting automatically in Excel

Hi there,

Currently, I am doing a project where I have a list of names in colum A and other columns to the right (B, C, D....) that measure different values that correspond to a certain name in A. In another sheet, I would like to build charts comparing column A and column B, column A and column C and so on... each in descending order based on for example B then A, C then A.

How do I create a link between sheets so that I can update data in Sheet 1, and it will be carried over to Sheet 2 and automatically sorted in descending order and those changes be reflected in a chart? Can this actually be done in Excel?

Right now I have simply copied over two colums, used the sort Function to sort B then A and created a chart. But every time the information in Sheet 1 changes, I have to copy it over and sort and make the chart all over again in Sheet 2. This is useless to me!

You can use a macro to automatically update the information (or update whenever you run the macro.) What are the ranges, worksheet names, etc?

Originally Posted by Rutgers_Excels

You can use a macro to automatically update the information (or update whenever you run the macro.) What are the ranges, worksheet names, etc?

Yes, I was trying to run my own macro but it only ever sorted part of what I needed.

Sheet 1 = Emissions

Column A = Plant Name, Column B = Nitrogen, Column B = Lead....goes on for many rows
Plant name has all text names, other columns have numerical values

Sheet 2 looks exactly like Sheet 1 as I have used the formula with the ! to transfer over the information so that it updates Sheet 2 if I make a change.