Hi all,
Could you please help me with the macro for this task, see attached fil.
I want to copy the values in column B based on the value of column C (1, 2, and 3) into three separated columns in another sheet (i.e., Red = 1, Yellow = 2, and Green = 3).
Thank you very much.
Best,
t
Put the macro i your module1. you did mean columns 3 & 4 right?
Please Login or Register to view this content.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
Check if this is what you want:
Just note that I changed the following:Please Login or Register to view this content.to copying the values in column C based on the value of column D, because of the way your sample workbook was. You can change that to meet your original request by changing the 4 in red to a 3 and all the 3s in blue to 2.I want to copy the values in column B based on the value of column C (1, 2, and 3) into three separated columns in another sheet (i.e., Red = 1, Yellow = 2, and Green = 3).
.?*??)
`?.???.?*??)?.?*?)
(?.?? (?.?Pichingualas <---
??????????????????????????
Wrap your code with CODE TAGS.
Thank those who helped you, Don't forget to add to their REPUTATION!!! (click on the star below their post).
Please mark your threads as [SOLVED] when they are (Thread Tools->Mark thread as Solved).
Thanks GeneralDisarray and Pichingualas.
Yes, I meant collum 3(C) and 4(D).
Both codes work great for me. However, I have another function (i.e., scroll bar) that change the value of column 4(D) in real time. I found that every time I run the code, the macro adds values (to the columns Red, Yellow, and Green) rather delete the previous values and copy the new ones to the columns.
Is there a way to do this? Thanks a lot again.
t
This should do it:
Please Login or Register to view this content.
Awesome. Thanks Pichingualas.
Sorry for asking a lot but Is there a way that I can automate this macro so that every time I change the value from the scroll bar, there worksheet update itself automatically?
You can call this macro at the end of the code of the other one. I think that's the best approach for what you want. Just type "Call TryWithThis" at the end of your other macro.
Please Login or Register to view this content.
Hi Pichingualas,
I am using two Active X Controls Toolbars to change column D (1, 2, and 3). I linked the macro with the following code but it does not work. Please let me know what is wrong with this code. Thanks
Please Login or Register to view this content.
Make TryWithThis a Public macro:
I think that should be it.Please Login or Register to view this content.
I mean, change the first line of the TryWithThis macro to what I typed in the previous post.
Awesome. Thank you so very much!
Glad to help
Yeap. After working with these code for sometime, I learned somethingOriginally Posted by Pichingualas
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks