Here is a not so complicated way to gather data from diferent tables and put it into a single one. All we need is to mix a QUERY function with several IMPORTANGE functions.
Hey! thank you so much for the deepdive about this beautiful function. I am curios if it is possible crosslink 2 files between eachother in the same table. I hope I'm not confusing you too much. Basically I have 2 tables: Questions and Answers. And I just want to connect them together. But the challenge is when the row is inserted in Questions table, I am having misaligned response rows from Question table. I'm really curious about this idea since it would allow me a data exchange without oversharing the file where the Experts are answering the questions. I really appreciate your support!
hi! amazing video man. Thanks a ton. what if the columns are in different order in table 1 & 2, or if there are extra columns that are not common in one or the other sheet?
Thanks for the explanation. It only seems to work if i do a single cell. When i try to do all cells I require, it gives me the following message "Error Array result was not expanded because it would overwrite data in E2" Do you know what may be the reason?
Thank you, I have a question. If I want pull some cells from the sheet and different sheets into summary? I got a huge data contains 100 sheets and all are same in design but the content is different. I would like to summarize these sheets into one page Example: sheet one Sheet1: total of Sells, purchase, cost,transportation Sheet2:total of sells,purchase,cost,transportation How to pull some cells into summary? I want for each sheet one row. Thank you again 💓
I did exactly the same but if I start to combine the Sheets closer with "Select * where Col1>0",0) ... Google tells me that there is an "Issue while parsing" the Files. It's such a easy code... but what I'm doing wrong?? 🤔
Thank you for the lesson! I have a question..I create a model for documents with hundreds of cell intervals (ex.B2:B2) linked between 1 sheet (imput) and other 4 sheets (ouputs) and I want to use it all with different data. If a create a copy it will create a new link and it should be update for every cell. Is there any way to update the link on the sheets, maybe with a multiple selection? I can't find an answer but I think it should be possible! Thnks in advance..
Thanks alot, very informative, how can i sum the value from 2 different spreadsheet into 1 master sheet. For ex: sales of branches in different spreadsheet and sum total of sales in 1 master sheet
Mult stimate Radu !!! Am dar oarecum întâmpător de canalul tău de youtube , nu am dorit cu ardoare să învăţ excel deoarece eu sun de creo 8-9 ani doar pe linux iar acolo nu este microsoft office (adevărul că şi acolo s-ar putea folosi officeul de la microsoft) dar eu nu-l folosesc din aversitate faţă de orice de la microsoft. Dar bineânţeles există ţi open source pentru excel sub linuc de ex. free office sau mai ales libre office dar mi sunt şi altele . Adevărul că acesre softuri aşa numit deschise şi gratuite diferă de office ul de la microsoft pentru că sunt adaptate oarecum dar eu aş zice că nu este nici o problemă. Eu aş sugera dacă se poate de a face un video cu diferenţele pentru calcul tabelar dintre ele. Ştiu că se poate argumenta că nu are nici un rost pentru că eceste softuri nu sunt bune nu constitue nici o pondere in folosirea lor şi aşa mai departe dar pe de altă parte de ce să nu încurajăm oarecum prin acesta folosirea lor pentru ca lumea să nu folosescă ilicit programe plătite gratis. Mulţumrsc mult pentru înţelegere cer scuze pentru că m-am băgat unde nu-mi fierbe oala. Cu deosebite respecte şi cu mare simpatie Fekete Alexandru din Oradea.