ShowDetail
in [Programming]
|
From: Les Gombart on 9 Mar 2010 23:51 When data is extracted using ShowDetail, the data is always extracted to a new sheet. Is there any way that this data can be extracted to a named range?
From: Dave Peterson on 10 Mar 2010 09:24 How about letting it go to the new sheet, then copy|pasting to its correct home (and delete that new sheet???). Les Gombart wrote: > > When data is extracted using ShowDetail, the data is always extracted to a > new sheet. Is there any way that this data can be extracted to a named range? -- Dave Peterson
From: Les Gombart on 12 Mar 2010 00:11 Hi Dave... I thought about that, but the problem is that a new sheet number is created everytime you use the ShowDetail function... I have however re-thought my reasoning and it is a lot easier to use advance filter macros to find the same data from the original data Thanks anyway "Dave Peterson" wrote: > How about letting it go to the new sheet, then copy|pasting to its correct home > (and delete that new sheet???). > > Les Gombart wrote: > > > > When data is extracted using ShowDetail, the data is always extracted to a > > new sheet. Is there any way that this data can be extracted to a named range? > > -- > > Dave Peterson > . >
|
Pages: 1 Prev: LookUp Returning more than one rows Next: MS Excel VBA Pivot table link cell fetch records |