Transfer Data IF....
Closed
MT
-
Nov 22, 2015 at 09:00 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Nov 23, 2015 at 05:03 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Nov 23, 2015 at 05:03 AM
Related:
- Transfer Data IF....
- Free fire transfer - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- Ssh secure file transfer client download - Download - Remote access
- Gta 5 data download for pc - Download - Action and adventure
2 responses
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Nov 23, 2015 at 03:57 AM
Nov 23, 2015 at 03:57 AM
Hello MT,
Perhaps a BeforeDoubleClick event code will do the job for you as follows:-
Just double click on any Athlete's name in Column B and the relevant row of data will be transferred to that Athlete's work sheet.
Following is a link to my test work book for you to peruse:-
https://www.dropbox.com/s/ddeuv3a4klorigf/MT.xlsm?dl=0
Just double click on any name in Column B to see it work.
The code also deletes the "used" data from the Master sheet once it is transferred to the individual sheet.
This code needs to go into the sheet module so to implement the code, right click on the Master sheet tab and then select "view code". In the big white field that appears, paste the above code. Go back to the Master sheet and double click away!
Let us know if this works for you.
Cheerio,
vcoolio.
Perhaps a BeforeDoubleClick event code will do the job for you as follows:-
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Application.ScreenUpdating = False If Intersect(Target, Columns("B:B")) Is Nothing Then Exit Sub Target.EntireRow.Copy Sheets(Target.Value).Range("A" & Rows.Count).End(3)(2) Sheets(Target.Value).Select Sheets(Target.Value).Columns.AutoFit Target.EntireRow.Delete Application.ScreenUpdating = True Application.CutCopyMode = False End Sub
Just double click on any Athlete's name in Column B and the relevant row of data will be transferred to that Athlete's work sheet.
Following is a link to my test work book for you to peruse:-
https://www.dropbox.com/s/ddeuv3a4klorigf/MT.xlsm?dl=0
Just double click on any name in Column B to see it work.
The code also deletes the "used" data from the Master sheet once it is transferred to the individual sheet.
This code needs to go into the sheet module so to implement the code, right click on the Master sheet tab and then select "view code". In the big white field that appears, paste the above code. Go back to the Master sheet and double click away!
Let us know if this works for you.
Cheerio,
vcoolio.
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
Nov 23, 2015 at 05:03 AM
Nov 23, 2015 at 05:03 AM
Hello MT,
Just remove line no. 11 from the code. The Master sheet is going to become extremely large!
I don't have any experience with Macs but I believe that Excel still operates as per a normal PC.
Cheerio,
vcoolio.
Just remove line no. 11 from the code. The Master sheet is going to become extremely large!
I don't have any experience with Macs but I believe that Excel still operates as per a normal PC.
Cheerio,
vcoolio.
Nov 23, 2015 at 04:36 AM
EDIT: I'm working Mac if that makes any difference.