+ Reply to Thread
Results 1 to 1 of 1

Having rows show up on a separate worksheet

  1. #1
    Registered User
    Join Date
    06-12-2012
    Location
    New York City, NY
    MS-Off Ver
    Excel 2007
    Posts
    3

    Having rows show up on a separate worksheet

    Hello everyone,

    I am the shipping manager of a small jewelry company and have developed a log to track each days shipments.

    I would say we have about 20-25 shipments a day, so as you can imagine the log fills up quite quickly.

    I track shipments every morning and sometimes shipments that have not been delivered will slowly disappear from me unless I scroll all the way up the log. I've tried the worksheet per month method but that seems like it is too much space because of all the formulas making my day to day life a lot easier.

    Something that I would like to do is perhaps have a shipment which takes up 1 row(A:H) to appear on the next worksheet as an A:H row if cell A(date shipped) is longer than 1 week ago and cell B(date received) is "". Is this possible? Or is it just a dream I made up?

    Is there a way to make Arow#:Hrow# a unit to reference?

    I am not a programmer so bare with me!!!

    Thank you for you help ahead of time.

    Let me know if you need more details.
    Last edited by Mikejbona; 09-25-2012 at 05:52 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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