I would like to scan a column of data (A6:A10,000) and for any Row that has a value in column A, copy the formatting from the current row cells F & G, and paste that formatting in the same current row, cells H & I. Thanks for any help.
I would like to scan a column of data (A6:A10,000) and for any Row that has a value in column A, copy the formatting from the current row cells F & G, and paste that formatting in the same current row, cells H & I. Thanks for any help.
See if this works for you:
HTH,![]()
Please Login or Register to view this content.
Jason
Perfect, thanks.
Hello mashley,
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks