Forum Home
Press F1
 
Thread ID: 4923 2000-07-10 00:46:00 EXCEL data subset extraction formula Guest (0) Press F1
Post ID Timestamp Content User
5415 2000-07-10 00:46:00 Is there a formula in Excel (2000)which allows me to automatically extract a data subset and paste it into a new sheet?

I'm currently using Autofilter with cut and paste, which is rather tedious.

I'm a teacher and I'm trying to set up a number of 'class sheets' from a 'master sheet' which contains all the names, subjects and form classes.
Guest (0)
1