Results 1 to 2 of 2

Moving data from form to collapsible table

Threaded View

  1. #1
    Registered User
    Join Date
    07-11-2013
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    58

    Moving data from form to collapsible table

    Hi guys, I just wanted to get some advice on how I could do this. I need to create a form, and the form will have the inputs

    Category
    Name
    Group
    Date
    Cost

    I come from an Object Orientated background so I would consider that when the data is entered and submit is pushed, an Object is created. So this part is easy enough, but then I need to take this data and pre-populate a calendar type table.

    The table will be a collapsible type table, and the simplest form the initial table will look like
    Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
    Advertising £1453 £1453 £1453 £1453 £1453 £1453 £1453 £1453 £1453 £1453 £1453 £1453
    Electricity £80 £80 £80 £140 £80 £140 £140 £80 £80 £80 £80 £80
    Wages £22,343 £22,343 £27,343 £22,343 £22,343 £34,343 £22,343 £29,343 £22,343 £22,343 £34,343 £22,343
    Marketing £600 £600 £600 £600 £1200 £1200 £1200 £600 £600 £600 £600 £600

    The titles down the left, Advertising, Electricity, Wages, Marketing come from the form input Category. These are the main categories which will selected from a drop down menu. The money comes from all objects under that category for that month, added together. When you click on a category, it should expand and display the Name, Group, Date and individual cost of each object. So if you create 12 objects under the category Advertising, when you click on it in the table, it will display 12 rows of data.

    So doing the form is simple. I am really looking for advice on how to map this into the table and how to make everything collapsible. Any advice is appreciated, I am not to sure how to start on this part.

    Thanks

    Nick

    p.s. sorry for the bad title, I have changed it to make it more appropriate.
    Last edited by nick2price; 09-04-2013 at 08:27 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. General Advice (Filtering & Sorting)
    By demonfly100 in forum Excel General
    Replies: 0
    Last Post: 01-29-2013, 05:20 AM
  2. Need help speeding this up/general advice
    By ItPaysTheBills in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-02-2013, 08:11 AM
  3. Replies: 4
    Last Post: 12-13-2012, 11:02 AM
  4. General Advice
    By mwelf1 in forum Excel General
    Replies: 1
    Last Post: 04-01-2009, 12:07 AM
  5. Advice on Approach to Convert List of Dates into a Calender format
    By Andibevan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-23-2005, 11:00 AM

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