• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

macro to copy and paste based on certain condition.

D

dev.sutradhar1987

Member
Hi All,


I was looking for a macro which will identify a certain cell suppose "A:A", If the Valeu is "Reschedule" then it will Copy & Paste the entire row in the next empty row of the same sheet with the value in Column "A" as "Reschedule New" and then the Initial row which was copied should move to the next sheet "sheet2" deleting the row from "sheet1".


Could anyone help me
 
Have you tried using the Google Custom Search box at the Top Right of this and every page at Chandoo.org


This question is a fairly common one and you should find a few solutions
 
i know how to get the row to next sheet even i know how to copy paste it in the same row but i am having problem in getting the "Reschedule New" when it should be copy pasted in the same sheet..
 
Cross posted here:

http://chandoo.org/forums/topic/copy-paste-some-selected-cells-of-a-row-on-the-same-sheet-based-on-the-value?replies=5#post-120693
 
You must log in or register to reply here.
Back
Top