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
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies