Results 1 to 7 of 7

Way to filter out Unused space and Copy/paste onto another worksheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Houston, TX
    MS-Off Ver
    office 365
    Posts
    638

    Way to filter out Unused space and Copy/paste onto another worksheet

    I have one Tab (Daily Chgs) that as of this moment has a defined set of spaces under certain breakdowns in column 'B' - what I would like is to have the unused space to go away when it populates the Job Ticket Tab

    Because we are going to add additional lines under each subset that may or may not be used.....

    I only have a set number of spaces on the Destination sheet so i can not keep unused portions I only have room for the Used sections to the Job Ticket Tab Starting in row 10.

    Example: I will have 15 drop downs under each subset to choose from, you may only use a couple so I want to be able to only grab the completed parts and paste to the other sheet.

    You can see when it fills out right now I would like to be able and have the unused space to go away when it populates the Job Ticket Tab.

    I am not sure that I am explaining it OK but Can this be done?

    I know right now there are formulas in certain cells I will make those changes Once this portion changes.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. type mismatch while trying to filter and copy rows and paste to another worksheet
    By perducci in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-24-2012, 02:59 PM
  2. vba Copy Filter item and paste at other worksheet
    By gingank in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2012, 06:21 AM
  3. Trailing space with copy and paste
    By murphy in forum Excel General
    Replies: 1
    Last Post: 11-04-2008, 02:17 PM
  4. how to filter and copy data from one sheet and paste to new worksheet
    By mr_asrul in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-03-2008, 07:15 AM
  5. Replies: 5
    Last Post: 03-18-2006, 08:45 AM

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