+ Reply to Thread
Results 1 to 2 of 2

Copying Rows Based On Inputted Responses

  1. #1
    Registered User
    Join Date
    03-13-2016
    Location
    England
    MS-Off Ver
    Mac 2011
    Posts
    1

    Copying Rows Based On Inputted Responses

    Hi, first time poster.

    I am using Excel for Mac 2011.

    I carry out electrical safety tests have a summer worksheet where I record the items I've test and whether they've passed or failed the test. I currently just filter the passes and fails and copy them into different worksheets so that I can produce the required reports. This was fine while I was only doing a few, but I am not doing hundreds and this copy and pasting and manipulating is time consuming (not all of the data from the first worksheet needs to be copied).

    My summary workbook has 10 columns, with one of them being Pass/Fail (a drop down box in column I). If an item passes, I would like some of the information to be copied to the pass worksheet and the same for the fails. My data entry starts at row 4 and I have formatted down to row 500 (for the drop down menus etc).

    I understand that a solution could be possible using Macro, but I am not overly confident in using these, and I think doing it on a Mac complicates things further.

    Does anyone have any advice on how I could format this?

    Thank you for your time.

  2. #2
    Forum Guru mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,206

    Re: Copying Rows Based On Inputted Responses

    Have you looked at AutoFilter?
    If you filter column I on PASS, select everything that you see and paste it to the PassSheet, only the Pass rows will be copied.

    Macros work fine on a Mac. That's what I use.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

+ 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] Macro for copying rows in sheet1 to end of existing rows in sheet2 based on criteria
    By Karl Gustaf Karsten in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-22-2015, 04:19 AM
  2. Insert number of user inputted rows without copying pre-existing data
    By KT99 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2014, 02:55 PM
  3. Progress Meter based on yes/no responses
    By dellcoupon in forum Excel General
    Replies: 1
    Last Post: 11-18-2013, 01:37 PM
  4. [SOLVED] Help hiding/unhiding rows based on multiple responses
    By mglitter1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-06-2013, 07:11 PM
  5. Copy rows from a column based on inputted search criteria to another worksheet
    By dale.lebar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-27-2012, 02:17 PM
  6. Summing all rows in a user inputted column
    By NukedWhale in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-02-2009, 07:34 PM
  7. Formula based on number of responses
    By sleah in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-19-2005, 09:33 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1