+ Reply to Thread
Results 1 to 9 of 9

copy selected cells from a column while excluding others

  1. #1
    Forum Contributor
    Join Date
    04-04-2016
    Location
    dallas tx
    MS-Off Ver
    2013 (15.0.5501.1000)
    Posts
    493

    copy selected cells from a column while excluding others

    I am working with a time study program that allows me to export the information I gather into excel. The Problem is that the software displays the content in such a way that it is difficult to populate the proper template i created with the information it needs. Below is a image showing the information I need. the time information contained in the rows for the unloading staging cycle need to be copied from this document and placed in a column on my template.
    06.jpg
    the problem is that there are rows with information that i do need in parts of the template but not in the same column as the unloading time information.
    05.jpg
    Is there a formula that will allow me to grab what I need and leave the rest?

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    24,802

    Re: copy selected cells from a column while excluding others

    Please post a sample workbook showing expected output.

    to upload a file, click "Go advanced" then scroll down to "Manage Attachments": click on to start upload process

  3. #3
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,340

    Re: copy selected cells from a column while excluding others

    Attaching a sample workbook enables others to work on your problem:

    To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    To add a file to a post

  4. #4
    Forum Contributor
    Join Date
    04-04-2016
    Location
    dallas tx
    MS-Off Ver
    2013 (15.0.5501.1000)
    Posts
    493

    Re: copy selected cells from a column while excluding others

    I inserted some images and thought that was good but here you go.
    Attached Files Attached Files

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    15,027

    Re: copy selected cells from a column while excluding others

    It looks as if you want the times transferred to Sheet2 in the Stage Material Start and Stop columns, however that is just a guess. It would help us to help you if you would add EXPECTED results to the uploaded file based on the information that is on the 'data imported from data report' sheet. It would also help to know HOW you come up with the expected results.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  6. #6
    Forum Contributor
    Join Date
    04-04-2016
    Location
    dallas tx
    MS-Off Ver
    2013 (15.0.5501.1000)
    Posts
    493

    Re: copy selected cells from a column while excluding others

    this is what I need
    On the imported from data report tab in the sample book every time a row contains the words unloading/staging cycle the time in column G needs to be moved to tab "sheet 2" and placed in column B/C. I have highlighted the needed information on both tabs in red.
    In a nut shell I need the times in column G of the "data imported from data report" to be displayed in columns B/C of the sheet 2 report but only if the times are in a row that contains the data "unloading / staging cycle.
    Attached Files Attached Files
    Last edited by chriswrcg; 07-27-2016 at 09:19 AM.

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    15,027

    Re: copy selected cells from a column while excluding others

    Try this array entered formula* in Sheet2!B8 and copied down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    *Array entered formulas are confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Note: They also will not work in merged cells, so in the attachment the format has been changed from merged to 'Center across Selection' (press Ctrl + 1, and from the alignment tab make the choice under 'Text Alignment' > 'Horizontal')
    Let me know if you have any questions.
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    04-04-2016
    Location
    dallas tx
    MS-Off Ver
    2013 (15.0.5501.1000)
    Posts
    493

    Re: copy selected cells from a column while excluding others

    this is close. I am getting the cell on sheet 2 populated by a time from column G on the data imported from data report tab but not the one I need. it is giving me 7:07:20 which is in row 1 "start cycle" instead of row 3 "Unloading / staging cycle". The first time it should show is 7:12:52.

    As I copy the formula down sheet 2 column B it needs to add the times from column G in ascending order. Right now it just copies 7:07:20 all down the column.

  9. #9
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    15,027

    Re: copy selected cells from a column while excluding others

    After un-merging B8 and C8 paste the formula into B8, press the F2 key then press Ctrl, Shift and Enter simultaneously. You will need to un-merge B9:C26 before you copy the formula down. The file attached to #7 shows the desired results you describe in post #8.

+ 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 a column of data excluding blank cells to consolodate
    By sipa in forum Excel General
    Replies: 12
    Last Post: 05-04-2020, 11:07 PM
  2. [SOLVED] Macro to copy selected cells and paste them in the same row but in a different column
    By Nirmall in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-23-2016, 08:03 AM
  3. [SOLVED] Need MACRO to copy the text in the cell left of first selected cells (a column), paste all
    By joobeng in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-16-2013, 06:42 AM
  4. [SOLVED] copy selected data into column A cells if column B contains text
    By El Conquistador in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-05-2013, 02:51 PM
  5. averaging selected cells excluding zero
    By bambino86 in forum Excel General
    Replies: 37
    Last Post: 05-18-2009, 02:31 PM
  6. [SOLVED] Excluding selected cells in excel
    By Farhad in forum Excel General
    Replies: 3
    Last Post: 05-29-2006, 03:50 PM
  7. [SOLVED] Macro, Copy Selected Cells Down a Column
    By DB33 in forum Excel General
    Replies: 9
    Last Post: 02-15-2006, 05:35 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