+ Reply to Thread
Results 1 to 8 of 8

User friendly worksheet/form

Hybrid View

  1. #1
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: User friendly worksheet/form

    Hi GOBBYGIBBO

    Your confidence is not misplaced.

    1/ No you are not barking up the wrong tree (do you really have trees on Saturn?).
    2/ some of it makes sense
    2a/ I do not laugh

    When these known users create the Credit Note request, what do they use? Is it 1 form and everyone uses it, (so what does user 2 see?) or is it a blank form from a template? (that might be easier to manage). I think a sample might be beneficial here.

    Your efforts to minimise your input is to be applauded (and, yes, even encouraged ) so let me know how I can help.

    Regards
    Alastair

  2. #2
    Registered User
    Join Date
    11-07-2012
    Location
    Planet Gibbo
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: User friendly worksheet/form

    Hello
    The users will use 1 form which I have (hopefully) attached. The way I envisage this working is.
    User inputs data into the form on sheet 1.
    That data is then placed into row 1 on sheet 2.
    User inputs new data into form on sheet 1
    That data is then placed into row 1 on sheet 2

    At some point between the entry of data into the form on sheet 1 the data on sheet 2 is moved down by one row in readines for the next user/input of data into form on sheet 2.
    Attached Files Attached Files

+ 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. [SOLVED] Excel vba user form- open directly to user form not worksheet
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 04-24-2013, 05:07 PM
  2. Transfer User form data to a worksheet w.r.t. combobox item on the form
    By nm766 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2011, 12:43 PM
  3. User friendly summarising
    By murphybrendan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-12-2010, 06:54 AM
  4. Filling form fields via worksheet dropdowns, user update via form, change form color
    By Demosthenes&Locke in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2010, 08:58 AM
  5. making a worksheet user friendly
    By lsu-i-like in forum Excel General
    Replies: 0
    Last Post: 05-06-2005, 01:29 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