+ Reply to Thread
Results 1 to 2 of 2

Creating a Summary Document that gets information from a DB using data valdation&offsets

Hybrid View

  1. #1
    Registered User
    Join Date
    07-02-2014
    Location
    Sweden
    MS-Off Ver
    Office 2013
    Posts
    17

    Exclamation Creating a Summary Document that gets information from a DB using data valdation&offsets

    Hi
    Something was wrong with the attachment in the last post

    I have created a document that gets raw data from an excel database depending on your choice in a data validation list. In the list you decide which type of model you want and then the cost specification is shown in the document. I want to try and create a macro that summarizes all different models sub groups(cat. S) cost and labor hours into new document in a formated tabel. I don't really know where to start as my knowledge in VBA i limited to creating simpler macros. I would appreciate a lot any help I can get. I have attached a document that is similar to the document that I want information copied from. excelforum ex.xlsx

    Kind Regards
    Lars

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Creating a Summary Document that gets information from a DB using data valdation&offse

    I think that youre best of tackling this yourself or breaking it up in to pieces in separate posts of what you want to do. It looks like youre trying to get someone to do it for you
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

+ 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. Creating a Summary Document that gets information from a DB using data valdation&offsets
    By mushedpotatos in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-03-2014, 06:29 AM
  2. Replies: 5
    Last Post: 06-20-2013, 07:29 PM
  3. Replies: 5
    Last Post: 06-14-2012, 08:48 AM
  4. Replies: 0
    Last Post: 06-25-2010, 06:19 AM
  5. Replies: 4
    Last Post: 03-16-2006, 06:55 AM

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