Forum Discussion

sigrid.riindependence's avatar
sigrid.riindependence
Copper Contributor
Nov 01, 2018

Excel formula help

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? 

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

Resources