+ Reply to Thread
Results 1 to 2 of 2

Advice on project direction please

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Surrey B.C.
    MS-Off Ver
    2013
    Posts
    155

    Thumbs up Advice on project direction please

    I have attached a workbook that should help show what I would like to achieve.

    The first page in the work has an inventory list with boxes left blank. When the boxes are filed the totals go over to a corresponding box on sheet 2.
    The first page will eventually have "command buttons" that will add or subtract a value from the adjacent cell. I filled in a few as an example. (I do not need help with these).

    The second page has repetitive inventory. With each section representing a particular floor.

    What I would like is to be able to populate the first sheet (Lets call it first floor). Hit a button and it transfers the data to appropriate cells In the second sheet. Then I would like the first sheet data to "clear" and "reset".
    Whereby, if there is a second floor, I could populate sheet 1 again and have the data transferred to floor 2. "clear" and "reset"
    etc. etc.

    I wonder should I be achieving my goal with a "user form", Module, or a combination.

    Any help would be appreciated.

    TBM
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Surrey B.C.
    MS-Off Ver
    2013
    Posts
    155

    Re: Advice on project direction please

    Solved this myself.
    What I have done is create Five command buttons. Each one represents a Floor and saves the data on another page. Then clears the contents. Then the user can refill the data and hit the command button for the next floor. etc.
    Thanks

+ 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. Replies: 5
    Last Post: 11-27-2013, 05:58 PM
  2. Need some direction on a current project.
    By NetEcho in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-10-2013, 11:00 AM
  3. Replies: 12
    Last Post: 03-18-2013, 05:18 PM
  4. [SOLVED] Need advice - hot to count direction changes in value for a 24-h period?
    By jonni in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-03-2013, 03:47 PM
  5. [SOLVED] Need advice and direction on a project
    By NetEcho in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-21-2012, 05:24 PM
  6. Advice on my Project
    By woodland81 in forum Excel General
    Replies: 4
    Last Post: 12-28-2010, 06:00 AM
  7. Advice on excel project
    By blzalewski in forum Excel General
    Replies: 2
    Last Post: 06-22-2007, 11:45 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