+ Reply to Thread
Results 1 to 7 of 7

Extract data from one sheet to another

  1. #1
    Registered User
    Join Date
    12-18-2011
    Location
    India
    MS-Off Ver
    excel2007
    Posts
    62

    Extract data from one sheet to another

    In protein sheet i want to extract data From database, only the status is opened. the closed status i dnt want.
    and one more is in invoice sheet when i enter the invoice no i want to extract data from database and inventory sheet only the field is given below.

  2. #2
    Registered User
    Join Date
    11-10-2011
    Location
    Cluj-Napoca
    MS-Off Ver
    Office 2010
    Posts
    17

    Re: Extract data from one sheet to another

    I would like to help you, but I don't know how. I am a begginer myself. Maybe you can help me be telling me how did you make the first three rows stay on top when you scrool down (on the Database and Inventory sheets). Thanks in advance.

    Later Edit: I am sorry about my mistake (posting a question in another thread). I posted another thread.
    Last edited by kitu_gudu; 12-24-2011 at 04:48 AM.

  3. #3
    Forum Guru
    Join Date
    05-24-2011
    Location
    Kuwait
    MS-Off Ver
    Office 365
    Posts
    2,200

    Re: Extract data from one sheet to another

    Hello Shilpa,

    Attached will extract only the status is Opened. I am not sure about the Invoice tab. How do you know which items are related to an invoice in database tab?

    Hello kitu_gudu,

    Please take a few minutes to read the forum rules. Rule # 2 says, Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

    Forum Rules
    Attached Files Attached Files
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  4. #4
    Registered User
    Join Date
    11-10-2011
    Location
    Cluj-Napoca
    MS-Off Ver
    Office 2010
    Posts
    17

    Re: Extract data from one sheet to another

    Quote Originally Posted by Haseeb A View Post
    Hello kitu_gudu,

    Please take a few minutes to read the forum rules. Rule # 2 says, Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

    Forum Rules
    You are right. Sorry about that, I am new here. I will make another thread. Can the post be deleted?
    Last edited by kitu_gudu; 12-24-2011 at 04:53 AM.

  5. #5
    Registered User
    Join Date
    12-18-2011
    Location
    India
    MS-Off Ver
    excel2007
    Posts
    62

    Re: Extract data from one sheet to another

    Quote Originally Posted by Haseeb A View Post
    Hello Shilpa,

    Attached will extract only the status is Opened. I am not sure about the Invoice tab. How do you know which items are related to an invoice in database tab?

    Hello kitu_gudu,

    Please take a few minutes to read the forum rules. Rule # 2 says, Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.

    Forum Rules
    in invoice sheet, when i select the invoice no for exmple if i selected 722, den date, lot no, bag details, vhcl no, trsnprt, disptch from inventory sheet and moistute protein tvbn from database sheet of lot nbr

  6. #6
    Registered User
    Join Date
    12-18-2011
    Location
    India
    MS-Off Ver
    excel2007
    Posts
    62

    Re: Extract data from one sheet to another

    Quote Originally Posted by Shilpa kanchan View Post
    in invoice sheet, when i select the invoice no for exmple if i selected 722, den date, lot no, bag details, vhcl no, trsnprt, disptch from inventory sheet and moistute protein tvbn from database sheet of lot nbr
    Pls anyone solv dis problm..

  7. #7
    Forum Guru
    Join Date
    05-24-2011
    Location
    Kuwait
    MS-Off Ver
    Office 365
    Posts
    2,200

    Re: Extract data from one sheet to another

    See the attached. Hope this helps
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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 0.07035 seconds
  • Memory Usage 9,000KB
  • Queries Executed 15 (?)
More Information
Template Usage (33):
  • (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
  • (3)bbcode_quote
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (7)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (2)postbit_attachment
  • (7)postbit_legacy
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (4)showthread_bookmarksite
  • (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 (47):
  • 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_display_complete
  • memberaction_dropdown
  • postbit_attachment
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1