+ Reply to Thread
Results 1 to 4 of 4

Copy cell that next to color cell to another sheet

  1. #1
    Registered User
    Join Date
    10-18-2020
    Location
    Hong Kong
    MS-Off Ver
    MS 2010
    Posts
    8

    Copy cell that next to color cell to another sheet

    Hi all, I would like to copy Sheet 1's Cells(i,1), Cells(i,3) and Cells(i,4) in text format to Sheet 2, if Sheet 1's Cells(i,6) is color cell. The Sheet 1's Cells(i,1), Cells(i,3) and Cells(i,4) will become Sheet 2's Cells(i,1), Cells(i,2) and Cells(i,3). I tried to turn this into VBA, but seems it doesn't work, please help.

    Please Login or Register  to view this content.
    I have also attached the data and expected output here. Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,080

    Re: Copy cell that next to color cell to another sheet

    Try:
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Registered User
    Join Date
    10-18-2020
    Location
    Hong Kong
    MS-Off Ver
    MS 2010
    Posts
    8

    Re: Copy cell that next to color cell to another sheet

    Thanks a lot! It works perfectly.
    Last edited by babyfufu; 10-21-2020 at 02:27 AM.

  4. #4
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,080

    Re: Copy cell that next to color cell to another sheet

    You are very welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy Formula value and cell color from one sheet to another
    By Xiiharu in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-03-2020, 01:18 PM
  2. User defined function to copy the cell color to another cell (actual painting the color)
    By sumitgangwani in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-15-2017, 04:14 PM
  3. [SOLVED] Copy color from conditionally formatted cell on one sheet to a different sheet cell
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-21-2015, 03:47 PM
  4. Copy a row from one sheet to another based on the color of a cell
    By Data2link in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2013, 05:36 PM
  5. [SOLVED] Check value and copy the color to a new sheet's cell
    By rmachbitz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-15-2013, 10:49 PM
  6. [SOLVED] Copy Cell.Font.Color from Sheet A to corresponding Sheet B
    By chelseasikoebs in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-09-2013, 12:30 AM
  7. Replies: 0
    Last Post: 06-15-2012, 04:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1