+ Reply to Thread
Results 1 to 5 of 5

list data on summary sheet from multiple sheets, based on parameters

  1. #1
    Registered User
    Join Date
    07-29-2015
    Location
    New Orleans, Louisiana
    MS-Off Ver
    2010
    Posts
    7

    list data on summary sheet from multiple sheets, based on parameters

    Hello,

    I am looking for help with pulling data from various sheets and combining into one summary worksheet.
    I have attached the file for reference.

    For this example, what I am trying to achieve is list all glass tag #ís (with width, height) on the summary sheet but for Floor 7 only. In the various worksheets, the quantity of each tag on floor 7 is listed in column N. Currently, I have a Macro that lists all glass tags on the summary sheet and then have a lookup in Column F of the summary sheet to populate the order qty based on the Column input. However, this of course lists ALL glass tags from each sheet, even the tags with quantity of 0 on floor 7 (rows 11 through 31 on summary worksheet, for example)

    Is there a way to have the summary worksheet populate with only glass tagís that have quantities required for that specific floor? (in this case, only paste glass tag if the value in column N of that row is non-zero) I would like it so that once it is set up the same template file can be used to retrieve the order quantities from different floors

    Apologies in advance if any of the above is unclear, I have done my best to describe the situation.

    Thanks so much for the assistance!
    Attached Files Attached Files

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,530

    Re: list data on summary sheet from multiple sheets, based on parameters

    I tested this on your sample sheet and it does what I think you are looking for.
    Please Login or Register  to view this content.
    Last edited by skywriter; 12-01-2015 at 04:54 PM.
    As a reminder, once your original request has been fulfilled please mark this thread as SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

    If you are happy with my help, then please consider clicking the add reputation button in the lower left hand corner of this post.

  3. #3
    Registered User
    Join Date
    07-29-2015
    Location
    New Orleans, Louisiana
    MS-Off Ver
    2010
    Posts
    7

    Re: list data on summary sheet from multiple sheets, based on parameters

    Thank you so much for your help!

    This does work for what I am looking for. One more question (if beggars can be choosers ), is it possible to have the 'total order quantity' populate automatically on the summary tab based on the entered floor number, or is it necessary to enter the column letter for the vlookup to find the order quantity?

    Thanks again!

  4. #4
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,530

    Re: list data on summary sheet from multiple sheets, based on parameters

    I assume you want the amount from the G column for the applicable floor and you want it put into column F on the summary column. You would need to remove the formulas in column F and try this code.

    Thanks for the rep. points.

    Please Login or Register  to view this content.
    Last edited by skywriter; 12-08-2015 at 06:28 PM.

  5. #5
    Registered User
    Join Date
    07-29-2015
    Location
    New Orleans, Louisiana
    MS-Off Ver
    2010
    Posts
    7

    Re: list data on summary sheet from multiple sheets, based on parameters

    Thanks for that solution!

    That works as intended, except for one situation. Not in my example file, but it is possible for the Total Qty listed in column G does not match the quantity required for the specific floor.

    So rather than having the value from column G put into column F of the summary page, when '6' is entered as the floor number, I would like the value from column M put into column F of the summary page. When '7' is entered as the floor number, I want the value from column N put into column F of the summary page.

    I had tried to accomplish this using the vlookup formula in column F of the summary page but am wondering if it is possible to accomplish with code and then the user just has to push the button and enter in the floor number, not also the column letter in K3.

    Thanks so much for your help and patience as I am not experienced with vba!

+ 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. Summary Sheet - Using data from multiple sheets
    By disco dave in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-01-2015, 01:48 PM
  2. [SOLVED] Combining data across multiple sheets onto one summary sheet
    By dajul73 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 07-29-2014, 02:10 PM
  3. Replies: 0
    Last Post: 07-29-2013, 03:00 AM
  4. [SOLVED] Summary sheet - copy cell contents from multiple sheets to one summary sheet
    By jsmity in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 10:32 AM
  5. Replies: 0
    Last Post: 03-27-2012, 04:54 PM
  6. Macro to list data from several sheets in summary sheet
    By thunderstorm77 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-22-2011, 11:58 AM
  7. Copying a template sheet and putting those multiple sheets data into a summary sheet
    By John Wolfe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-18-2011, 06: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

X vBulletin 4.1.8 Debug Information

  • Page Generation 1.37374 seconds
  • Memory Usage 9,005KB
  • Queries Executed 16 (?)
More Information
Template Usage (35):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (2)bbcode_code
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (5)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (1)postbit_attachment
  • (5)postbit_legacy
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (49):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1