Autopopulating data from one main sheet to multiple sheets
Closed
Ams1105
Posts
1
Registration date
Saturday March 12, 2016
Status
Member
Last seen
March 12, 2016
-
Mar 12, 2016 at 08:14 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Mar 12, 2016 at 09:14 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Mar 12, 2016 at 09:14 PM
Related:
- Autopopulating data from one main sheet to multiple sheets
- Google sheet right to left - Guide
- Windows network commands cheat sheet - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Mark sheet in excel - Guide
- Little alchemy cheat sheet - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Mar 12, 2016 at 09:14 PM
Mar 12, 2016 at 09:14 PM
Hello Ashley,
I assume that you have one work book with a Master sheet and multiple other work sheets (named after each co-worker).
Try the following code in a standard module:-
The code should transfer Column A data only to Column A (or do you need it sent to a different column?) of each individual worker sheet.
I hope that this helps.
Cheerio,
vcoolio.
I assume that you have one work book with a Master sheet and multiple other work sheets (named after each co-worker).
Try the following code in a standard module:-
Sub TransferData() Application.ScreenUpdating = False Dim lRow As Long Dim cell As Range Dim MySheet As String lRow = Range("A" & Rows.Count).End(xlUp).Row For Each cell In Range("B3:B" & lRow) MySheet = cell.Value cell.Offset(, -1).Copy Sheets(MySheet).Range("A" & Rows.Count).End(xlUp).Offset(1, 0) Next cell Application.ScreenUpdating = True End Sub
The code should transfer Column A data only to Column A (or do you need it sent to a different column?) of each individual worker sheet.
I hope that this helps.
Cheerio,
vcoolio.