+ Reply to Thread
Results 1 to 2 of 2

How to skip a column while paste values?

  1. 10-07-2014, 02:37 PM #1
    yug
    yug is offline
    Registered User
    Join Date
    10-07-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    1

    How to skip a column while paste values?

    I have copied values from cells and now i am trying to paste the values into range of cells.

    But i want to skip column while paste the values.

    This is what i tried but I need to skip a clumn.

    Please Login or Register  to view this content.
    I need the output as shown in below format


    ExcelQuestion.jpg
    Last edited by JBeaucaire; 10-07-2014 at 03:09 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.
    Reply With QuoteRegister To Reply
  2. 10-07-2014, 03:38 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: How to skip a column while paste values?

    Maybe:

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Skip trying to paste over locked cells when pasting over a whole column
    By Rzzberry1105 in forum Excel General
    Replies: 1
    Last Post: 08-23-2013, 03:35 PM
  2. [SOLVED] How to skip an entire column when copy pasting from another sheet
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-21-2013, 01:25 PM
  3. skip blank rows when pasting formulas
    By Newsgal in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  4. [SOLVED] skip blank rows when pasting formulas
    By Newsgal in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 07:05 AM
  5. skip blank rows when pasting formulas
    By Newsgal in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1