Hello
I am trying to compare row A to row C and if they match cut the value from row B and paste it in row d. if the Value. If they do not match shift Column A and B down one row, and continue checking until it has gone through all the data.
Any help would be appreciated
ben,
The following code will compare column a to column c and if it matches move column b data to column d.
It does not insert extra row. Do you really want to do that?
Please Login or Register to view this content.
Charles
There are other ways to do this, this is but 1 !
Be Sure you thank those who helped.
IF YOU'RE SATISFIED BY ANY MEMBERS RESPONSE TO YOUR ISSUE PLEASE USE THE STAR ICON AT THE BOTTOM LEFT OF THE POST UNDER THEIR NAME.
Hello
I want to Copy rows 1 and 2 down so that A and C become equal. then the macro can carry on
ben5496,
Are you saying
If Column A has 21 and column C has 22 ( same row) you want column A to insert a row and then enter 22 in column A?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks