data copy

Hi everyone, I am quite new to excel and have stumbled upon a problem. Namely I have a document where on one sheet (see 1.png) I have a table with teams and their elo values, while on the other sheet (see 2.png) I have data from a certain period that is then converted to an elo change for a...

I hope you can help me with on requirement, I have 10 columns data in Sheet1 and during my working, I can change any data in these columns...but usually, these changes anywhere in the row...same data in Sheet2 and whatever changes to in sheet1 should automatically replace the values in Sheet2...

Sub transfer() Dim i As Long, j As Long, lastrow1 As Long, lastrow2 As Long Dim myname As String lastrow1 = Sheets("sheet1").Range("A" & Rows.Count).End(xlUp).Row Worksheets("Sheet1").Select Application.ScreenUpdating = False For i = 2 To lastrow1 myname = Sheets("sheet1").Cells(i...

Hello all, I'm a new user to VBA. Have been programming since a week and I'm stuck with one of my code. I have mutiple sheets contaning data in a certain format. I want to only copy few blocks of data from all the sheets and arrange in a certain order in a newly created worksheet. I'm...

Hello everyone! I have lots of excel files, each one saved in a separated folder, that I have to copy data from them. This is the structure I have here: Folder Names: 15109 15115 16160 etc ... A total of 70+ folders Each folder has a excel (with macro file): 15109 LME.xlsm 15115 LME.xlsm...

Hi, M new to excel I am working on to automate a process please help me out here is the problem statement there is a folder D:\ABC\ABCDEFG\Automation this folder contains Sheet1 Sheet2 Sheet3 Sheet4 Sheet5 Master I want a script which will automatically open all sheets from 1 - 5 and...