Waldo Posted May 26, 2020 Share Posted May 26, 2020 I have a GS spreadsheet with multiple sheets, one per year. Each sheet has a column for date, one for route, one for time (and others). I want to dynamically populate a new sheet with date and time, from each of the other sheets, where route is equal to a particular value. Is that possible? Link to comment Share on other sites More sharing options...
swarfendor437 Posted May 26, 2020 Share Posted May 26, 2020 (edited) This guide mentions 'Consolidaton' which might be what you want? Not sure - also a while since I used Concatenation in Excel - another possibility. https://hiverhq.com/blog/definitive-guide-google-sheets Edited May 26, 2020 by swarfendor437 Link to comment Share on other sites More sharing options...
Properjob Posted June 7, 2020 Share Posted June 7, 2020 If you google (IMPORTRANGE function in Google Sheets.) you should see a video as the first result which will explain how to do this. It's about 40 seconds into the video. The video I am referring to has a green and yellow background Link to comment Share on other sites More sharing options...
Pyrotequila Posted April 5, 2023 Share Posted April 5, 2023 1 hour ago, Anupama said: Hi team, I watch the your website is awesome and good information website. Anupama Today Episode Hi team, I watch the your website is awesome and good information website. Anupama Watch Online Reported Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now