ExcelBanter - Data Consolidation - Wild Cards not able to use

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Data Consolidation - Wild Cards not able to use (https://www.excelbanter.com/excel-discussion-misc-queries/158595-data-consolidation-wild-cards-not-able-use.html)

Shrikant

Data Consolidation - Wild Cards not able to use

I am using Excel 2003. I am not able to use wild cards in naming data ranges
in the data consolidation dialog box. It gives the response as 'Wrong
Reference'.
How to use the wild cards ? and *.

All times are GMT +1. The time now is 02:28 AM.