Hi !! I was hoping someone could help me...I am a VBA newbie so please forgive me if I asking a super simple question.
I am trying to have my text automatically copy from one column to another based on color of the cell.
The text is in Column I and I would like it to automatically copy to Column T once I manually highlight Column I yellow.
If Column I is NOT highlighted yellow it should NOT copy.
I am using Excel 2010
Thank you.
Hello lparri,
Welcome to the Forum.
The attached sample Workbook offers you various options, without me having to elaborate on Coding and explanations of how it should be done.
Regards.
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 lparri,
I missed your Column i as primary source, so Please just Replace the Code for CopyColrs as shown below;
Please Login or Register to view this content.
Thank you very much.
So should I open the Module on your spreadsheet and copy the code into a Module in my spreadsheet?
Sorry I sent that before I saw your second reply.
Thank you very much for your help.
You are welcome, Glad I could help!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks.
It is customary to give feedback to those that have helped you by clicking on the asterisk (Add Reputation) at the bottom of their post.
Regards.
I wasn't able to get it to work in my spreadsheet but I thank you for your time and help.
Lisa
Hi lparri,
I find that very strange!
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
I hope this helps you.
Hi lparri,
Your Workbook "Before" and "After" examples are very different to you original request.
For instance, your Row/s or others from Row#28 are already colored in yellow from Column A to Column U, that renders the Code null and void.
I'm sorry so in order for that code to work the rest of the sheet needs to be blank or NOT highlighted?? Is that correct?
Only highlight the relevant cells in Column i in Yellow, then it should work.
It is already 2:00 am on my side of the Globe, and I will get back to you A.S.A.P.For now I have to catch up on some sleep.
'Till later
Sorry to torture you !!! Have a good night !!
Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks