Results 1 to 8 of 8

Attempting to populate form organised by date from another worksheet via drag and drop

Threaded View

  1. #7
    Registered User
    Join Date
    07-31-2013
    Location
    New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Attempting to populate form organised by date from another worksheet via drag and drop

    Okay so I I have uploaded a mock up...

    I've changed names but these are based on actual entries, but numbered to be sure that each entry is in fact a new entry... There is another section to this spread sheet, that adds up everyone's payments and derives balances and totals by searching the data that I am trying to auto populate now, But thats not relevant, What O need help eith is just autopoulating the fields from theCSV data...

    I had a index/ match formula but it was buggy... which I copied into an earlier post...

    The first entry is how thy all should appear... all entries need to be sequential greater than the previous date and < or = to the next date for each field.

    In my attempt the formula reffered to the last date of the previous field, and then each reffered to the previous entry for the date, in that field, pbviously they all need to reffer to the end date of the fortnightly period... so that no entries exceed it.

    I'm stumped...

    Any takers?

    Cheers,

    Q
    Attached Files Attached Files
    Last edited by quinnjin; 03-03-2018 at 06:08 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Deactivate Drag and Drop in one worksheet only
    By Rookie11 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-01-2016, 05:01 AM
  2. [SOLVED] Excel - VBA Form - populate worksheet table with auto increment ID, worksheet headers only
    By EKExcel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-17-2015, 03:15 AM
  3. Replies: 6
    Last Post: 01-02-2014, 10:38 AM
  4. Replies: 8
    Last Post: 12-15-2012, 02:01 PM
  5. Prevent drag and drop of a worksheet using Application.OnKey or similar
    By maxcat in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-16-2011, 10:45 PM
  6. drop down lists to populate an order form
    By john dalton in forum Excel General
    Replies: 13
    Last Post: 04-02-2010, 12:18 PM
  7. [SOLVED] Excel 2003 Multi-worksheet copy via drag/drop
    By idrabefi in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-12-2005, 02:06 PM

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