Hi
I Need Macro Automatically Past Yes Of Cell J To Cell K
If Cell J Change to yes
And When Change Cell J to Yes Past Cell D to cell L
TEST9.jpg
http://www.2shared.com/file/pBaU8RK-/book1.html
Hi
I Need Macro Automatically Past Yes Of Cell J To Cell K
If Cell J Change to yes
And When Change Cell J to Yes Past Cell D to cell L
TEST9.jpg
http://www.2shared.com/file/pBaU8RK-/book1.html
Last edited by etheer; 11-11-2012 at 05:53 PM.
Hello etheer,
Why a Macro, if you could do it with formulas as per the attached WorkBook?
Also see the "Please consider" note at the bottom of this post.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hi Winon
Thank you
but i need macro because i want when change cell J again no do not delete yes and number from cell K and L
plaese help me if you can
Hi etheer,
But you do say in your first post;
Maybe we have a misunderstanding here?And When Change Cell J to Yes Past Cell D to cell L
I have entered the formulas on your spreadsheet, See if it is acceptable now.
Thank you so much for your help Winon
but if change cell J no delete yes and number from cell K and L
i need when past yes and number in cell K and L do not delete
i get this macro
maybe you can edit it for workPlease Login or Register to view this content.
Last edited by etheer; 11-11-2012 at 08:42 PM.
My problems
1-When cell J change to no delete yes and number from cell K and L
2- When i change in in cell F,G,H change cell J to yes but do not past yes and number in cell K and L
I hope you can help me Winon
i get this code but not work 100%
Please Login or Register to view this content.
Hi etheer,
O.K. Let us try this one. It is still using formulas, but retain the values as long as the Cell/s in Column D has some data.
If you prefer the alternative code then copy this Code over mine.
Just remember that with any one of the two solutions you have now, the code will only work in the Row where you change any cell in Column D.
Please Login or Register to view this content.
I wait someone help me
Have you tried the WorkBook in Post no. 9? Or the code in Post no. 10? If you tell us what you don't like about it, then maybe someone help you.
Hi
I found code work very good but i need edit it with this sheet
Please help me
http://www.2shared.com/file/p4jlW0Rl/Book1.html
If you like that Code, then based on the Sample WorkBook in Post Number 9, use it like this:
Hope that helps.Please Login or Register to view this content.
Last edited by Winon; 11-13-2012 at 02:25 AM. Reason: Check the correct Sample WorkBook
Thank you so much winon yes work code very good
but i edit
If Not Intersect(Target, Range("H:F")) Is Nothing Then
TO
If Not Intersect(Target, Range("M:N:O:P")) Is Nothing Then
And i used formula in cell J
=IF(AND(M7>=50%;N7>50%;O7>0%;P7>-30%;F7>0.2;X7<10%;Y7<10%);"Yes";"No")
good ?
Hello etheer,
You can change this line:
toIf Not Intersect(Target, Range("M:N:O:P")) Is Nothing Then
or to any other Range which you would like the Code to respond to, when you change any Data.If Not Intersect(Target, Range("M:P")) Is Nothing Then
Your Formula in Column J has no effect on the "Intersect Target Range".
Last edited by Winon; 11-13-2012 at 01:06 PM. Reason: Sentence structure
Winon i have ask
I can found code or edit code delete yes and number every new month
Impossible ?
No it is not Impossible,
What do you want to delete? Make sample and show me.
I have problem in code when i change manual in cell H:F
work code very good but i take data from website if change data in cell H:F not work code
i want cry please help me
Please Login or Register to view this content.
Please test this sheet when i change in sheet M2 not work code
Hello etheer,
Use this Code:
Also see "Please consider" at bottom of this post.Please Login or Register to view this content.
Thank you winon
You can edit code no need cell F:H,M:P
My problem now if used keybored and change in cell work code very good but when i take data online and change cell J to yes do not work code
Then try it like this:
Please Login or Register to view this content.
Hello etheer,
Did you try the Code as per my last post?
Thank you winon i test code but also not work
If used keybored in sheet 1 and click enter work code
If data change automatic and change J to yes not work code
I do not want to connect sheet with sheet in code
I know you're tired trying to help me thank you so much winon
i change line
Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range
TO
Private Sub Worksheet_Calculate()
Dim c As Range
I hope now work good
I was thinking about the calculate aspect as well.
So try this:
Please Login or Register to view this content.
I edit code to
Please Login or Register to view this content.
work code 100% i have only one problem
when change any cell to #N/A code work crazy and past yes and number in all cells
how edit code not work if cells #N/A
Last edited by etheer; 11-19-2012 at 03:55 PM.
Hi etheer,
Sorry, but I was away on renovating a house. Please try this formula in Column J with my sample code as per Post No. 28.
Please Login or Register to view this content.
Last edited by Winon; 11-23-2012 at 12:07 PM. Reason: Forgot to add the formula.:(
Hi Winon
I have ask
Please Login or Register to view this content.
can edit code if cell AD change to No
change
To past ValuePlease Login or Register to view this content.
Hello etheer,
Have you changed your Workbook layout?
I am totally confused with you referencing Column I which is Empty, and where does Column "AD" come from now, or do you actually mean Columns A & D?
Maybe it would be better if you upload your "New" sample WorkBook again so that we can have a look at it for you.
Hi Winon
Why only code works when the show sheet if hidden or do not show it the code does not work
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks