VBA Coding - For Making Consolidated Data sheet by using MultipleSheets data (MultipleSheets डेटा का उपयोग करके समेकित डाटा बनाने के लिए)
VBA Coding - For Making Consolidated Data sheet by using MultipleSheets data (MultipleSheets डेटा का उपयोग करके समेकित डाटा बनाने के लिए) Sub For_Mastersheet_Update() Dim wb As Workbook Dim rng As Range Set wb = Workbooks("Pk_File.xlsm") wb.Activate Worksheets("Master").Activate Worksheets("Master").Cells.ClearContents Worksheets("XYZ2").Activate Worksheets("XYZ2").Range("a1").CurrentRegion.Select ' For Select Current Region or All Data Worksheets("XYZ2").Range("a1").CurrentRegion.Copy ' For Copy Select Data Worksheets("Master").Activate ' For activate sheet where you want to copy data Worksheets("Master").Range("a1").PasteSpecial Paste:=xlPasteValuesAndNumberFormats ' Paste Copy Data Selection.Columns.AutoFit ...