Excel question on modelling - Pace and Cap

The Pook · 01-29-2021, 09:14 AM

Wow. I’m surprised that a modern spreadsheet like Excel would not automatically read filtered data. Without cutting, pasting, moving etc.

I have used an ancient spreadsheet called Lotus 123 on Mac for years, and you set that up to extract filtered data to a new range where you can work on it. Not RDSS work though because it extracts only to Excel.

So I thought I would try Excel. Thanks for the tips Bill and Ted. I will see what I can do. I would think I could copy filtered data to another master template, or another sheet and read it that way.

Bill I am experimenting with Parx and GP for now.

Pook

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adjustments Question	Ted Craven	RDSS2 / FAQ's	3	06-29-2014 04:22 PM
RDSS2 - Adjusted Screen Question	Ted Craven	RDSS2 / FAQ's	4	02-16-2013 07:45 PM
A Question Posed 1986	Bob Cochran	General Discussion	12	08-30-2009 08:29 PM
Release Notes - Version 0.98.8	Ted Craven	RDSS Info, Reference	3	07-28-2009 09:35 PM
Question Concerning "About" Distances...	lueylump	RDSS	2	05-13-2009 05:45 PM

01-29-2021, 09:14 AM	#11
The Pook Grade 1 Join Date: Feb 2014 Location: Loretto, Ontario Canada Posts: 2,847	Wow. I’m surprised that a modern spreadsheet like Excel would not automatically read filtered data. Without cutting, pasting, moving etc. I have used an ancient spreadsheet called Lotus 123 on Mac for years, and you set that up to extract filtered data to a new range where you can work on it. Not RDSS work though because it extracts only to Excel. So I thought I would try Excel. Thanks for the tips Bill and Ted. I will see what I can do. I would think I could copy filtered data to another master template, or another sheet and read it that way. Bill I am experimenting with Parx and GP for now. Pook