Please check the data ranges you provided and it will not activate the sheet it will run for all sheets in the workbook.
On Monday, 7 January 2013 23:43:51 UTC+5:30, Best Of Luck wrote: > > Thank you Lalit, > The macros is running but does not select the activesheet and does not > insert a comment in cell that already have a value in the target cell. > > On Thursday, January 3, 2013 2:53:00 AM UTC-6, Best Of Luck wrote: > >> hi, >> Happy new year, >> >> I need a macro that would copy cells based upon values in other cells. >> I am using Excel 10. >> I have a worksbook that has about 20 worksheets in it. Each of these >> worksheets has 2 columns A8:A108 & B8:B108.. I want a macro that would do >> the following: >> >> 1. Select the activesheet & read the values in the source columns >> B8:B108 and if there are no corrosponding values in the target columns >> A8:A108 to copy cells from the source B8:B108 to target A8:A108 and >> clear the contents of source cells B8:B108 . >> 2. But if there are values in the target cells A8:A108 to leave the >> values in those cells alone and still clear the contents of source cells >> B8:B108 but Insert a comment saying "Old File" in the corrosponding >> target cells A8:A108 . >> >> >> >> Both source cells B8:B108 & target cells A8:A108 are formated as text, >> >> thanks... >> > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
