+ Reply to Thread
Results 1 to 5 of 5

[SOLVED] Formula auto pick up the data from corresponding tab

  1. 06-08-2016, 12:50 AM #1
    jackson_hollon
    jackson_hollon is offline
    Forum Contributor
    Join Date
    06-07-2013
    Location
    US
    MS-Off Ver
    Excel 365
    Posts
    485

    [SOLVED] Formula auto pick up the data from corresponding tab

    Hello,

    I have a file that has few worksheets. I need a formula to auto pick up the data from the correct tab based on the date on a cell. I have attached a worksheet here. Hop it makes sense to you.
    Thanks a lot for the help.

    Jackson
    Test.JPG
    Attached Files Attached Files
    Last edited by jackson_hollon; 06-08-2016 at 02:11 AM.
    Reply With QuoteRegister To Reply
  2. 06-08-2016, 01:52 AM #2
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2504
    Posts
    13,750

    Re: Formula auto pick up the data from corresponding tab

    This is one way.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Dave
    Reply With QuoteRegister To Reply
  3. 06-08-2016, 02:10 AM #3
    jackson_hollon
    jackson_hollon is offline
    Forum Contributor
    Join Date
    06-07-2013
    Location
    US
    MS-Off Ver
    Excel 365
    Posts
    485

    Re: Formula auto pick up the data from corresponding tab

    Hi Dave,

    Thanks for the response. I used the formula and it works perfectly.

    Thanks for the help.

    Jackson
    Reply With QuoteRegister To Reply
  4. 06-08-2016, 02:12 AM #4
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2504
    Posts
    13,750

    Re: [SOLVED] Formula auto pick up the data from corresponding tab

    You're welcome. Thanks for the feedback.
    Reply With QuoteRegister To Reply
  5. 06-08-2016, 02:13 AM #5
    azumi
    azumi is offline
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 365
    Posts
    2,406

    Re: Formula auto pick up the data from corresponding tab

    wrong post, self deleted
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to check a formula is correct (auto-marking students work)
    By guitarchimp in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-23-2015, 01:31 PM
  2. Formula to pick up date/time
    By Dan_Calver in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-20-2015, 07:05 AM
  3. [SOLVED] Formula to Pick Start Date
    By rizmomin in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-06-2014, 06:04 PM
  4. If Statement to Pick Correct Number
    By Jesica in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-02-2011, 08:22 AM
  5. EXCEL formula to auto pick given QTY
    By davidku in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-18-2011, 04:57 AM
  6. VBA code to pick the correct sheets
    By realniceguy5000 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 04-01-2009, 02:49 PM
  7. [SOLVED] how do I write a formula to pick a date or N/A?
    By Scott in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-02-2006, 01:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1