Hi Thanks for your video.I have data which contains medical, institutions, furniture shops, doctors and much more.And the data is in laws and it is a single sheet.I am unable to separate by its category. Can you help me how to do this.Please please.
Suggest me? I have a data in main Excel sheet , I want to separate those data according to region wise. Important think is when a enter the New data in main Excel sheet, It should be automatically separated according to region wise, Plz help me by suggesting Video.
I have a column with 65,707 values. I made changes in 15,045 rows from "z" numbers to actual numbers corresponding to values. How do I replace the "z" numbers with the changes without affecting the "z" numbers that have no corresponding actual values?The data is in two workbooks. Thank you for any help you can offer.
I have a spreadsheet for 2018 customers with a column for "comments". How do I transfer those comments to a fresh spreadsheet for 2019. The 2018 sheet has about 4,000 rows and the 2019 sheet has about 7,000 rows so I can't just copy from 2018 and paste into 2019. I need the comments in 2019 to reflect for those fields from 2018. Thanks in advance.
With the columns similar an added column that is Year with the values like 2018 and 2019 could be an option. Also Power Query is a nice alternative to the consolidated feature .... see ruclips.net/user/dough517search?view_as=subscriber&query=power+query+combine
sir I have a little problems in merge and center. when we lost merge and center how to get it back in work sheet. i.e the entire work sheet could not function it . merge and center is unable to click
+Doug H Doug, thanks so much. I figured out what happened. It didn't like the header that I choose to include (they were all different). Changed that and it worked perfectly!
I have followed your instructions and others who have the same instructions. But each time, I have entire missing columns of data from my 2nd, 3rd, and 4th columns. The header is there, but no data. And the data in the final column which is "years" is screwing up the years. All my years are 1900's and 2000's, it starts showing 3000's and 4000's years.
not sure what different data sets mean but if the columns fields don't match up across the sheets you might get some unintended results. Another option is to use Power Query. ruclips.net/video/GlMFBNQUQQ8/видео.html ruclips.net/video/NHNnnuOF8kU/видео.html
Hi Doug, Tried this feature based on your problem. In fact I tried both by creating a table for each of the similar data sheets and also selecting the cells as you have indicated in your video. However, the results do not appear. It displays with only a couple of headers and the data does not look presentable. Both sheets are exactly similar - rows and columns. Not sure what is the mistake here. Appreciate your thoughts. Thanks so much.
Check if there are any empty rows in your range. For an alternative way of doing this you can also use Power Query (if this is something that will be a recurring task). See this vid at ruclips.net/video/NHNnnuOF8kU/видео.html
Thanx Doug for your prompt response. I am using a Mac and did not find find the correct update for power query as you mentioned. Alternatively, is there a function I could use to obtain similar results. I am trying with Fn getpivotdata also. Appreciate your thoughts. Thanks
Hi, great video! Question: I have multiple tabs in a single excel workbook that I am trying to consolidate and make sense of. I was able to consolidate using your video which is great. BUT - is there a way to add more labels to the left hand column and then use it as a reverse drill down? For example - left most column would be Manager then to the right of that supervisor - and then Employee and then position and then all of the number data? I am hoping to consolidate the data and then be able to click on a manager which would then show only his/her supervisors and then if you click on a Supervisor his/her employees. All with the data going from macro to specific person.
I love how you explain that in details man you the best
Hi Stepy Voice, thanks for the kind words!
Very crisp and clear presentation.Thank you.
Hi anand meundi, glad you liked it, thanks for commenting!
this video is wonderful, it has truly help me in my office work.
Hi Edwin Ekine, thanks for the comment!
Great video. Clear, simple and to the point!!
Hi Al Jack, glad you liked it, thanks for commenting!
Thank you so much. Very useful
You're Welcome!
A very expressive way tq a lot.
Really very nice video and easy to use
impressive teaching and easy to learn.
thanks alot
Thank you sir, it was good learning video for learning consolidate tool :)
impressive teaching and easy to learn.
thanks a lot. KEEP IT UP. Buddy.
Hi Manish Panchal, thanks for the comment!
Thanks alott.. may God blesss u for ur effort and please do more education charity..
excellent and clean clear presentation
Thanks for the comment. Glad you liked!
Very nice. You explain very well
Hi Kimmie Dao, thanks for the comment!
Excellent teaching..thank you so much
Hi jozlin mary, thanks for the comment!
Good tutorial thumbs up!! Thank you
thanks a lot....!
it is really working if u have any video related excel pls update it.....
Thank you
You're Welcome!
Hi
Thanks for your video.I have data which contains medical, institutions, furniture shops, doctors and much more.And the data is in laws and it is a single sheet.I am unable to separate by its category.
Can you help me how to do this.Please please.
Sorry I don't consult, but if you present this question to folks on the mrexcel.com forum you may get some help. HTH
good one. Got what I was looking for.
Hi Manoj Kumar, glad you liked it, thanks for commenting!
Thanks a lot,got what i was looking for.
Thanks Boniface Ebineng, glad it helped!
Great video hawmie, enjoyed it alot, Keep the content coming!!:)
Thanks for the effort
Suggest me? I have a data in main Excel sheet , I want to separate those data according to region wise. Important think is when a enter the New data in main Excel sheet, It should be automatically separated according to region wise, Plz help me by suggesting Video.
Hi,
It cleared my doubts for totaling the multiple sheets. Very explanatory, Thank You for your nice works.
S PASUNGILI, DINDIGUL, SAP INFOTECH.
Hi Pasungili Subbanasari...you're welcome, glad you liked!
Amazing you help us to easy to learn
Hi A7mad Maher, thanks for the comment!
I have a column with 65,707 values. I made changes in 15,045 rows from "z" numbers to actual numbers corresponding to values. How do I replace the "z" numbers with the changes without affecting the "z" numbers that have no corresponding actual values?The data is in two workbooks. Thank you for any help you can offer.
Very helpful, thank you.
Hi teh bear, glad you liked it, thanks for commenting!
cheers dude!
Thanks xdisgreat!
Muito Obrigado.
I have a spreadsheet for 2018 customers with a column for "comments". How do I transfer those comments to a fresh spreadsheet for 2019. The 2018 sheet has about 4,000 rows and the 2019 sheet has about 7,000 rows so I can't just copy from 2018 and paste into 2019. I need the comments in 2019 to reflect for those fields from 2018. Thanks in advance.
With the columns similar an added column that is Year with the values like 2018 and 2019 could be an option. Also Power Query is a nice alternative to the consolidated feature .... see ruclips.net/user/dough517search?view_as=subscriber&query=power+query+combine
Detailed explanation !!!
Thanks MS Excel Simplified!
very important video
Hi Ranush Malshika, thanks for the comment!
Nice video and teaching
it really helped me a lot :)
sir I have a little problems in merge and center. when we lost merge and center how to get it back in work sheet. i.e the entire work sheet could not function it . merge and center is unable to click
El-em-El Taitom, that is very interesting...thanks for letting me know.
Doug, I did exactly what you taught......I keep getting an error message "Data not consolidated". What am I doing wrong?
+Doug H Doug, thanks so much. I figured out what happened. It didn't like the header that I choose to include (they were all different). Changed that and it worked perfectly!
Thank you!
You're Welcome!
It is really helpful.
could you please create a video showing VLOOKUP function with multiple application?
I have followed your instructions and others who have the same instructions. But each time, I have entire missing columns of data from my 2nd, 3rd, and 4th columns. The header is there, but no data. And the data in the final column which is "years" is screwing up the years. All my years are 1900's and 2000's, it starts showing 3000's and 4000's years.
Sorry, don’t understand the comment/ question...
Very good! Thanks
Hi Mohamed Barry...you're welcome, glad you liked!
Hi Doug H, do you know how to do this in Numbers? It does not have the tools like Excel
gosh...don't know the Mac equivalent of this... sorry :-(
very very teachig! great!
Thanks Maria João Vieira!
Hi Doug.. just one question will this also able to take care of rows. if few number of rows are different in data sets.
not sure what different data sets mean but if the columns fields don't match up across the sheets you might get some unintended results. Another option is to use Power Query.
ruclips.net/video/GlMFBNQUQQ8/видео.html
ruclips.net/video/NHNnnuOF8kU/видео.html
Thanks mate.
You're Welcome!
Hi Doug! I would like to know if it works in case if the column names are different?
The final output will be in different columns
Hi Doug, Tried this feature based on your problem. In fact I tried both by creating a table for each of the similar data sheets and also selecting the cells as you have indicated in your video. However, the results do not appear. It displays with only a couple of headers and the data does not look presentable. Both sheets are exactly similar - rows and columns. Not sure what is the mistake here. Appreciate your thoughts. Thanks so much.
Check if there are any empty rows in your range. For an alternative way of doing this you can also use Power Query (if this is something that will be a recurring task). See this vid at ruclips.net/video/NHNnnuOF8kU/видео.html
Thanx Doug for your prompt response. I am using a Mac and did not find find the correct update for power query as you mentioned. Alternatively, is there a function I could use to obtain similar results. I am trying with Fn getpivotdata also.
Appreciate your thoughts.
Thanks
Great teaching video, you made this topic easy to follow along!
Hi daveg655, thanks for the comment!
You forgot to add Asia (2) in your second example, but I loved the tutorial, thank you so much!
:-P Good catch...i had clicked OK with first clicking Add...but I hope most people got the gist of the steps!
I'm starting to handle more stacked datasets at work now and this really helped me pull everything together before running my pivots. Good stuff!
Thanku so much sir
You're Welcome!
Hi, great video! Question: I have multiple tabs in a single excel workbook that I am trying to consolidate and make sense of. I was able to consolidate using your video which is great. BUT - is there a way to add more labels to the left hand column and then use it as a reverse drill down? For example - left most column would be Manager then to the right of that supervisor - and then Employee and then position and then all of the number data? I am hoping to consolidate the data and then be able to click on a manager which would then show only his/her supervisors and then if you click on a Supervisor his/her employees. All with the data going from macro to specific person.
Hi Lance Brissette, thanks for the comment!
thank you vary much
you're welcome!
thank you i will watch your all lessons
nice
Exelent
Thx!
Super :)
Thanks!
নাইস ভিডিও
ধন্যবাদ
GUD
Thanks Satyavir Singh!
البدرى
nice video but you forgot Africa
yes i did....so i'll try not to neglect it in the future as it IS one of the largest continents!
Thanks, well explained.
You're Welcome!