+ Reply to Thread
Results 1 to 5 of 5

Automatically moving specific rows to new sheet/omitting columns/combining data

  1. #1
    Registered User
    Join Date
    04-05-2011
    Location
    South Carolina
    MS-Off Ver
    Excel 2007
    Posts
    6

    Automatically moving specific rows to new sheet/omitting columns/combining data

    I think I might be approaching the length of my ability. I have been creating a workbook to track the readiness of our employees to travel to other locations. Each employee has to accomplish about 30-40 items to complete thier pre-travel requirements.

    Attached is an example of what I am talking about. Our actual spreadsheet has about 80 names (about 3-20 are added or removed each week), and my superiors are asking me for a product which can, at minimum, be used to report to their superiors.

    Sheet 1 is the full list of people and items in the table.
    Sheet 2 is a blank table of what needs to be shown and an example of exactly what should automatically populate inside the table.

    Thanks for checking it out.
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Automatically moving specific rows to new sheet/omitting columns/combining data

    Hi milChuck

    See the attached. I believe you can filter the arriving date in the table. You can also do a count of Y or N to see how many requriements are needed to travel. If you filter the table and then simply paste it to a second sheet, I believe it will work much better for you than doing code to limit your possibilities. See the attached.

    I guess my answer is - don't do it that way. Use your data in the original table and work with it.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    04-05-2011
    Location
    South Carolina
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Automatically moving specific rows to new sheet/omitting columns/combining data

    Thanks, but my original spreadsheet has about 43 columns of requirements and 29 columns of information we use to track them, and about 15-20 individuals consistently within 45 days of leaving. The main sheet(we call it our whiteboard) has a lot of conditional formatting, and shows if someone is completely ready by turning their name green.

    It isn't hard to navigate, but bosses bosses want to know what people need to accomplish without having to navigate 10 pages (widthwise) of requirements.

    Most people only need 3 or 4 requirements, but with 15-20 people leaving in the time frame specified, it is hard to look at. They want a good snapshot of what is happening, without having to see everything. Here is what a portion of the original board looks like. I am trying to make it exportable to a slide show.

    Attached is the first few lines (censored for security) of our whiteboard. Imagine this with many more people on it.
    Attached Images Attached Images

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Automatically moving specific rows to new sheet/omitting columns/combining data

    Hi milChuck,

    I just can't get myself to write some VBA to solve your problem. I still think there are non VBA ways to solve this. Look at the attached where I created some formulas in the yellow area hid some columns and then copied and pasted (picture only) onto sheet 2. You could use this method without needing any darn VBA.

    To write better VBA I need the whole header row, of your form. I need to know which Items are Yes/No and what columns need to show on sheet2.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    04-05-2011
    Location
    South Carolina
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Automatically moving specific rows to new sheet/omitting columns/combining data

    Thanks MarvinP, this is exactly what I was looking for. I have hidden formulas in my original file that I use that will work perfectly with that "concatenate" command.

+ 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