12345678910
12345678910
Last edited by Dremzy; 04-23-2014 at 08:14 AM.
Hi,
The code below should do what you need. It is connected to the change event on each sheet, so all you have to do is type "Complete" or "Delete in the "G" column and the data will transfer. See the sample workbook for details...
Please Login or Register to view this content.
Regards,
Rudi
Copy and paste this macro into the worksheet code module. Do the following: right click the tab for your Sheet1 and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet.
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
12345678910
Last edited by Dremzy; 04-23-2014 at 08:14 AM.
Hi,
See the sample workbook I sent.
Each sheet (Sheet 1, 2, 3) has the same code in its Sheet_Change Event handler.
To see the code, right click the sheet tab and select View Code.
It does not of course reside on the Complete or Delete Sheets!
12345678910
Last edited by Dremzy; 04-23-2014 at 08:14 AM.
Hi,
Try this...
Please Login or Register to view this content.
12345678910
Last edited by Dremzy; 04-23-2014 at 08:15 AM.
12345678910
Last edited by Dremzy; 04-23-2014 at 08:15 AM.
Need help
Hi,
Just have some guests over...
I'll have a look into this when I get a moment
12345678910
Last edited by Dremzy; 04-23-2014 at 08:15 AM.
Hi,
I cannot seem to simulate your error.
Besides, it seems strange as the code is set to only trigger if specific conditions are met.
If you are still having the issue, could you send the workbook to me as well as the steps that you are taking to cause the error. Then I can test and try identify the cause. If data is sensitive, just delete it or replace with dummy data.
TX
12345678910
Last edited by Dremzy; 04-23-2014 at 08:15 AM.
Hi,
I updated the event handlers to avoid the excessive prompting. See if it is working better now.
Please check thoroughly.
TX
12345678910
Last edited by Dremzy; 04-23-2014 at 08:12 AM.
12345678910
Last edited by Dremzy; 04-23-2014 at 08:12 AM.
Actually I didn't change much.
I noticed that the code was triggering (as you said) when you copied data manually. This of course does change the intersected cell between column G and the target row, BUT the target cell (when you paste is in the A column, not the G column)
I changed these lines from this:
To this:Please Login or Register to view this content.
When you paste the target has several cells, so the ".cells(1)" ensures that ONLY the cell intersecting Target and Column G is evaluated.Please Login or Register to view this content.
Hope that makes sense.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks