+ Reply to Thread
Results 1 to 18 of 18

Copy and paste columns to another sheet based on a criteria

  1. 02-24-2014, 04:17 AM #1
    saya_26
    saya_26 is offline
    Registered User
    Join Date
    02-21-2014
    Location
    Chennai
    MS-Off Ver
    Excel 2013
    Posts
    15

    Copy and paste columns to another sheet based on a criteria

    How do I copy and paste columns from Sheet 1 to Sheet 2 which has the word "To" in its column headers?

    Example, Column H Header = 12/2/2014 To 14/2/2014

    I want to copy only these types of columns and paste it on another sheet.

    P.S. I'm looking for a non-vba solution (if there is one) so any help would be much appreciated.
    Reply With QuoteRegister To Reply
  2. 02-24-2014, 04:24 AM #2
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Copy and paste columns to another sheet based on a criteria

    Perhaps.

    In A2 of sheet2 and copy down and across.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  3. 02-24-2014, 04:45 AM #3
    saya_26
    saya_26 is offline
    Registered User
    Join Date
    02-21-2014
    Location
    Chennai
    MS-Off Ver
    Excel 2013
    Posts
    15

    Re: Copy and paste columns to another sheet based on a criteria

    Thanks for your reply.

    It doesn't work though. I get nothing except the formula in A1.
    Reply With QuoteRegister To Reply
  4. 02-24-2014, 04:50 AM #4
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Copy and paste columns to another sheet based on a criteria

    Quote Originally Posted by saya_26 View Post
    . I get nothing except the formula in A1.
    Not possible! Pls upload a small sample workbook.
    Reply With QuoteRegister To Reply
  5. 02-24-2014, 05:04 AM #5
    saya_26
    saya_26 is offline
    Registered User
    Join Date
    02-21-2014
    Location
    Chennai
    MS-Off Ver
    Excel 2013
    Posts
    15

    Re: Copy and paste columns to another sheet based on a criteria

    Here you go
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 02-24-2014, 05:12 AM #6
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Copy and paste columns to another sheet based on a criteria

    Here you go
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 02-24-2014, 06:36 AM #7
    saya_26
    saya_26 is offline
    Registered User
    Join Date
    02-21-2014
    Location
    Chennai
    MS-Off Ver
    Excel 2013
    Posts
    15

    Re: Copy and paste columns to another sheet based on a criteria

    Can you please recheck the file you've sent?
    Reply With QuoteRegister To Reply
  8. 02-24-2014, 06:37 AM #8
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Copy and paste columns to another sheet based on a criteria

    Why to do this?
    Reply With QuoteRegister To Reply
  9. 02-24-2014, 06:40 AM #9
    saya_26
    saya_26 is offline
    Registered User
    Join Date
    02-21-2014
    Location
    Chennai
    MS-Off Ver
    Excel 2013
    Posts
    15

    Re: Copy and paste columns to another sheet based on a criteria

    It doesn't seem to be the right one ^ ^
    Reply With QuoteRegister To Reply
  10. 02-24-2014, 06:42 AM #10
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Copy and paste columns to another sheet based on a criteria

    This makes no sense to me.

    Good luck
    Reply With QuoteRegister To Reply
  11. 02-24-2014, 11:29 AM #11
    Indi_Ra
    Indi_Ra is offline
    Banned User!
    Join Date
    10-29-2012
    Location
    Europe
    MS-Off Ver
    2013, 2016
    Posts
    318

    Re: Copy and paste columns to another sheet based on a criteria

    Quote Originally Posted by Fotis1991 View Post
    Why to do this?
    Because you upload a file that has no connection to the file posted by op, and OP requirement.
    Reply With QuoteRegister To Reply
  12. 02-24-2014, 11:49 AM #12
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Copy and paste columns to another sheet based on a criteria

    ...Because you upload a file that has no connection to the file posted by op, and OP requirement.
    Thanks for the explanations. My mistake and really apologize for this.

    The other comments in your report post about .."A response of a conceited man" is something that does not concern me. Anyone of us has his own history in this forum.

    So i would like to ask for you to be more careful with your words.

    saya_26

    This is the ok sample workbook.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  13. 02-24-2014, 11:52 AM #13
    Indi_Ra
    Indi_Ra is offline
    Banned User!
    Join Date
    10-29-2012
    Location
    Europe
    MS-Off Ver
    2013, 2016
    Posts
    318

    Re: Copy and paste columns to another sheet based on a criteria

    Hi,

    Put this formula in Sheet2 in what column you want and "drag" down.

    =INDEX(Sheet1!$A$1:$U$21,,MATCH("*TO*",Sheet1!$1:$1,0))
    Reply With QuoteRegister To Reply
  14. 02-24-2014, 12:03 PM #14
    Indi_Ra
    Indi_Ra is offline
    Banned User!
    Join Date
    10-29-2012
    Location
    Europe
    MS-Off Ver
    2013, 2016
    Posts
    318

    Re: Copy and paste columns to another sheet based on a criteria

    Anyone of us has his own history in this forum.
    What can I say....

    How did you qualify your answers by reading posts 7, 8, 9 and 10.
    And I said what I said because I've seen many times "acid" answers from you, especially when you're moderator.
    Reply With QuoteRegister To Reply
  15. 02-24-2014, 12:10 PM #15
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Copy and paste columns to another sheet based on a criteria

    What can i say...This is your opinion...And as Voltaire said:


    "I do not agree with what you have to say, but I'll defend to the death your right to say it."

    Good luck.
    Reply With QuoteRegister To Reply
  16. 02-24-2014, 12:15 PM #16
    saya_26
    saya_26 is offline
    Registered User
    Join Date
    02-21-2014
    Location
    Chennai
    MS-Off Ver
    Excel 2013
    Posts
    15

    Re: Copy and paste columns to another sheet based on a criteria

    Both formulas work great.. Thanks a lot guys!

    Really appreciate it
    Reply With QuoteRegister To Reply
  17. 02-24-2014, 12:20 PM #17
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Copy and paste columns to another sheet based on a criteria

    Quote Originally Posted by saya_26 View Post
    Both formulas work great.. Thanks a lot guys!

    Really appreciate it
    You are welcome and thanks for the feed back.

    Again i apologize for my mistake!
    Reply With QuoteRegister To Reply
  18. 02-24-2014, 12:23 PM #18
    saya_26
    saya_26 is offline
    Registered User
    Join Date
    02-21-2014
    Location
    Chennai
    MS-Off Ver
    Excel 2013
    Posts
    15

    Re: Copy and paste columns to another sheet based on a criteria

    Quote Originally Posted by Fotis1991 View Post
    Again i apologize for my mistake!
    No worries.. ^ ^
    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. [SOLVED] Copy/Paste a column in a new sheet based on a criteria
    By Elorac in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-19-2013, 02:01 PM
  2. [SOLVED] Copy/Paste multiple columns as values based on another columns criteria
    By Dgp2012 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-28-2013, 06:50 AM
  3. Copy and Paste Rows based on Criteria onto another sheet and sort based on oldest item
    By Kushal8684 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2013, 05:37 AM
  4. [SOLVED] Copy and paste data from sheet 2 to sheet 1 based on specific criteria on sheet 1
    By VBADUD in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 04:18 AM
  5. Copy and Paste and Delete Columns Based on Criteria
    By datalogger in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-21-2010, 01:07 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