+ Reply to Thread
Results 1 to 2 of 2

Copy and paste column with special formatting

Hybrid View

  1. #1
    Registered User
    Join Date
    06-20-2013
    Location
    Bratislava
    MS-Off Ver
    MS EXCEL 2021
    Posts
    90

    Copy and paste column with special formatting

    Hi community

    I know here is many of similar threads, but i would like to solve something different

    I would like to ask for help in this :

    1. I have 3 sheets in my workbook named A, B and C

    2. In sheet A there is column T which i would like to copy and paste it to sheet B, as latest column based on empty value in first row

    3. In sheet A there is column U which i would like to copy and paste it to sheet C, as latest column based on empty value in first row

    --
    *Column T and U which are we copying has some hidden rows which i would like to include in copying ( i am not sure if that is the problem)
    *Column T and U has also conditional formatting (highlighted cells) - i would like to copy paste only this highlight, but not conditional formatting if possible

    If needed i will attach sample test data

    Thanks
    Last edited by xbr088; 03-29-2022 at 03:59 AM.

  2. #2
    Registered User
    Join Date
    06-20-2013
    Location
    Bratislava
    MS-Off Ver
    MS EXCEL 2021
    Posts
    90

    Re: Copy and paste column with special formatting

    Nobody any advice ?

+ 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 Paste Special Using Column Headers
    By phelbin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-28-2016, 02:19 PM
  2. Replies: 2
    Last Post: 12-08-2015, 01:29 AM
  3. column E copy/paste special values
    By ammartino44 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2015, 06:03 PM
  4. [SOLVED] Using the Paste Special - Divide Function, DO NOT want to copy formatting
    By ncowan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-04-2013, 06:53 PM
  5. [SOLVED] Copy Special Paste in the same column
    By iwilli in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2012, 03:38 PM
  6. Replies: 3
    Last Post: 07-20-2006, 02:00 PM
  7. Paste Special Values but keep formatting and column widths
    By drdavidge in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2006, 01:00 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