Need some help......I hope this can be done!!
I have a worksheet that has certain cell, to the right of data, that has been formatted with a Yellow (color #65535) background. I would like to move the data to the first cell to the right of it that has the Yellow background.
Thanks in advance for your suggestions.
Could you post an example worksheet with a brief before and after?
I'm fairly certain its possible I just want to be sure about the details.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
For example, lets say cell A5 has data in it. To the right of it, maybe cell A10, is formatted with a Yellow background. I would like the code to recognize cell A10 and move the data from A5 into it.
Thanks !!
A10 is actually below it, not to the right of it. Did you mean J5? Will they always be separated by 10 columns? Do you want it to check every row in A for a yellow column to the right? There are a lot of details to go through. Thats why I thought a before and after example might be helpful.
Sorry.......I meant J10. Not always separated by the same number of columns. I hope that isn't a problem)
I just thought of something.......so simple but effective as long as there are no formatted cells between the cell containing the data and the cell to the right of it with the yellow background. Hey it works
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