Prev: How to translate a getpivotdata formula into a cell reference
Next: Autofilter Problem
From: Hammer on 11 Feb 2010 05:18
I would like to create a list in sheet 2 from data in sheet 1 but when I
click create list and go to select the range it will not let me click on the
tab for sheet 1 to select the required data.

Could somebody point me in the right direction please?
From: Dave Peterson on 11 Feb 2010 08:12
A list is a feature in xl2003 that allows you to edit that "table" easier. It
doesn't allow you to create a separate table in a different worksheet.

I like to think of it as an enhanced autofilter range.

Maybe you could use the list (or autofilter) on the original sheet and then show
the rows you want and copy those visible rows to the second sheet.

Hammer wrote:
>
> I would like to create a list in sheet 2 from data in sheet 1 but when I
> click create list and go to select the range it will not let me click on the
> tab for sheet 1 to select the required data.
>
> Could somebody point me in the right direction please?

--

Dave Peterson
 | 
Pages: 1
Prev: How to translate a getpivotdata formula into a cell reference
Next: Autofilter Problem