Display all worksheets in a sheet?

Horby

New Member
Joined
Jun 13, 2014
Messages
22
Hi,

Can I view all the worksheets in a sheet?

Display with some of the data of every sheet?

Example image
delete.png
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
you could bring the data from each other sheet by this sort of formula =Sheet2!D25, can't think of an easy way

just select the cell where you want it to appear, enter = then navigate to the data you want displayed, select and enter. Then drag to fill the range you want
 

Horby

New Member
Joined
Jun 13, 2014
Messages
22
you could bring the data from each other sheet by this sort of formula =Sheet2!D25, can't think of an easy way

just select the cell where you want it to appear, enter = then navigate to the data you want displayed, select and enter. Then drag to fill the range you want

This is what I do now.

I want to be done automatically.

Because I'm doing a new page for each new customer.
 

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
sorry, i responded to your original question, nothing there about automating the builds. I can't assit
 

Oeldere

Well-known Member
Joined
Dec 29, 2011
Messages
2,213
Why not use a macro tot get all data on sheet.

Then you can use filter (or pivot table) for analyzing.
 

Oeldere

Well-known Member
Joined
Dec 29, 2011
Messages
2,213
How to use a macro?

How to use a filter?

How to use a pivot table?

You question is not clear.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,472
Messages
5,636,516
Members
416,920
Latest member
Riskyplan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top