Tips ! การรวม Data ใน Excel แต่ละ Sheet ด้วย VBA

รวมงานแต่ละ sheet ใน Excel ทำอย่างไร ? คือ การเอา Sheet ใน Excel มารวมอยู่ไว้ในหน้าแรก โดยการใช้ VBA สำหรับสายงาน Online marketing หรือ สายงานที่ต้องเกี่ยวข้องกับการใช้ Data เอามาวิเคราะห์ งานการรวบรวม Data อาจจะเป็นอีกงานนึงที่บางครั้งจะเกี่ยวข้องกับเรา เช่น ต้องการเอารายชื่อตัวแทนจำหน่ายที่ขายสินค้าให้กับเรา ขึ้น บน Website แล้วถ้าระบบเดิมออกแบบมาไม่ดีพอจะทำอย่างไร ?

ตัวอย่างจริง คือ เราต้องส่ง Form ใน Excel ที่ประกอบไปด้วย รายชื่อตัวแทนจำหน่ายที่จะต้องกรอกข้อมูล

  1. ชื่อร้านค้า /บริษัท / หรือ นิติบุคคลที่ หรือสาขา เช่น TG Fone (สาขาอะไร)
  2. ที่ตั้ง เขต อำเภอ จังหวัด รหัสไปรษณีย์
  3. เบอร์ติดต่อ
  4. บุคคลที่ติดต่อ
  5. เพิ่มเติมเช่น Website

เมื่อได้รายชื่อตัวแทนจำหน่ายมาแล้ว ทาง Sales จะแยกแต่ละ Sheet มาให้เลย


Code VBA ที่สำหรับการรวม Files

Code VBA
Code VBA

ติดตามสาระดีๆ จากพี่อ้วน รวมถึงรับดูแล Social Network บริหารจัดการ Content ได้ที่
https://www.idea2mobile.com
Call : 0863863896 , 0866188111
Line : e21eqg
email address : anantachai@idea2mobile.com

[gs-fb-comments]

By admin

ชื่อเล่น พี่อ้วน ล้มลุกคลุกคลาน ทางด้าน Digital Online ทั้งงานหน้าบ้านและหลังบ้านมาหลายปี เริ่มตั้งแต่ตั้งไข่ กับ Taradsolution เลยมาจนธุรกิจรถเช่าจนทำ SEO ติดอันดับ 1 ด้วย Keywod เช่ารถยนต์ เรื่อยมาจนถึงธุรกิจนำเข้าสมาร์ทโฟน Wiko สร้าง Brand และ ยอดขายมาเป็นอันดับ 6 ของประเทศไทย ในระยะเวลา 3 ปี ตอนนี้เปิดรับงานวิเคราะห์หา Insight Data โดยการใช้ Social Listening | Admin Page | Servey ออนไลน์ รายละเอียดเพิ่มเติมใน www.idea2mobile.com ติดต่อได้ที่ 0863863896

188 thoughts on “Tips ! การรวม Data ใน Excel แต่ละ Sheet ด้วย VBA”
  1. Do you mind if I quote a couple of your posts as long as I provide credit and sources back to your webpage? My website is in the very same area of interest as yours and my visitors would definitely benefit from a lot of the information you present here. Please let me know if this alright with you. Appreciate it!

  2. Hi there it’s me, I am also visiting this website daily, this web site is actually pleasant and the people are in fact sharing good thoughts.

  3. Please let me know if you’re looking for a author for your site. You have some really great posts and I believe I would be a good asset. If you ever want to take some of the load off, I’d absolutely love to write some material for your blog in exchange for a link back to mine. Please send me an e-mail if interested. Kudos!

  4. Hi! I’m at work browsing your blog from my new iphone 3gs! Just wanted to say I love reading your blog and look forward to all your posts! Keep up the fantastic work!

  5. hey there and thank you for your information I’ve definitely picked up anything new from right here. I did however expertise a few technical issues using this web site, since I experienced to reload the web site a lot of times previous to I could get it to load properly. I had been wondering if your hosting is OK? Not that I am complaining, but sluggish loading instances times will often affect your placement in google and can damage your quality score if advertising and marketing with Adwords. Anyway I’m adding this RSS to my e-mail and can look out for a lot more of your respective interesting content. Make sure you update this again soon.

  6. I don’t even know how I ended up here, but I thought this post was good. I don’t know who you are but definitely you are going to a famous blogger if you are not already 😉 Cheers!

  7. Hey fantastic blog! Does running a blog similar to this take a lot of work? I have very little knowledge of programming but I was hoping to start my own blog soon. Anyway, if you have any suggestions or tips for new blog owners please share. I know this is off topic nevertheless I just had to ask. Thanks!

  8. An impressive share! I have just forwarded this onto a friend who was doing a little research on this. And he in fact bought me lunch simply because I found it for him… lol. So let me reword this…. Thank YOU for the meal!! But yeah, thanx for spending the time to discuss this matter here on your internet site.

  9. I am curious to find out what blog system you are utilizing? I’m experiencing some minor security problems with my latest website and I would like to find something more safeguarded. Do you have any suggestions?

  10. Hi, i think that i saw you visited my blog so i came to return the favor.I am trying to find things to improve my website!I suppose its ok to use some of your ideas!!

  11. Hi there! I just would like to give you a huge thumbs up for the great info you have here on this post. I will be coming back to your blog for more soon.

  12. Have you ever thought about publishing an e-book or guest authoring on other websites? I have a blog based upon on the same subjects you discuss and would really like to have you share some stories/information. I know my viewers would value your work. If you are even remotely interested, feel free to send me an e-mail.

  13. It is perfect time to make a few plans for the future and it is time to be happy. I have read this publish and if I may I wish to suggest you few fascinating things or suggestions. Perhaps you could write next articles referring to this article. I want to read more things approximately it!

  14. I’m gone to inform my little brother, that he should also pay a visit this webpage on regular basis to get updated from most up-to-date reports.

  15. wonderful publish, very informative. I’m wondering why the other experts of this sector do not understand this. You should continue your writing. I am sure, you have a huge readers’ base already!

  16. What i do not realize is in reality how you’re now not really a lot more smartly-favored than you may be right now. You are so intelligent. You recognize therefore significantly on the subject of this matter, produced me in my opinion believe it from numerous various angles. Its like men and women aren’t fascinated unless it’s something to accomplish with Lady gaga! Your own stuffs excellent. All the time deal with it up!

  17. If some one needs expert view regarding blogging and site-building after that i advise him/her to go to see this website, Keep up the pleasant job.

  18. First off I want to say wonderful blog! I had a quick question that I’d like to ask if you don’t mind. I was curious to know how you center yourself and clear your mind before writing. I have had a tough time clearing my mind in getting my thoughts out. I do enjoy writing but it just seems like the first 10 to 15 minutes are usually wasted just trying to figure out how to begin. Any suggestions or tips? Kudos!

  19. Hey there! Do you know if they make any plugins to help with SEO? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good gains. If you know of any please share. Thank you!

  20. What i do not realize is in fact how you’re not really a lot more well-appreciated than you may be right now. You are so intelligent. You recognize therefore significantly with regards to this matter, produced me personally believe it from so many various angles. Its like men and women aren’t fascinated unless it’s something to accomplish with Woman gaga! Your personal stuffs nice. Always maintain it up!

  21. Thanks for one’s marvelous posting! I quite enjoyed reading it, you could be a great author. I will always bookmark your blog and will often come back in the foreseeable future. I want to encourage one to continue your great job, have a nice day!

  22. We are a gaggle of volunteers and starting a new scheme in our community. Your web site provided us with helpful information to work on. You have performed an impressive task and our whole group can be grateful to you.

  23. I have been surfing online more than 3 hours today, yet I never found any interesting article like yours. It’s pretty worth enough for me. In my opinion, if all webmasters and bloggers made good content as you did, the internet will be much more useful than ever before.

  24. Thank you, I have recently been searching for information approximately this topic for a while and yours is the best I have found out so far. However, what concerning the conclusion? Are you positive concerning the source?

  25. Hello just wanted to give you a quick heads up. The text in your content seem to be running off the screen in Internet explorer. I’m not sure if this is a format issue or something to do with web browser compatibility but I thought I’d post to let you know. The layout look great though! Hope you get the problem solved soon. Many thanks

  26. I believe what you postedwrotesaidbelieve what you postedtypedthink what you postedtypedbelieve what you postedtypedWhat you postedtypedsaid was very logicala bunch of sense. But, what about this?think about this, what if you were to write a killer headlinetitle?content?typed a catchier title? I ain’t saying your content isn’t good.ain’t saying your content isn’t gooddon’t want to tell you how to run your blog, but what if you added a titleheadlinetitle that grabbed people’s attention?maybe get a person’s attention?want more? I mean %BLOG_TITLE% is a little vanilla. You could look at Yahoo’s home page and see how they createwrite news headlines to get viewers to click. You might add a video or a related pic or two to get readers interested about what you’ve written. Just my opinion, it could bring your postsblog a little livelier.

  27. Ищете профессионалов для устройства стяжки пола в Москве? Обратитесь к нам на сайт styazhka-pola24.ru! Мы предлагаем услуги по залитию стяжки пола любой сложности и площади, а также гарантируем быстрое и качественное выполнение работ.

  28. With havin so much written content do you ever run into any problems of plagorism or copyright violation? My website has a lot of exclusive content I’ve either authored myself or outsourced but it looks like a lot of it is popping it up all over the web without my agreement. Do you know any solutions to help reduce content from being ripped off? I’d certainly appreciate it.

  29. Im not that much of a online reader to be honest but your blogs really nice, keep it up! I’ll go ahead and bookmark your site to come back down the road. All the best

  30. Superb blog! Do you have any suggestions for aspiring writers? I’m planning to start my own site soon but I’m a little lost on everything. Would you propose starting with a free platform like WordPress or go for a paid option? There are so many choices out there that I’m totally confused .. Any recommendations? Many thanks!

  31. Хотите лучшего для своего дома? Механизированная штукатурка стен с mehanizirovannaya-shtukaturka-moscow.ru – это то, что вам нужно.

  32. Hi there! I know this is somewhat off topic but I was wondering which blog platform are you using for this site? I’m getting tired of WordPress because I’ve had issues with hackers and I’m looking at options for another platform. I would be great if you could point me in the direction of a good platform.

  33. This design is steller! You most certainly know how to keep a reader entertained. Between your wit and your videos, I was almost moved to start my own blog (well, almost…HaHa!) Great job. I really enjoyed what you had to say, and more than that, how you presented it. Too cool!

  34. With havin so much content and articles do you ever run into any problems of plagorism or copyright violation? My site has a lot of exclusive content I’ve either created myself or outsourced but it looks like a lot of it is popping it up all over the web without my agreement. Do you know any methods to help protect against content from being ripped off? I’d genuinely appreciate it.

  35. Pretty component of content. I simply stumbled upon your web site and in accession capital to claim that I acquire in fact enjoyed account your blog posts. Any way I’ll be subscribing in your augment or even I achievement you get entry to consistently fast.

  36. This design is spectacular! You certainly know how to keep a reader entertained. Between your wit and your videos, I was almost moved to start my own blog (well, almost…HaHa!) Wonderful job. I really enjoyed what you had to say, and more than that, how you presented it. Too cool!

  37. Hello very nice website!! Guy .. Beautiful .. Amazing .. I will bookmark your web site and take the feeds also? I am satisfied to find so many useful information here in the publish, we’d like develop more strategies in this regard, thank you for sharing. . . . . .

  38. Your style is really unique compared to other people I have read stuff from. Thanks for posting when you have the opportunity, Guess I will just bookmark this page.

  39. Hey there just wanted to give you a quick heads up. The text in your post seem to be running off the screen in Safari. I’m not sure if this is a format issue or something to do with web browser compatibility but I thought I’d post to let you know. The style and design look great though! Hope you get the problem resolved soon. Cheers

  40. Присоединяйтесь к увлекательной игре Лаки Джет на деньги через 1win и позвольте азарту наполнить ваш день новыми эмоциями!

  41. whoah this blog is fantastic i really like reading your articles. Stay up the good work! You realize, many individuals are hunting around for this info, you can help them greatly.

  42. obviously like your web-site however you need to check the spelling on quite a few of your posts. A number of them are rife with spelling problems and I find it very bothersome to tell the truth however I will certainly come back again.

  43. I’m not sure why but this web site is loading extremely slow for me. Is anyone else having this issue or is it a problem on my end? I’ll check back later and see if the problem still exists.

  44. Today, I went to the beach with my kids. I found a sea shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She put the shell to her ear and screamed. There was a hermit crab inside and it pinched her ear. She never wants to go back! LoL I know this is entirely off topic but I had to tell someone!

  45. Tremendous things here. I’m very glad to see your article. Thank you so much and I’m taking a look forward to touch you. Will you please drop me a mail?

  46. Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You definitely know what youre talking about, why waste your intelligence on just posting videos to your blog when you could be giving us something enlightening to read?

  47. Do you mind if I quote a couple of your posts as long as I provide credit and sources back to your site? My blog site is in the very same area of interest as yours and my visitors would definitely benefit from a lot of the information you present here. Please let me know if this okay with you. Many thanks!

  48. Whats up this is somewhat of off topic but I was wondering if blogs use WYSIWYG editors or if you have to manually code with HTML. I’m starting a blog soon but have no coding experience so I wanted to get advice from someone with experience. Any help would be greatly appreciated!

  49. What i do not realize is if truth be told how you’re not really a lot more well-liked than you may be right now. You are so intelligent. You understand therefore significantly with regards to this topic, produced me individually believe it from numerous various angles. Its like men and women aren’t interested until it’s something to accomplish with Lady gaga! Your own stuffs nice. All the time care for it up!

  50. I don’t even know the way I ended up here, however I thought this publish was good. I don’t understand who you are however definitely you are going to a famous blogger in the event you are not already. Cheers!

  51. My brother suggested I would possibly like this website. He used to be totally right. This publish actually made my day. You cann’t consider just how so much time I had spent for this information! Thank you!

  52. Your style is really unique compared to other people I have read stuff from. Many thanks for posting when you have the opportunity, Guess I will just bookmark this page.

  53. Hi there! I realize this is somewhat off-topic but I had to ask. Does running a well-established blog like yours take a massive amount work? I’m completely new to writing a blog but I do write in my diary on a daily basis. I’d like to start a blog so I will be able to share my own experience and thoughts online. Please let me know if you have any ideas or tips for new aspiring bloggers. Appreciate it!

  54. You made some decent points there. I looked on the web to find out more about the issue and found most individuals will go along with your views on this site.

  55. Hey there exceptional blog! Does running a blog similar to this take a lot of work? I have virtually no expertise in computer programming but I was hoping to start my own blog soon. Anyways, if you have any recommendations or tips for new blog owners please share. I know this is off topic nevertheless I just needed to ask. Thanks!

  56. Write more, thats all I have to say. Literally, it seems as though you relied on the video to make your point. You clearly know what youre talking about, why waste your intelligence on just posting videos to your blog when you could be giving us something enlightening to read?

  57. Pretty part of content. I simply stumbled upon your web site and in accession capital to claim that I acquire in fact enjoyed account your blog posts. Any way I’ll be subscribing for your augment or even I achievement you get entry to persistently fast.

  58. I would like to thank you for the efforts you have put in writing this blog. I’m hoping to see the same high-grade blog posts from you in the future as well. In fact, your creative writing abilities has motivated me to get my very own website now 😉

  59. Hello there, simply become aware of your blog through Google, and found that it is really informative. I’m gonna watch out for brussels. I will appreciate for those who continue this in future. A lot of other folks will probably be benefited from your writing. Cheers!

  60. Excellent blog here! Also your site a lot up fast! What host are you the use of? Can I am getting your associate link in your host? I want my site loaded up as fast as yours lol

  61. Thank you for another fantastic article. Where else may anyone get that kind of information in such a perfect method of writing? I have a presentation next week, and I am at the look for such information.

  62. Your style is really unique compared to other people I have read stuff from. Thanks for posting when you have the opportunity, Guess I will just bookmark this site.

  63. Please let me know if you’re looking for a article author for your weblog. You have some really great posts and I think I would be a good asset. If you ever want to take some of the load off, I’d really like to write some material for your blog in exchange for a link back to mine. Please blast me an e-mail if interested. Kudos!

  64. Excellent website you have here but I was curious if you knew of any discussion boards that cover the same topics talked about in this article? I’d really love to be a part of group where I can get feed-back from other knowledgeable individuals that share the same interest. If you have any recommendations, please let me know. Cheers!

  65. Hey there! This post couldn’t be written any better! Reading this post reminds me of my good old room mate! He always kept talking about this. I will forward this page to him. Pretty sure he will have a good read. Thanks for sharing!

  66. Does your site have a contact page? I’m having problems locating it but, I’d like to send you an e-mail. I’ve got some suggestions for your blog you might be interested in hearing. Either way, great website and I look forward to seeing it improve over time.

  67. Howdy! Do you know if they make any plugins to help with SEO? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good results. If you know of any please share. Cheers!

  68. Today, I went to the beach with my kids. I found a sea shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She put the shell to her ear and screamed. There was a hermit crab inside and it pinched her ear. She never wants to go back! LoL I know this is completely off topic but I had to tell someone!

  69. Hi there would you mind stating which blog platform you’re working with? I’m looking to start my own blog in the near future but I’m having a tough time selecting between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design seems different then most blogs and I’m looking for something completely unique. P.S Apologies for getting off-topic but I had to ask!

  70. Today, I went to the beachfront with my kids. I found a sea shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She put the shell to her ear and screamed. There was a hermit crab inside and it pinched her ear. She never wants to go back! LoL I know this is completely off topic but I had to tell someone!

  71. With havin so much content and articles do you ever run into any problems of plagorism or copyright violation? My site has a lot of exclusive content I’ve either authored myself or outsourced but it looks like a lot of it is popping it up all over the web without my authorization. Do you know any methods to help stop content from being ripped off? I’d genuinely appreciate it.

  72. Having read this I thought it was really informative. I appreciate you taking the time and effort to put this short article together. I once again find myself spending a significant amount of time both reading and commenting. But so what, it was still worth it!

  73. Pretty section of content. I just stumbled upon your web site and in accession capital to assert that I acquire in fact enjoyed account your blog posts. Any way I’ll be subscribing to your augment and even I achievement you access consistently fast.

  74. When someone writes an piece of writing he/she keeps the thought of a user in his/her mind that how a user can understand it. So that’s why this piece of writing is amazing. Thanks!

  75. Please let me know if you’re looking for a article writer for your weblog. You have some really great posts and I believe I would be a good asset. If you ever want to take some of the load off, I’d really like to write some articles for your blog in exchange for a link back to mine. Please blast me an e-mail if interested. Many thanks!

  76. Hey! I just wanted to ask if you ever have any trouble with hackers? My last blog (wordpress) was hacked and I ended up losing a few months of hard work due to no data backup. Do you have any solutions to protect against hackers?

  77. Howdy! I could have sworn I’ve been to this web site before but after going through a few of the posts I realized it’s new to me. Nonetheless, I’m definitely pleased I discovered it and I’ll be bookmarking it and checking back regularly!

  78. Greetings! This is my 1st comment here so I just wanted to give a quick shout out and tell you I genuinely enjoy reading through your blog posts. Can you suggest any other blogs/websites/forums that deal with the same subjects? Thank you so much!

  79. I’ve read some good stuff here. Definitely worth bookmarking for revisiting. I wonder how much attempt you set to create this type of magnificent informative site.

  80. When I originally commented I seem to have clicked the -Notify me when new comments are added- checkbox and now each time a comment is added I recieve four emails with the same comment. Perhaps there is a means you can remove me from that service? Cheers!

  81. Hello there I am so happy I found your web site, I really found you by error, while I was browsing on Aol for something else, Regardless I am here now and would just like to say many thanks for a marvelous post and a all round enjoyable blog (I also love the theme/design), I dont have time to look over it all at the minute but I have saved it and also added in your RSS feeds, so when I have time I will be back to read a lot more, Please do keep up the awesome b.

  82. Terrific article! This is the type of information that are supposed to be shared around the internet. Disgrace on the seek engines for not positioning this submit upper! Come on over and discuss with my web site . Thank you =)

  83. What’s up i am kavin, its my first time to commenting anywhere, when i read this piece of writing i thought i could also make comment due to this brilliant post.

  84. I am really loving the theme/design of your weblog. Do you ever run into any internet browser compatibility problems? A number of my blog visitors have complained about my website not operating correctly in Explorer but looks great in Chrome. Do you have any tips to help fix this issue?

  85. Have you ever considered about including a little bit more than just your articles? I mean, what you say is valuable and all. However think about if you added some great visuals or video clips to give your posts more, “pop”! Your content is excellent but with images and video clips, this website could undeniably be one of the greatest in its niche. Amazing blog!

Leave a Reply

Your email address will not be published. Required fields are marked *