Master Sheet to affect multiple sheets
Closed
akiroche
-
Oct 5, 2017 at 01:20 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Oct 5, 2017 at 09:46 PM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Oct 5, 2017 at 09:46 PM
Related:
- Master Sheet to affect multiple sheets
- Master royale - Download - Strategy
- Google sheet right to left - Guide
- Windows network commands cheat sheet - Guide
- Yu-gi-oh master duel download pc without steam - Download - Strategy
- Mark sheet in excel - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Oct 5, 2017 at 09:46 PM
Oct 5, 2017 at 09:46 PM
Hello Aki,
Yes, its a good idea to upload a sample file. However, try the following code in the meantime:-
With this code, I'm assuming:-
- The names are in Column A.
- Your data starts in row 2 with headings in row 1.
The code is a Worksheet_Change event and needs to be placed into the worksheet module. To implement the code:-
- Right click on the Master sheet tab.
- Select "View Code" from the menu that appears.
- In the big white field that then appears, paste the above code.
Now, every time that you enter a name in Column A and then click away (or press enter or down arrow), the relevant row of data will be transferred to the corresponding individual sheet.
Do you need the "used" data to be cleared from the Master sheet after each transfer of data is completed?
Should this not quite work as you would like, then upload a sample of your file to a free file sharing site such as ge.tt or Drop Box and then post the link to your file back here. Please use dummy data in your sample.
I hope that this helps.
Cheerio,
vcoolio.
Yes, its a good idea to upload a sample file. However, try the following code in the meantime:-
Private Sub Worksheet_Change(ByVal Target As Range) Application.ScreenUpdating = False Application.EnableEvents = False If Intersect(Target, Columns("A:A")) Is Nothing Then Exit Sub Target.EntireRow.Copy Sheets(Target.Value).Range("A" & Rows.Count).End(xlUp).Offset(1, 0) Application.EnableEvents = True Application.ScreenUpdating = True End Sub
With this code, I'm assuming:-
- The names are in Column A.
- Your data starts in row 2 with headings in row 1.
The code is a Worksheet_Change event and needs to be placed into the worksheet module. To implement the code:-
- Right click on the Master sheet tab.
- Select "View Code" from the menu that appears.
- In the big white field that then appears, paste the above code.
Now, every time that you enter a name in Column A and then click away (or press enter or down arrow), the relevant row of data will be transferred to the corresponding individual sheet.
Do you need the "used" data to be cleared from the Master sheet after each transfer of data is completed?
Should this not quite work as you would like, then upload a sample of your file to a free file sharing site such as ge.tt or Drop Box and then post the link to your file back here. Please use dummy data in your sample.
I hope that this helps.
Cheerio,
vcoolio.