+ Reply to Thread
Results 1 to 2 of 2

Moving data from form to collapsible table

Hybrid 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.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,032

    Re: General advice on approach

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    Never use Merged Cells in Excel

+ 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. 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