Automatic Vlookup Formula By Macro In Excel Tamil

Поділитися
Вставка
  • Опубліковано 7 січ 2025

КОМЕНТАРІ • 131

  • @masterofinnovation9862
    @masterofinnovation9862 5 років тому +4

    அருமையான பதிவு... அதுவும் தமிழில்... நீங்கள் உண்மையாகவே அங்கீகரிக்கப்பட்டவர்....வாழ்க வளமுடன் .👍👌

  • @akr5251
    @akr5251 5 років тому +1

    Super sir... தங்களின் அனைத்து வீடியோக்களும் மிக்க பயனுள்ள வகையில் உள்ளது... மிக்க நன்றி வாழ்க வளமுடன்

  • @GAJENDRANINDRA
    @GAJENDRANINDRA 4 роки тому

    நன்றாக புரியும்படி உள்ளது உங்கள் பதிவு

  • @vigneshvikki9059
    @vigneshvikki9059 4 роки тому

    Jii....neenga podra video's la rombha nalla irukku .....easy ahh understand aaguthu.....but irunthalum interview la epdii questions , formula kepanga nu video pannunga jii....

  • @nazarkamal8831
    @nazarkamal8831 Рік тому

    Romba thanks bro andha button ah eppadi set pandrathunu dhan romba naal theditu irundhaen!!! Idha yaarumae sollala neenga dhan sollirukkinga thanks a lot 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

  • @mansoorsuhail3206
    @mansoorsuhail3206 3 роки тому +1

    Super ah explain panringa thanks 🙏 very clear and precise ah solitanshinga bro thanks a lot

  • @vetrikani4262
    @vetrikani4262 3 роки тому

    அருமை நண்பா, இப்படி ஒரு நண்பரை பின் தொடர்வதில் மகிழ்ச்சி,,,,

  • @v.antonyraj3321
    @v.antonyraj3321 5 років тому +2

    Hi Stanly bro, today this season was very useful to me, because I'm working with more Dada's, so I want from you more videos same like this. I want to learn how to use the Dada's to make more valuable report and short period of timing and how can make a chart also.

  • @umabanu1304
    @umabanu1304 3 роки тому

    Super bro easy yaa eruku neegaa soolarathu thanks 😊

  • @subramaniamramamurthy7548
    @subramaniamramamurthy7548 5 років тому +3

    Thank you boss, it's very much necessary

  • @SN-us5se
    @SN-us5se 5 років тому +1

    Sema Usefull Video Bro. Make Many Videos For Macros

  • @gopalarju567
    @gopalarju567 Рік тому

    Super sir உங்கள் video super

  • @motogp007r
    @motogp007r 5 років тому +1

    Thanks for all ur wonderful works bro, could u please post videos more about macros.

  • @karthikeyan3953
    @karthikeyan3953 4 роки тому

    Varamatinkuthu....

  • @ismailsha5730
    @ismailsha5730 3 роки тому

    Good I want more explain in company level

  • @SamSam-gh3ep
    @SamSam-gh3ep 5 років тому +1

    Good job

  • @hajasahib8943
    @hajasahib8943 5 років тому

    Very useful bro thanks

  • @surezz2999
    @surezz2999 5 років тому +1

    Can u Pls take separate Video How to create MACRO IN EXCEL for multiple sheets for Data analysis for sales data.

  • @abdulrahim9378
    @abdulrahim9378 10 місяців тому

    Hi bro, it's very useful
    Intha vlookup coding ah another sheet la run pananum but raw data automate file iruku but atha na unoru template run pane edukanum. Please your support bro. Thanks!

  • @sanjayk1286
    @sanjayk1286 3 роки тому

    GREAT EXPLANTION

  • @vijay2yuvi
    @vijay2yuvi 4 роки тому +1

    Is this applicable for merged cells

  • @subramanianjayaraman6975
    @subramanianjayaraman6975 5 років тому

    Super sir. Ms office and in Excel with macros and almost all formulas annd functions and in power point with pie charts and graphs any courses ru offering?? Pls reply

  • @nijamudhins3405
    @nijamudhins3405 5 років тому

    Thanks a lott bro.. Ur Great

  • @prabas2006
    @prabas2006 5 років тому +2

    Why Control enter,
    Normal enter should work, right?

  • @arbalaje
    @arbalaje 5 років тому

    Thank you very much Guru...

  • @poomarim9979
    @poomarim9979 4 роки тому +1

    Haii brother,
    I need your help... I tried your video in Excel. I didn't get the proper result as you said in this video.

  • @sathyaraj3155
    @sathyaraj3155 5 років тому

    sir thank you for your vedios

  • @selvamroshan2822
    @selvamroshan2822 4 роки тому +1

    Hi Sir , This is was useful information but i am unable to the form control by which created the button because of which i couldn't control my practice. .. My excel version is 10 Please help pannunga sir

  • @citizen8865
    @citizen8865 5 років тому

    It’s a great help

  • @afridimahroof4909
    @afridimahroof4909 3 роки тому

    Yaaru sir neenga ellathulayum expert ah irukkinga epdi sir ithu ellam kaththukittinga

  • @newtag5172
    @newtag5172 5 років тому

    Pivot table use pannum podhu original tablil numbers change pannum podhu pivot table auto change ahum ok. Pivot tablil numbers change panni original tablai matra mudiuma??

  • @bhogarsishyan5769
    @bhogarsishyan5769 5 років тому

    Thanks! There are only data or datum never datas. This is for your information please.

  • @aharishdeepakclass10th30
    @aharishdeepakclass10th30 4 роки тому

    Supper sir

  • @priyagautham-js3nk
    @priyagautham-js3nk Рік тому

    Automatic Mis report and inventory management kuda barcodes also maintain panna mudiyuma sir oru excel la

  • @tamil2133
    @tamil2133 4 роки тому

    Thanks ji...

  • @ananthansundram1602
    @ananthansundram1602 2 роки тому

    Sir.. Veru oru file Data Macro excel- yil ulla data vai, eppadi innoru file Data excel-yil eppadi converted pannuvathu..

  • @srikutta9089
    @srikutta9089 5 років тому

    Bro,
    "Forecast functions" usage pathi Oru detail video ha podunga...

  • @afridimahroof4909
    @afridimahroof4909 3 роки тому

    sir ungala paththi oru video podunga. i am curious to know about you sir

  • @rrajkumar2825
    @rrajkumar2825 5 років тому

    Super jii

  • @vickyvicky-qi4gl
    @vickyvicky-qi4gl 5 років тому

    sir excel short cut keys mattum oru video va kodutha easy ya yirukum sir..nan new excel ku konjam guide panunga sir

  • @sujithsuji1769
    @sujithsuji1769 5 років тому

    Thanks a lot anna

  • @WorldAffairs1st
    @WorldAffairs1st 4 роки тому

    Bro vlookup ku use panra data vera oru excel work book la irunthalum intha macro work pannuma??

  • @go2way892
    @go2way892 5 років тому

    I understood

  • @kalaiyarasim0702
    @kalaiyarasim0702 5 років тому +1

    Hi, how to take screenshots by using macro

  • @rajanvinai3244
    @rajanvinai3244 5 років тому

    Hi bro iam new company billing excel

  • @Sak1985
    @Sak1985 2 місяці тому

    multiple excel sheets convert into single sheets macro programme irukka

  • @vijayalakshmib5923
    @vijayalakshmib5923 4 роки тому

    Multiple Sorting using macro

  • @philipsk4769
    @philipsk4769 5 років тому

    word press vedio podunka ji 🤔🤔🤔

  • @lakshmiyuva4067
    @lakshmiyuva4067 5 років тому

    Please post about ppmt sir

  • @mohamedyoosuffmohamedjamee537
    @mohamedyoosuffmohamedjamee537 4 роки тому

    Brand : - Items
    Nokia - N1, N6, N95, N90
    Samsung - S1, S2, S3, S4
    Apple - i3, i4, i6, i8
    LG - L21, L35, L65

  • @siva.dhanaraj1710
    @siva.dhanaraj1710 5 років тому

    Thanks bro,
    I need data get from another workbook and multiple rows and column...
    If it's possible kindly make a video and post it, thanks in advance....

    • @tutorjoes
      @tutorjoes  5 років тому +1

      You can send video request thought what's app

    • @siva.dhanaraj1710
      @siva.dhanaraj1710 5 років тому

      I didn't have your WhatsApp no bro

  • @vinothvrp07
    @vinothvrp07 4 роки тому

    Ji, you put vlookup only for 2nd column in this video, then how it comes for mark has well when you clicked Run button?

  • @saravananm946
    @saravananm946 Рік тому

    How to use vlookup from other workbook in macro recording and when I was macro recording duplicate removed but rows not clear so how to short out this issue

  • @SureshKumar-ue4po
    @SureshKumar-ue4po 5 років тому

    thank you ji

  • @mohamedfayas9504
    @mohamedfayas9504 4 роки тому

    Hi Bro, I did these formula .if i click the run button under the name header name is coming but if i click the run button under the subject header the same name is coming again, i couldnt get the marks. please guide me

  • @anandbabu1447
    @anandbabu1447 5 років тому

    Ji.. oru excel la use pannuna macro va innoru excel la same logic use panna mudiyuma...

    • @tutorjoes
      @tutorjoes  5 років тому

      Ya s we can

    • @anandbabu1447
      @anandbabu1447 5 років тому

      @@tutorjoes epadi ? Overview ah sollunga bro

  • @mrtamiltiger3980
    @mrtamiltiger3980 3 роки тому

    I have question in one excel we have 50 data's with headings however another excel in that we have only 40 headlines as per the headings I need to copy paste the data from 50'data Excel can you please explain how to create Marco for this

  • @rihanmohamed9594
    @rihanmohamed9594 4 роки тому

    Hi,
    I have a committed qty like 200 pcs, i need to distribute to 24 shops (A to X)each 6 pcs and the balance qty in stock, i need a function or like a software while im scanning one by one it should display by shop Alphabet. Can u make a video please..

  • @golisoda9051
    @golisoda9051 4 роки тому

    Sir macro excel la coding use panni multiple datas yepdi data yedukuradu pls sollunga sir...

  • @kandaiyansasthiri6082
    @kandaiyansasthiri6082 5 років тому

    Hellow
    how to find all douplicated numbers in excel ?
    normally mod can find only one maximum douplicated number only
    i wish to find second / 3rd /4th douplicated numbers
    is there any function ?

  • @ahamedkabeer3985
    @ahamedkabeer3985 5 років тому

    Thanks

  • @adilakshmig.praison6845
    @adilakshmig.praison6845 Рік тому +1

    G.praison
    Excelaidhueppadivandhudhu

  • @adhambasha1278
    @adhambasha1278 5 років тому

    Wps office pathium kujum sulluinga bro!!! Please!! 2 duthum yanna different???

  • @lalithasriraman201
    @lalithasriraman201 Рік тому

    How to get text values in pivot table?

  • @hariharanravi802
    @hariharanravi802 3 роки тому

    Bro ...enaku oru doubt will you please clear me ...
    Neenga sample data vachi irukinga la ....
    Enaku oru sila time sample data 3k irukum or more than 12k irukum .
    Neenga solra formula padi pota ...vachi iruka data ku thaan macro poda mudiyum....
    But enaku enna venumna evlo sample data potalum enaku output varanum ...enaku regular ah work panna oru excel book venum bro

  • @Jayanthan-mc5rb
    @Jayanthan-mc5rb 4 роки тому

    Ji i need to vlookup 1000000 rows in excel how fast is this macro will give result

  • @manikandanc2951
    @manikandanc2951 5 років тому

    sir pls need advance excel la vlookup function and hlookup function process pathi sollunga

  • @ramakrishnanm5817
    @ramakrishnanm5817 4 роки тому

    Sir how copy this formula for next next rows

  • @MrsRKChannel
    @MrsRKChannel 3 роки тому

    Anna Teach me how to use two or more combine formulas. EG: In Vlookup with iferror 2. Sumif with countif both. 3. If and true or false like join formula. Please I am not getting. Please put one video or will helpfull for my job.

  • @vinothkumarsekar71
    @vinothkumarsekar71 5 років тому

    Nice

  • @thirumalainambi8857
    @thirumalainambi8857 5 років тому

    GST invoice fully automatic like purchase sales ledger, accounts statements and seller list customer list stock management in one excel eppadi pandrathu sollunga ji

  • @kathirvelu2073
    @kathirvelu2073 5 років тому

    How maintenance accounts in excel procedure

  • @muthukrishnan3817
    @muthukrishnan3817 5 років тому

    Bro Macro orinted ah vedios continuos upload pannuga

  • @sathyaraj3155
    @sathyaraj3155 5 років тому

    sir enaku dought enkitta oru data iruku athula account group oru column and vendors another colum then finala amount colum iruku ippo enaku oru account group 10vendors irupaga atha mari ovvoru vendorlaium irupaga so na ippo pivot table report filter mari enaku formula use panni antha particular account group select panna athula iruka vendors amount enaku varanum

  • @Shree_krishna_boutique
    @Shree_krishna_boutique 5 років тому

    i cannot c developer option in excel 2010 ? what to do

  • @ambikaponsuyambu3058
    @ambikaponsuyambu3058 4 роки тому

    Sir..I made all ...But if I select a cell and press the button we made...I cant see any changes...What mistake did I made? Plz explain me sir...

  • @kodairoadkannan
    @kodairoadkannan 5 років тому

    good

  • @michaelrajrk5868
    @michaelrajrk5868 4 роки тому

    Bro... Without mac how to do all column A2Z at a time in vlookup

  • @omerali6834
    @omerali6834 5 років тому

    Amazing

  • @harrish9737
    @harrish9737 4 роки тому +2

    Sir yennaku run kudutha varamatikithu
    Yenna pannanu

  • @ashoktamilchannel9687
    @ashoktamilchannel9687 5 років тому

    Hi How Matke macro daily base report will take in one file to another file and also connect with netapp will downloard yester day report will takeing the macro pls uploard video or sd my mail id

  • @saran_the_wanderlust
    @saran_the_wanderlust 4 роки тому

    Bro.. multiple filters(4filters -like 1.manager name, 2.team, 3.TL name, 4.Product) use pani sales report dashboard creat pandratha solunga bro..!!!

  • @mohamedismail192
    @mohamedismail192 4 роки тому

    Bro macro excel sheet ah enoda lab la mail la irundhu download Panna mudila Panna download agudhu file ah open Panna file deleted nu varudhu ena problem ah irukum bro

  • @subbiahrajendran933
    @subbiahrajendran933 2 роки тому

    How to retain formulas even if data deleted.

  • @vivek5147
    @vivek5147 5 років тому

    Thanz sir

  • @sugunachandran1263
    @sugunachandran1263 7 місяців тому

    Hello sir, இப்பவும் நீங்கள் excel கேள்விகளுக்கு பதில் அனுப்புவீர்களா சார்.

  • @prasannavenkatesh5807
    @prasannavenkatesh5807 5 років тому

    Hi sir.. My excel file is hanging while I'm working (it contains 3k rows). Any solution for this issue?

  • @logeshwaris4882
    @logeshwaris4882 4 роки тому

    Ji vlookup use panni epdi multiple cells la data edukrathu

  • @manoharanpjs3905
    @manoharanpjs3905 3 роки тому

    sir please teach 2007 excel

  • @TamilBLASTER
    @TamilBLASTER 5 років тому

    Run button eppadi bro function aaguthu? Adhu epdi create pandrathu?

  • @srisandi8207
    @srisandi8207 4 роки тому

    வணக்கம்
    ஒரு Excel sheet ல் இரண்டு தகவல் இருக்கு அதாவது Example 3000 thousands Employee Id , name, lic account no with amount, இருக்கு அடுத்த excel sheet ல் employee id name and amount மட்டும் தான் இருக்கு policy no இல்லை. இப்ப ஒரு employee 10 or more lic potturukkaru . amount க்கு correct policy no eppadi கொன்டு வருவது சார்

  • @PraveenKumar-ie1sv
    @PraveenKumar-ie1sv 4 роки тому

    Hi bro vlookup la.. Ennoru doubt eruku bro.. Sigle cell la multiple num slash oda erukum.. Adhan lookup value.. So data single single ah erukum.. Bt yenaku result mutiple ah venum lookup potu.. Please help

    • @tutorjoes
      @tutorjoes  4 роки тому

      View our vlookup playlist

  • @SasiKumar-mp1bg
    @SasiKumar-mp1bg 5 років тому

    English karanga automatic team generator eppadi excela use panranga solunga emailku send pannunga sir

  • @Raatharajan
    @Raatharajan 3 роки тому

    SIR PLEASE I WANT MS ACCESS FULL COURSE IN SINGLE VIDEO

  • @bhushanmukadam8462
    @bhushanmukadam8462 5 років тому

    If data will add in next row then macro is not working with new reference.

    • @tutorjoes
      @tutorjoes  5 років тому

      Make the data in table and change formula reference to table

    • @bhushanmukadam8462
      @bhushanmukadam8462 5 років тому

      Change reference but answer is blank

    • @bhushanmukadam8462
      @bhushanmukadam8462 5 років тому

      Please provide example Excel for my reference.

  • @krishnajagadeesh6307
    @krishnajagadeesh6307 5 років тому

    Excel oiru software matheri epde great painurathu ji

  • @vinothkumarsekar71
    @vinothkumarsekar71 5 років тому

    Pivot table sollunga bro

  • @nijamudhins3405
    @nijamudhins3405 5 років тому

    How to automatically generate outlook mail after running excel macro

  • @anandselvaraj2520
    @anandselvaraj2520 5 років тому

    Module vlookup macro pannuga ji

  • @gayathri-8-i6s
    @gayathri-8-i6s 4 роки тому

    It is not working bro..
    What mistake I would did??