Excel Macro to Copy data into another Worksheet - Malayalam Tutorial

Опубликовано: 16 Февраль 2026
на канале: XL n CAD Malayalam
7,774
119

VBA program to Copy data from one Excel Worksheet to another Worksheet explained in Malayalam.

മൈക്രോസോഫ്റ്റ് എക്സൽ കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
https://www.udemy.com/course/microsof...

Subscribe to ‪@AjayAnandXLnCAD‬ for more.
   / ajayanandxlncad  

ഒരു വർക്ക് ബുക്കിലെ രണ്ടു വർക് ഷീറ്റുകളെ തമ്മിൽ side by side, compare
ചെയ്യുന്നതെങ്ങനെ? (How to compare two Worksheets in a Workbook side by side)
   • How to compare two Excel Worksheets - Mala...  

Microsoft Word Beginner to Professional കോഴ്സിൽ എൻറോൾ ചെയ്യുന്നതിന് വേണ്ടിയുള്ള ലിങ്ക് ചുവടെ...
https://www.udemy.com/course/learn-mi...

VBA Code for Copying data from one Excel Worksheet to another Worksheet
Sub ExtractData2()
For Each Sheet In ActiveWorkbook.Worksheets
If Sheet.Name = "Copied Data" Then
Application.DisplayAlerts = False
Worksheets("Copied Data").Delete
Application.DisplayAlerts = True
End If
Next Sheet
Dim WS1 As Worksheet
Selection.Copy
Set WS1 = ActiveSheet
Sheets.Add.Name = "Copied Data"
Sheets("Copied Data").Range("B3").PasteSpecial (xlPasteAll)
WS1.Select
Selection.End(xlUp).Select
Range(Selection, Selection.End(xlToRight)).Copy
Sheets("Copied Data").Range("B2").PasteSpecial (xlPasteAll)
Sheets("Copied Data").Range("B2").PasteSpecial (xlPasteColumnWidths)
Sheets("Copied Data").Select
End Sub

📢 Disclaimer: If you click on my affiliates links, I am going to receive a tiny commission. The products that I advertise are the ones I believe in.
🏃‍♂️ My Running Kit for Hyderabad Marathon 2025
https://amzn.to/44IILeG
📊 Think Like an Analyst: Books That Helped Me
https://amzn.to/3SNy6bi
📚 Mind-Opening Reads You Can’t Miss
https://amzn.to/43tM2fu

#excelmalayalam #malayalamtutorial #exceltips