PART 128 - HOW TO COPY & PASTE VALUES BASED ON COLUMN HEADERS IN VBA MACRO (TAMIL)

Поделиться
HTML-код
  • Опубликовано: 15 окт 2024
  • In This Channel I'm Providing Advanced MS Excel, VBA Macros & Other Educational Related Tutorials In Tamil Language.

Комментарии • 47

  • @sagarmane5357
    @sagarmane5357 2 года назад +1

    Hi Sir - Not able to understand Tamil but it’s to me. I have tried it and works well Thanks 🙏 😊

  • @satathmsasi
    @satathmsasi 2 года назад

    Thank you so much.... Romba helpful aa irundhidichu

  • @vamsiarava2813
    @vamsiarava2813 2 года назад

    Nengal Suuperr thalivaaa....Thanks a lot broo...

  • @jameshoo357
    @jameshoo357 4 года назад +1

    Sir, You have been doing a great job ! Please use English language.

  • @arunkumar2209
    @arunkumar2209 5 лет назад +1

    Superb bro.. Very useful

  • @ashwinemmanuvel528
    @ashwinemmanuvel528 Год назад

    @Kallanani YT please help me. I am getting 1004 error while trying to run the code

  • @liveitlogical
    @liveitlogical 2 года назад

    Can you please explain how can we consolidate multiple sheets from SourceWB in TargetWB using a similar Logic/code

  • @raghunathr.k9292
    @raghunathr.k9292 3 года назад

    Sir, Its very useful... i need to copy paste the multiple sheet data instead of single sheet based on header then how to fix the variable.... i have tried many ways but its updated only one sheet and remaining sheet unable to paste it in to master sheet. please help me to consolidate multiple sheet.

  • @Rahulhandsom5598
    @Rahulhandsom5598 3 года назад

    Hi bro how to contact you ? Need your help some corrections in my macro..

  • @PavanKumar-ph3wu
    @PavanKumar-ph3wu 2 года назад

    I'm getting compile error on the lastrow1 itself, kindly help sir?

  • @sagarmane5357
    @sagarmane5357 2 года назад

    Sir - Can we set here range from A1 to end column instead of G1? Please help sir
    Set Rng1 = ThisWorkbook.Worksheets(“Sheet1”).Range(“A1:G1”)

    • @KallanaiYT
      @KallanaiYT  2 года назад

      Yes you can set till end column as well

    • @sagarmane5357
      @sagarmane5357 2 года назад

      @@KallanaiYT Sir Please help me with code in same row

  • @balasiva6505
    @balasiva6505 4 года назад

    good one, but how to do the same thing for different workbook (Another excel) and same thing i need to follow. Please help me out

    • @balasiva6505
      @balasiva6505 4 года назад

      same concept for different workbook

    • @KallanaiYT
      @KallanaiYT  4 года назад

      I'll make a video with different workbook

    • @saro5069
      @saro5069 4 года назад

      Kallanai YT Hi Can i have ur email or whatsapp num i need your help to create VBA code and i am not able to find your email id here.
      please ping me at saravanakumar9520@gmail.com

    • @KallanaiYT
      @KallanaiYT  4 года назад

      Look at Part - 221, 222

    • @saro5069
      @saro5069 4 года назад

      Kallanai YT i sent one email to ur email id can u please check bro

  • @irenesanjay
    @irenesanjay Год назад

    Can we get the data file

  • @aomojang
    @aomojang 5 лет назад +1

    Very usefull

  • @syedrayan2393
    @syedrayan2393 4 года назад

    SIR CAN YOU PUT THE EXCEL SHEET WITH THE MACRO

  • @bharanidharan285
    @bharanidharan285 5 лет назад

    R u taking private classes

  • @manikandanv71
    @manikandanv71 4 года назад

    Bro.. u haven't declared any value then how it is working.. ? Complier error throwing for me

    • @KallanaiYT
      @KallanaiYT  4 года назад +1

      Variables are not mandatory to declare. Variable must when u define Option explicit in the top of code

    • @manikandanv71
      @manikandanv71 4 года назад

      @@KallanaiYT Greatly Appreciate your quick response.. ❤️❤️

  • @madhusudanansrambikkal6190
    @madhusudanansrambikkal6190 2 года назад

    Guru !!! I bow down with a lots of respects, With lot of humbleness, with lots of affection and prayers on this holyday of Guru Poornima. The Macro you taught here was immense value to me. Thank you Guru. Kindly Share your number. I want to talk to you.

  • @chrisg4408
    @chrisg4408 5 лет назад +2

    can you do an english version please!!!

    • @KallanaiYT
      @KallanaiYT  5 лет назад

      Ya sure. I'll do it soon

    • @chrisg4408
      @chrisg4408 5 лет назад

      @@KallanaiYT Thanks very much! This will help me out greatly!

    • @KallanaiYT
      @KallanaiYT  5 лет назад

      👍

    • @rvas1966
      @rvas1966 4 года назад

      Good one ...if I want to copy the whole data repeatedly one below the other.. what should be done with paste special method... kindly Advice

  • @crishgaming_
    @crishgaming_ 3 года назад

    DUDE SHARE UR VBA CODE

  • @8754911081
    @8754911081 4 года назад

    Dear Sir ungala contact pannanum number kodunga plz?

    • @KallanaiYT
      @KallanaiYT  4 года назад

      Email is available in the video description box. Pls send an email if u have any queries

  • @tamilanrajendran5524
    @tamilanrajendran5524 Год назад

    I have some doubt in this macro, can pls give me you number