+ Reply to Thread
Results 1 to 3 of 3

unable to call data using vba and formulas

  1. #1
    Registered User
    Join Date
    04-09-2015
    Location
    delhi
    MS-Off Ver
    7
    Posts
    15

    unable to call data using vba and formulas

    Hello

    I have a file where in there are multiple sheets of the source data. Based on the inputs by the user, the data needs to be called in the respective cells.

    For example, in Sheet 1, the user inputs values in D3 to D7. the matching data should get picked up from all the respective sheets and get populated in cells b12 to b81.

    Any thoughts or codes that i can use to achieve this task?

    Thanks

    Sahil
    Attached Files Attached Files
    Last edited by sahilkh18; 01-03-2018 at 11:10 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: Formulas/automation help needed

    Thanks for changing the title.
    Last edited by protonLeah; 01-03-2018 at 11:28 PM.
    Ben Van Johnson

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

    Re: unable to call data using vba and formulas

    You haven't given enough information.

    We don't know what sheet to look at and what information to return based on the user input.

    I would make sure you workbook has a before and after sheet so we can see what kind of information should be returned.

    You should specify which sheets the information was returned from so we don't have to study your workbook trying to figure out what is going on.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

+ 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. Repeat error - VBA Automation (Help Needed)
    By Michael Staveley in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-06-2017, 08:32 AM
  2. Year To Date Return Formula - automation needed
    By brains in forum Excel General
    Replies: 7
    Last Post: 02-05-2015, 03:04 PM
  3. Copy / Paste / Save As - Automation Help Needed
    By polyzp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2014, 12:27 PM
  4. Copy / Paste / Save As - Automation Help Needed
    By polyzp in forum Excel General
    Replies: 2
    Last Post: 09-18-2014, 06:55 PM
  5. help needed on Putty automation using Excel VB application
    By mohanece in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-17-2014, 04:27 AM
  6. Automation Error help needed
    By funkymonkUK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-23-2006, 09:46 AM
  7. Automation Error ... Urgent help needed
    By Alexander.Kom in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-14-2005, 05:58 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