Hello:
Please refer to attached file.
I have data in Sheet1 as shown. (Note the color in the Sales are due to Conditional formatting).
I need VB Code to copy data A1:F5 from Sheet1 and paste at cell A5 in "Backup" Sheet with the same color and format
but do not need Conditional formatting in Backup sheet.
Need to make sure that i get
Let me know if you have any questions.
Thanks.
Riz
Bookmarks