transfer data of a complete row if certain criteria completed
I have one sheet with many information of clients. I want to transfer data of a client he accept our offer. suppose If he accept our offer and then we enter accepted in row then on this acceptance base complete data of that client transfer to acceptance sheet. please help me
Sure, you will need to give more information.
How about attaching a sample file with dummy information?
To Attach a File:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.
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]
Hi hriazm. Place the following code into the code module for your worksheet (not into a regular module). I am assuming that you will enter "Accepted" in column A. Change the range in the code (Range("A:A") to suit your needs. Once your enter "Accepted", the row will be copied to sheet "Accepted".
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks