Related:
- Macro for merging data from multiple sheets
- Split data into multiple sheets using macro ✓ - Forum - Excel
- Macro to copy data from one sheet to another based on criteria ✓ - Forum - Excel
- How to auto populate data from multiple sheets to a master ✓ - Forum - Excel
- Autopopulating multiple sheets from one main sheet ✓ - Forum - Excel
- Macro to copy data from one sheet to another - How-To - Excel
1 reply
TrowaD
- Posts
- 2675
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- November 5, 2020
Hi Ashwathi V K,
That single excel sheet in the code below is called "Main". Every Column B of all the other sheets will be copied to the "Main" sheets first available column based on the data in the first row.
Give it a try:
Best regards,
Trowa
That single excel sheet in the code below is called "Main". Every Column B of all the other sheets will be copied to the "Main" sheets first available column based on the data in the first row.
Give it a try:
Sub RunMe()
Dim ws As Worksheet
For Each ws In Worksheets
If ws.Name <> "Main" Then
ws.Select
Columns("B:B").Copy Sheets("Main").Cells(1, Columns.Count).End(xlToLeft).Offset(0, 1)
End If
Next ws
End Sub
Best regards,
Trowa
Newsletter
It is not working. Is says 'Run time error 9' .
Thanking you
With regards
Ashwathi V K
- Posts
-
2675
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- November 5, 2020
448Do you have a sheet named "Main" in your workbook?
Best regards,
Trowa
Sorry , I didn't made a separate sheet named 'Main'. That's why it shows error. Now i am able to run. thankyou for solving the problem.
Thankyou
With regards
Ashwathi V K
- Posts
-
2675
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- November 5, 2020
448 > ashwathi