Pivot-table versus crosstab queries
 

Hi,

I have data in an Excel spreadsheet. The spreadsheet
contains several tabs. Each tab is named after a Region,
and contains a list of applications that pertain to that
region.

I have been doing the following:
1. importing these tabs into an Access table,
2. adding a coumn called Region,
3. populating this column according to the name of the
tab it was taken from,
4. running a crosstab on the data using Region as
Columnheading and finally
5. exporting the resultset of the crosstab query back to
Excel

Can a crosstab query's results be achieved using features
native to Excel such as pivot tables?

Can someone suggest a more efficient way of doing the
above?

Thanks!

Regards,
Rajat

Pivot-table versus crosstab queries
 

If all the records will fit on one sheet in the workbook, you could add
a column for Region, and create a pivot table from the table.

If there are too many records for a worksheet, you could store the data
in Access, and use it as a source for the pivot table.

There's some information of PivotTables he

http://www.geocities.com/jonpeltier/...pivotstart.htm

Razor wrote:
Hi,

I have data in an Excel spreadsheet. The spreadsheet
contains several tabs. Each tab is named after a Region,
and contains a list of applications that pertain to that
region.

I have been doing the following:
1. importing these tabs into an Access table,
2. adding a coumn called Region,
3. populating this column according to the name of the
tab it was taken from,
4. running a crosstab on the data using Region as
Columnheading and finally
5. exporting the resultset of the crosstab query back to
Excel

Can a crosstab query's results be achieved using features
native to Excel such as pivot tables?

Can someone suggest a more efficient way of doing the
above?

Thanks!

Regards,
Rajat


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html