ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can a CrossTab pull from 2 different Tables? (https://www.excelbanter.com/excel-discussion-misc-queries/151641-can-crosstab-pull-2-different-tables.html)

Dave

Can a CrossTab pull from 2 different Tables?
 
I have 2 separate sheets (tables of information) and I want to combine them
into a single roll up. There are IDs to tie the information together.

Is there a way to combine the 2 into a single roll-up?

If not is there a suggested application to do this in?

One more piece, I would like to use the double-click detail to allow the
user to validate the data.

Can this be done?

Dave



All times are GMT +1. The time now is 11:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com