Auto populate from 6 different sheets - Excel 365 and Google Sheets

N0t Y0urs

Board Regular
Joined
May 1, 2022
Messages
93
Office Version
  1. 365
  2. 2021
  3. 2019
  4. 2016
  5. 2013
Platform
  1. MacOS
  2. Mobile
  3. Web
Hi, me again as you guys are really helpful.

My next question that I can't seem to figure out is there a way to auto populate a sheet every time you add a new entry to a different sheet.

This is the scenario:
5 sheets that I enter information into based on their filters. These sheets will have a minimum of 5 rows of data with currently the largest one being 103 rows.

I don't care about the order in which they report but can I have the summary sheet auto populate from the other 5 sheets? Or do I use the summary sheet as a "dashboard" to manipulate the data into more manageable insights?

Typing it out like this I think that is my solution however I would like to hear other opinions and if indeed it is possible to pull form 5 different areas into one automatically
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.
I have not found a way to do this at all so MY SOLUTION is to actually not auto populate but rather use a dashboard scenario to report the data in the summary sheet
 
Upvote 0

Forum statistics

Threads
1,213,534
Messages
6,114,186
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top