This Will Enable The Pivot Table Wizard, As Shown Below.

Click a blank cell (that is not part of a pivottable) in the workbook. On step 2a page of the wizard, click create a single. The steps for creating a pivot table from multiple worksheets (both in the same file) are:

In The List, Select Pivottable And Pivotchart Wizard, Click Add, And Then Click Ok.

Now, select the third option that reads as multiple consolidation ranges and choose the pivot table option from the available options. Select the second option that reads as i will create the. Under choose commands from, select all commands.

Suppose The Workbook With The Two Worksheets (Jan And Feb) Is Named Monthly Data.xls And Is Saved On The Desktop.

Now, try pressing the letter 'p' on the keypad. On step 1 page of the wizard, click multiple consolidation ranges, and then click next. In the next step, you will find two options.