+ Reply to Thread
Results 1 to 12 of 12

Move entries among sheets based on dates

  1. #1
    Registered User
    Join Date
    12-04-2018
    Location
    Chicago
    MS-Off Ver
    2016
    Posts
    6

    Move entries among sheets based on dates

    deleted by poster
    Attached Files Attached Files
    Last edited by kvangerven; 12-05-2018 at 05:46 AM. Reason: Irrelevant section of thread title removed.

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Move entries among sheets based on dates [urgent]

    Can you explain, and give example when "entries that are less than a month old "

    Do you want to clean up "Estimates in progress" and "Tech Small Job Estimates in progress" lists before recording new data ?
    Last edited by PCI; 12-05-2018 at 12:49 AM.
    - Battle without fear gives no glory - Just try

  3. #3
    Registered User
    Join Date
    12-04-2018
    Location
    Chicago
    MS-Off Ver
    2016
    Posts
    6

    Re: Move entries among sheets based on dates [urgent]

    deleted by poster
    Last edited by kvangerven; 12-05-2018 at 05:45 AM.

  4. #4
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Move entries among sheets based on dates [urgent]

    Do you want to clean up "Estimates in progress" and "Tech Small Job Estimates in progress" lists before recording new data ?

  5. #5
    Registered User
    Join Date
    12-04-2018
    Location
    Chicago
    MS-Off Ver
    2016
    Posts
    6

    Re: Move entries among sheets based on dates [urgent]

    deleted by poster
    Last edited by kvangerven; 12-05-2018 at 05:44 AM.

  6. #6
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Move entries among sheets based on dates [urgent]

    Certainly a stupid question, but don't use filter in sheet"plist" to make the display you want ??

  7. #7
    Registered User
    Join Date
    12-04-2018
    Location
    Chicago
    MS-Off Ver
    2016
    Posts
    6

    Re: Move entries among sheets based on dates [urgent]

    Deleted by Poster
    Last edited by kvangerven; 12-05-2018 at 05:38 AM.

  8. #8
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Move entries among sheets based on dates [urgent]

    In sheet "EST-SHT" header are
    Est No. Bid Date Type Source/Contact Responsible Commercial Est No. Comments Go, No Go Score Bid to
    From where in sheet "plist" to pick up the data to fill columns ?

  9. #9
    Registered User
    Join Date
    12-04-2018
    Location
    Chicago
    MS-Off Ver
    2016
    Posts
    6

    Re: Move entries among sheets based on dates [urgent]

    Deleted by Poster
    Last edited by kvangerven; 12-05-2018 at 05:37 AM.

  10. #10
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Move entries among sheets based on dates [urgent]

    To go faster this is what can be done:
    2 extra sheets are prepared, see file attached
    Please Login or Register  to view this content.
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    12-04-2018
    Location
    Chicago
    MS-Off Ver
    2016
    Posts
    6

    Re: Move entries among sheets based on dates [urgent]

    Deleted by Poster
    Last edited by kvangerven; 12-05-2018 at 05:37 AM.

  12. #12
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Move entries among sheets based on dates

    Good news.
    PCI

+ 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. Dates Based on Sum of Random Entries
    By Truckman in forum Excel General
    Replies: 3
    Last Post: 09-28-2018, 08:19 AM
  2. Rank entries based on values and dates
    By sebroa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-17-2017, 03:07 PM
  3. Need to Calculate vacant days btwn 2 dates given multiple move in and move out dates
    By DemetriusFaulk in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-19-2016, 03:22 PM
  4. [SOLVED] Macro to move Entries between Worksheets based on Drop-down Entry
    By PANDACHAN in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 06-09-2015, 08:50 PM
  5. [SOLVED] Need to modify VBA code to move Entries between Worksheets based on Drop-down Entry
    By loydancer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-02-2015, 01:56 AM
  6. [SOLVED] Move Non-Zero row entries up to occupy Zero row entries. Rows deletion not allowed
    By chancw in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-08-2013, 03:57 AM
  7. Move Row based on dates
    By Bill in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-28-2005, 12:06 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