Display all worksheets in a sheet?

[Horby]

Hi,

Can I view all the worksheets in a sheet?

Display with some of the data of every sheet?

Example image

 

[mole999]

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]

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]

sorry, i responded to your original question, nothing there about automating the builds. I can't assit

 

[Horby]

See this:
Create links to all sheets in a workbook | Get Digital Help - Microsoft Excel resource

I want the same, but with the addition of other data such as the total of the first column of each page. And other data.

 

[Oeldere]

Why not use a macro tot get all data on sheet.

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

 

[Horby]

Why not use a macro tot get all data on sheet.

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

How?

 

[Oeldere]

How to use a macro?

How to use a filter?

How to use a pivot table?

You question is not clear.

 

[Horby]

How to use a macro?

How to use a filter?

How to use a pivot table?

You question is not clear.

Excuse me, I mean How do I use a macro

 

[Oeldere]

if you add an excel file, without confidential information on this free dutch site, I will make it for you

and post it back on the same site.

Gratis bestanden delen en uploaden via Mijn Bestand!