+ Reply to Thread
Results 1 to 7 of 7

Copy and Paste Based on Criteria

  1. #1
    Registered User
    Join Date
    03-21-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    90

    Copy and Paste Based on Criteria

    I have a attached a spreadsheet that contains tab OM and Summary. The OM sheet has a drop down that lets the user select the scope. Then in cells C2:M2 are if statements based on the scope that is selected from the drop down in B3. I will like to know how to get the related items on Summary to paste under the correct headings in C2:M2. For example, if the user select Full O&M then under C2 all the items from the summary tab will be list in regards to C2 and B3 and so forth for the other columns.
    Attached Files Attached Files

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Copy and Paste Based on Criteria

    Your dropdown in B3 doesnt seem to work.

    Nevertheless, can you specify what needs to go in C2:M2? There is so much data available in the Summary tab that its tough to understand what should go there.

  3. #3
    Registered User
    Join Date
    03-21-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    90

    Re: Copy and Paste Based on Criteria

    Okay would it be better if I organize the data on the Summary tab like colums A-J? I uploaded the spreadsheet again.

  4. #4
    Registered User
    Join Date
    03-21-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    90

    Re: Copy and Paste Based on Criteria

    Here is the file again I changed the columns A-J on the Summary Tab and the dropdown should be working fine now.
    Attached Files Attached Files

  5. #5
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Copy and Paste Based on Criteria

    Just to understand the requirement clearly, incase i select Full O&M from the dropdown, and Operations Services appears in cell C2, should the values from sheet - Summary, Column B rows 2 to 8 appear in column C? Likewise, rows 8 to 15 in column C?

  6. #6
    Registered User
    Join Date
    03-21-2010
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    90

    Re: Copy and Paste Based on Criteria

    Yes if Full O&M from the dropdown, and Operations Services appears in cell C2 then values from Summary, Column B rows 2 to 8 appear in O&M tab Column C...and values from Summary, Column B rows 9 to 16 appear in O&M tab Column E and so on. Is this possible to do?

  7. #7
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Copy and Paste Based on Criteria

    I'd suggest to organize the data in sheet 'summary' in the same way you want them presented in the input sheet.
    e.g. for the first option:
    in sheet 'summary' in column A the option and the data in a 'currentregion' .
    So the only thing you have to do is

    Please Login or Register  to view this content.
    NB. if values are your only concern you'd better not copy/paste.



+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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