Using find within macro
Solved/Closed
Trowa
-
Sep 3, 2010 at 09:28 AM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Sep 29, 2010 at 02:11 AM
aquarelle Posts 7140 Registration date Saturday April 7, 2007 Status Moderator Last seen March 25, 2024 - Sep 29, 2010 at 02:11 AM
Related:
- Using find within macro
- Spell number in excel without macro - Guide
- Macro excel download - Download - Spreadsheets
- Excel macro to create new sheet based on value in cells - Guide
- Run macro on opening workbook - Guide
- Excel vba assign macro to button programmatically - Guide
3 responses
Please let me know if something is unclear with my query.
I have been trying everything I know, with no succes.
If you know how to solve halve the query, please let me know. So I can play around with it.
Best regards,
Trowa
I have been trying everything I know, with no succes.
If you know how to solve halve the query, please let me know. So I can play around with it.
Best regards,
Trowa
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491
Sep 9, 2010 at 03:43 PM
Sep 9, 2010 at 03:43 PM
Hi Trowa,
Could you post a workbook example? And I try to look at it soon as possible.
PS : When will you decide to become an en.kioskea member ? ;)
"Pour trouver une solution à ses problèmes, il faut s'en donner la peine."
Could you post a workbook example? And I try to look at it soon as possible.
PS : When will you decide to become an en.kioskea member ? ;)
"Pour trouver une solution à ses problèmes, il faut s'en donner la peine."
Hi Aquarelle,
Nice to see again.
My workbook may look familiar to you, since you worked on it before.
Here it is: https://authentification.site/files/24190878/Verlofoverzicht_2010.xls
I have used sheet1 and sheet2 in my initial query to keep it simple.
Sheet1 are actually the sheets called Januari, Februari, Maart, April, Mei, Juni, Juli, Augustus, September, Oktober, November, December.
Sheet2 is the sheet called Afwijkende werkroosters.
Membership is coming up, I just didn't thought I would be using it so much.
Kind regards,
Trowa
Nice to see again.
My workbook may look familiar to you, since you worked on it before.
Here it is: https://authentification.site/files/24190878/Verlofoverzicht_2010.xls
I have used sheet1 and sheet2 in my initial query to keep it simple.
Sheet1 are actually the sheets called Januari, Februari, Maart, April, Mei, Juni, Juli, Augustus, September, Oktober, November, December.
Sheet2 is the sheet called Afwijkende werkroosters.
Membership is coming up, I just didn't thought I would be using it so much.
Kind regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Sep 13, 2010 at 08:54 AM
Sep 13, 2010 at 08:54 AM
Silly me, posted a protected workbook.
Here is the unprotected version: https://authentification.site/files/24231893/Kioskea_Verlofoverzicht.xls
Here is the unprotected version: https://authentification.site/files/24231893/Kioskea_Verlofoverzicht.xls
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491
Sep 21, 2010 at 02:44 PM
Sep 21, 2010 at 02:44 PM
Hi Trowa,
I encountered some difficulties but I finished to find something. I did it just for januari sheet.
http://www.cijoint.fr/cjlink.php?file=cj201009/cijn3PXxRM.xls
Look at it and I hope that it will correspond to what you expected.
Maybe someone else could improved the macro to reduce its execution time.
Best regards :)
PS : I forgot to tell you that it is necessary to write name and first name exactly in the same way in every sheets. Otherwise, the macro will not see that they are the same. If you write a comma in a name, write also one on the other sheets.
"Pour trouver une solution à ses problèmes, il faut s'en donner la peine."
I encountered some difficulties but I finished to find something. I did it just for januari sheet.
http://www.cijoint.fr/cjlink.php?file=cj201009/cijn3PXxRM.xls
Look at it and I hope that it will correspond to what you expected.
Maybe someone else could improved the macro to reduce its execution time.
Best regards :)
PS : I forgot to tell you that it is necessary to write name and first name exactly in the same way in every sheets. Otherwise, the macro will not see that they are the same. If you write a comma in a name, write also one on the other sheets.
"Pour trouver une solution à ses problèmes, il faut s'en donner la peine."
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Sep 27, 2010 at 09:40 AM
Sep 27, 2010 at 09:40 AM
Thanks Aquarelle, great code.
Now I'm thinking about when to activate the code. I don't want to bother the end user with to many buttons to click.
When running the code 12 times (one for each month) it takes a few seconds, which is ok if it only happens when nessecary. So I was thinking about a combination between "Sheet deactivate"and "Sheet change".
This because I don't want to run the codes just after checking the sheet "Afwijkende werkroosters" (Sheets deactivate).
Or when making a new entry I have to change 7 cells, then I don't want the code to be activated 7 times (Sheets change).
So do you know a way to run the codes after deactivating the sheet "Afwijkende werkroosters" only when a change has been made in the range of A8:H200?
Let me post my workbook again with the codes for the other months:
https://authentification.site/files/24435036/cijn3PXxRM.xls
Best regards,
Trowa
Now I'm thinking about when to activate the code. I don't want to bother the end user with to many buttons to click.
When running the code 12 times (one for each month) it takes a few seconds, which is ok if it only happens when nessecary. So I was thinking about a combination between "Sheet deactivate"and "Sheet change".
This because I don't want to run the codes just after checking the sheet "Afwijkende werkroosters" (Sheets deactivate).
Or when making a new entry I have to change 7 cells, then I don't want the code to be activated 7 times (Sheets change).
So do you know a way to run the codes after deactivating the sheet "Afwijkende werkroosters" only when a change has been made in the range of A8:H200?
Let me post my workbook again with the codes for the other months:
https://authentification.site/files/24435036/cijn3PXxRM.xls
Best regards,
Trowa
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491
Sep 28, 2010 at 03:56 AM
Sep 28, 2010 at 03:56 AM
Hi Trowa,
I found a solution by putting a message box. Look at it and tell me what do you think about : http://www.cijoint.fr/cjlink.php?file=cj201009/cijnJCcorG.xls
Best regards
I found a solution by putting a message box. Look at it and tell me what do you think about : http://www.cijoint.fr/cjlink.php?file=cj201009/cijnJCcorG.xls
Best regards
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Sep 28, 2010 at 09:16 AM
Sep 28, 2010 at 09:16 AM
Wow Aquarelle, great solution, works like a charm.
Thank for helping me on this query.
See you later,
Trowa
Thank for helping me on this query.
See you later,
Trowa
aquarelle
Posts
7140
Registration date
Saturday April 7, 2007
Status
Moderator
Last seen
March 25, 2024
491
Sep 29, 2010 at 02:11 AM
Sep 29, 2010 at 02:11 AM
Hi,
Always a pleasure to help you when I have time and when I can :)
See you later and have a nice day.
Always a pleasure to help you when I have time and when I can :)
See you later and have a nice day.