+ Reply to Thread
Results 1 to 5 of 5

Copy paste Shaded Cells on New Sheet

  1. #1
    Registered User
    Join Date
    06-13-2017
    Location
    GREECE
    MS-Off Ver
    2010
    Posts
    3

    Copy paste Shaded Cells on New Sheet

    Hello

    This is probably easy but I am total noob in VBA and would appreciate your help.
    I have a sheet1 (Visits) and sheet2 (Report List) in a workbook.
    In Visits I keep some activities on rows. When an activity takes place I manually shade a specific cell in row 2, another one or two in row 3 and another 2-3 in row 4.
    I would want to automatically copy shaded cells from all rows to one single row side by side at Report List. Only shaded cells, with contents (text).

    Can you please help?

    Thanks

    DsF

    PS. This is my first post here, so please be gentle to me

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    7,857

    Re: Copy paste Shaded Cells on New Sheet

    can (probably) be relatively easily done, but please attach sample file to work on:

    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.
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    06-13-2017
    Location
    GREECE
    MS-Off Ver
    2010
    Posts
    3

    Re: Copy paste Shaded Cells on New Sheet

    Thanks for your reply.
    Attached my sample file, the first bunch of data marked in Yellow is copied from "Visits" to "Report List".
    Want to automate this for all reports in "Visits".

    Let me know if something is not clear enough.

    Cheers
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    06-13-2017
    Location
    GREECE
    MS-Off Ver
    2010
    Posts
    3

    Re: Copy paste Shaded Cells on New Sheet

    Hello

    Can anyone help?

    Thanks

  5. #5
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    7,857

    Re: Copy paste Shaded Cells on New Sheet

    Have a look on attached file and the macro (inside it):
    Please Login or Register  to view this content.
    Attached Files Attached Files

+ 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 and Paste only filled cells from a dynamic range to another sheet in empty cells
    By seanpcorbett1 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-12-2016, 03:23 PM
  2. [SOLVED] Command button to copy cells from one sheet and paste in second sheet
    By waratdenison in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-22-2014, 02:53 PM
  3. Copy diff cells of a sheet & paste in a NEW row below previously filld rows of other sheet
    By shubhashishdubey in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2014, 12:36 AM
  4. VBA Copy from one sheet and paste two cells to the right from active cell on another sheet
    By pasqualebaldi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-10-2013, 01:16 PM
  5. Copy data from a sheet and Paste in another sheet into Merged cells
    By acsishere in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2011, 02:01 PM
  6. copy/paste cells into another sheet
    By reggie1000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-18-2009, 07:45 AM
  7. [SOLVED] Shaded cells on a worksheet but do not show up on printed copy?
    By Deborah Kinney in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-06-2006, 05:25 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