Hello,
i would like to compare two cells in a sheet, and if it's equal then copy other cells into a new row. But i am new in excel programming, and i cant do that. Can you help me?
Forexample
i have data in A4 and A5 and A6 ...etc
if i write in b4 the same as a4, then copy a8...a12 into b8...b12
What if b5=a5, which rows should be copied?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
left out: i need a macro for it
Hi
this code will make what you described but You should give us more details (any sample?)
Please Login or Register to view this content.
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
it's working, but it's paste the range, when i delete b4
(sorry if i made mistakes but i am not so good in english)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks