Home

Excel formula help

sigrid.riindependence
Occasional Visitor

I have a workbook that consist of 30 sheets. The last sheet is a summary of the date on the previous 29 sheets. 

How do I set up a formula that will automatically transfer data from sheets 1-29 to sheet 30 as I enter ea day? 

1 Reply

It very depends on how your data is structured and which summary you'd like to have. As variant that could be Power Query.

Related Conversations
Creating A Sublist
zjohnson in Excel on
5 Replies
Excel Forumla to exclude empty cells.
ulken2019 in Excel on
6 Replies
Consolidating data from multiple worksheets
Machala Sentance in Excel on
3 Replies
Merge Cells with Different Data Types
CaffeineKing in Excel on
2 Replies
Need FORMULA help please!!
marislav in Excel on
4 Replies
Need help with concatenate formula
Dave Cunningham in Excel on
2 Replies