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.
