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
Highlighted

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
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies