Hi, I need some help on creating a macro to copy and paste the value of a row on 1 worksheet (Open) to another worksheet (Closed), in the same workbook. Once "closed" is entered in column Q the macro should occur. The value of the "closed" row should be pasted to the end of the list in the Closed worksheet, the the row in the Open worksheet shoud then be deleted.
Need Help.xlsm
Last edited by be_bek; 05-21-2012 at 09:53 AM.
Hi be_bek,
See if this code works for you.
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
This does not seem to be working. When I type "Closed" to an item on the Open tab, nothing happens - it remains In the Open tab as "Closed".
Do you run the macro?
Set a breakpoint in the macro above to insure it is hitting the macro.
http://www.cpearson.com/excel/Debug.htm
I get an error in the macro on this line:
Cells(4, "Q").Select
Can you help?
This is the error I get:
Excel Macro Error.png
I'm clueless.
Do you have a full version of Excel? Are you using a Student version? Change the "Q" in the line to 16 and see what happens.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks