Results 1 to 5 of 5

Fetching data from one sheet to another with some logic!?

Threaded View

  1. #1
    Registered User
    Join Date
    01-11-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    69

    Fetching data from one sheet to another with some logic!?

    Hi, I have a workbook in which there is a database sheet called “DTL” and a query sheet called “QRY”. In the “QRY” sheet I’ve create a list containing all items mentioned in sheet “DTL” and I’ve added a button “ADD” from active-x control in developer tab. What I’m trying to do is when I select a item from the drop down list in sheet “QRY” and hit the button “ADD” a macro should run and fetch data from sheet “DTL” using the data in the drop down as lookup value and fill in the table in sheet “QRY”.

    Please find attached the sample file to work with.
    Attached Files Attached Files
    Last edited by 0Cool; 11-05-2019 at 03:22 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Fetching data from another sheet
    By Patwardhan in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 08-04-2018, 03:22 AM
  2. [SOLVED] Combinations and fetching in the Forms Sheet
    By fareedexcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-07-2017, 10:38 PM
  3. Replies: 4
    Last Post: 04-14-2014, 01:42 PM
  4. [SOLVED] Fetching average from another sheet.
    By Khoori7 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-24-2013, 09:57 PM
  5. Replies: 0
    Last Post: 11-05-2013, 01:51 AM
  6. [SOLVED] Generate multiple invoices fetching data from rows of a sheet
    By devang.vakharia in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-12-2013, 08:14 AM
  7. Replies: 2
    Last Post: 02-04-2012, 12:00 PM

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