Hi,
I would like a worksheet macro that does the following:
- Looks at the number values in B6:B506 in the current sheet
- Compares them to the number values in Sheet1 in cells A2:A506
- If the numbers match and the corresponding cell on the same row (F2:F506) does NOT equal "On Course"
- Then copy that cell value and place it AS A COMMENT in the matching ID cell (B6:B506) in the current sheet.
Hopefully the attachment makes it easier to understand.
Comment Query.xlsx
Any help appreciated.
Look at for next loops on google for intRow =2 to 506 and look at adding comments on google.
also you're comparing a 500 row range to a 504 row range
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Try placing this in your workbook module
Please Login or Register to view this content.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks