Accountingpro Solution Tamil
Accountingpro Solution Tamil
  • Видео 17
  • Просмотров 6 553
Combine data from multiple sheets into one sheet of the same Excel | #excel_tamil
Using this VBA code you can combine data from multiple sheets into one sheet : -
----------------------------------------------------------------------
Sub CopySelectedSheetsToActiveSheet()
Dim ws As Worksheet
Dim destRange As Range
Dim srcRange As Range
' Set the destination range (where you want to paste the data)
Set destRange = ActiveSheet.Range("A1")
' Loop through each selected sheet
For Each ws In ActiveWindow.SelectedSheets
' Set the source range (the data you want to copy)
Set srcRange = ws.UsedRange
' Copy the data from the source range to the destination range
srcRange.Copy destRange
' Move the destination range down for the next sheet's data
Set destRange = destRange.Offset(src...
Просмотров: 2 399

Видео

Rename Multiple files | Bulk rename any files or folders using Excel #excel_tamil #exceltips1:39Rename Multiple files | Bulk rename any files or folders using Excel #excel_tamil #exceltips
Rename Multiple files | Bulk rename any files or folders using Excel #excel_tamil #exceltips
Просмотров 540Месяц назад
Rename Any Folder of files using Excel and CMD prompt, Step : 1 After opening the folder, Type "CMD" at the address bar Step : 2 In Command prompt type "DIR /B", the name to be rename will be listed Step : 3 Copy those name and paste them into our excel template Step : 4 Feed the new name and merger those two name with prefix of "ren" as mentioned below 👇🏻 👇🏻👇🏻 Formula = CONCATENATE("ren ",CHAR...
Import Masters from Excel to Tally prime 4.1 | Bulk Import Ledger Masters in Tally #excel_tamil5:45Import Masters from Excel to Tally prime 4.1 | Bulk Import Ledger Masters in Tally #excel_tamil
Import Masters from Excel to Tally prime 4.1 | Bulk Import Ledger Masters in Tally #excel_tamil
Просмотров 182Месяц назад
Bulk import, one of the amazing facility in Tally prime 4.1. Its Completely free watch this video and enhance your Accounting Efficiency #pro_accountant
Match Data or Column | Compare Data or Column using VLOOKUP formula | #excel_tamil2:20Match Data or Column | Compare Data or Column using VLOOKUP formula | #excel_tamil
Match Data or Column | Compare Data or Column using VLOOKUP formula | #excel_tamil
Просмотров 6182 месяца назад
Match or Compare any set of data or Columns or Tables using VLOOKUP formula in Excel, Join with us and Enhance your Accounting efficiency. #pro_accountant #exceltricks #exceltutorial
Excel to Tally prime 4.1 | Bulk Transaction import for free | Accountingpro Solution6:32Excel to Tally prime 4.1 | Bulk Transaction import for free | Accountingpro Solution
Excel to Tally prime 4.1 | Bulk Transaction import for free | Accountingpro Solution
Просмотров 802 месяца назад
Excel to Tally prime 4.1 | Bulk Transaction import for free | Accountingpro Solution

Комментарии

  • @stp4958
    @stp4958 3 дня назад

    பேசுவது பிரியாத அளவுக்கு back gound மியூசிக் தேவையா

    • @Accountingpro_solution
      @Accountingpro_solution 10 часов назад

      @@stp4958 கம்மி பண்ணிடலாம் ! நண்பா !! 🤗

  • @PRAVEENPCGUIDE
    @PRAVEENPCGUIDE 9 дней назад

    Nice Video

  • @rajnarayanan2380
    @rajnarayanan2380 Месяц назад

    But I have no Developer option

    • @Accountingpro_solution
      @Accountingpro_solution Месяц назад

      Okay, now you can use macros in VIEW -> MACROS -> 'type new' -> CREATE If it's not clear enough, text back I'll share video in this regards 👍

  • @srinivasan7548
    @srinivasan7548 Месяц назад

    Is not recognised as an internal or and external command, nu varuthu anna... If possible Kindly attach u r template

    • @Accountingpro_solution
      @Accountingpro_solution Месяц назад

      Sure pa, Use this link to download 👇👇docs.google.com/spreadsheets/d/18_mnhCNxzoT9cUoDpNkMouzDl_CdS34a/edit?usp=drivesdk&ouid=110553776702083372224&rtpof=true&sd=true

    • @srinivasan7548
      @srinivasan7548 Месяц назад

      ​@@Accountingpro_solution Thank you 👍

    • @srinivasan7548
      @srinivasan7548 Месяц назад

      @@Accountingpro_solution thank you so much

  • @GopalGopal-ox5jx
    @GopalGopal-ox5jx Месяц назад

    How to match and copy data from another excel sheet.

    • @Accountingpro_solution
      @Accountingpro_solution Месяц назад

      Yes brother, it's possible with same formula, make sure the table array we sellted properly for the look-up value ! Also, I'll share the new video with that content ☺️

  • @V-TechControlsCbe
    @V-TechControlsCbe Месяц назад

    smart

  • @AlaganRamesh-pl2lj
    @AlaganRamesh-pl2lj 2 месяца назад

    ❤

  • @Accountingpro_solution
    @Accountingpro_solution 2 месяца назад

    FORMULA :- =CHOOSE(LEFT(TEXT(A2,"000000000.00"))+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine") &IF(--LEFT(TEXT(A2,"000000000.00"))=0,,IF(AND(--MID(TEXT(A2,"000000000.00"),2,1)=0,--MID(TEXT(A2,"000000000.00"),3,1)=0)," Hundred"," Hundred and ")) &CHOOSE(MID(TEXT(A2,"000000000.00"),2,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ") &IF(--MID(TEXT(A2,"000000000.00"),2,1)<>1,CHOOSE(MID(TEXT(A2,"000000000.00"),3,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"), CHOOSE(MID(TEXT(A2,"000000000.00"),3,1)+1,"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen")) &IF((--LEFT(TEXT(A2,"000000000.00"))+MID(TEXT(A2,"000000000.00"),2,1)+MID(TEXT(A2,"000000000.00"),3,1))=0,,IF(AND((--MID(TEXT(A2,"000000000.00"),4,1)+MID(TEXT(A2,"000000000.00"),5,1)+MID(TEXT(A2,"000000000.00"),6,1)+MID(TEXT(A2,"000000000.00"),7,1))=0,(--MID(TEXT(A2,"000000000.00"),8,1)+RIGHT(TEXT(A2,"000000000.00")))>0)," Million and "," Million ")) &CHOOSE(MID(TEXT(A2,"000000000.00"),4,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine") &IF(--MID(TEXT(A2,"000000000.00"),4,1)=0,,IF(AND(--MID(TEXT(A2,"000000000.00"),5,1)=0,--MID(TEXT(A2,"000000000.00"),6,1)=0)," Hundred"," Hundred and")) &CHOOSE(MID(TEXT(A2,"000000000.00"),5,1)+1,,," Twenty"," Thirty"," Forty"," Fifty"," Sixty"," Seventy"," Eighty"," Ninety") &IF(--MID(TEXT(A2,"000000000.00"),5,1)<>1,CHOOSE(MID(TEXT(A2,"000000000.00"),6,1)+1,," One"," Two"," Three"," Four"," Five"," Six"," Seven"," Eight"," Nine"),CHOOSE(MID(TEXT(A2,"000000000.00"),6,1)+1," Ten"," Eleven"," Twelve"," Thirteen"," Fourteen"," Fifteen"," Sixteen"," Seventeen"," Eighteen"," Nineteen")) &IF((--MID(TEXT(A2,"000000000.00"),4,1)+MID(TEXT(A2,"000000000.00"),5,1)+MID(TEXT(A2,"000000000.00"),6,1))=0,,IF(OR((--MID(TEXT(A2,"000000000.00"),7,1)+MID(TEXT(A2,"000000000.00"),8,1)+MID(TEXT(A2,"000000000.00"),9,1))=0,--MID(TEXT(A2,"000000000.00"),7,1)<>0)," Thousand "," Thousand and ")) &CHOOSE(MID(TEXT(A2,"000000000.00"),7,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine") &IF(--MID(TEXT(A2,"000000000.00"),7,1)=0,,IF(AND(--MID(TEXT(A2,"000000000.00"),8,1)=0,--MID(TEXT(A2,"000000000.00"),9,1)=0)," Hundred "," Hundred and "))& CHOOSE(MID(TEXT(A2,"000000000.00"),8,1)+1,,,"Twenty ","Thirty ","Forty ","Fifty ","Sixty ","Seventy ","Eighty ","Ninety ") &IF(--MID(TEXT(A2,"000000000.00"),8,1)<>1,CHOOSE(MID(TEXT(A2,"000000000.00"),9,1)+1,,"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"),CHOOSE(MID(TEXT(A2,"000000000.00"),9,1)+1,"Ten","Eleven","Twelve","Thirteen","Fourteen","Fifteen","Sixteen","Seventeen","Eighteen","Nineteen"))

  • @DineshDinesh-fd9jp
    @DineshDinesh-fd9jp 2 месяца назад

    Super bro