+ Reply to Thread
Results 1 to 6 of 6

Automatically find a paste data from range

  1. #1
    Registered User
    Join Date
    04-17-2015
    Location
    Australia
    MS-Off Ver
    2011
    Posts
    8

    Automatically find a paste data from range

    I need an equation that will scan a data range and automatically paste the relevant data in a table. In the attached picture, i need the 2 - 60% values from T/Ts = 1 to be pasted in the table in the top right. I also need the data for T/Ts values for 2,3,4,5. And if you have time, I am struggling with an interpolation equation that will allow me to get the T/Ts values for 0.25 and 0.5 as they are not always exact. Thank you!
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: Automatically find a paste data from range

    Could post a sample workbook (with sensitive data removed)? Makes writing an appropriate solution easier.

  3. #3
    Registered User
    Join Date
    04-17-2015
    Location
    Australia
    MS-Off Ver
    2011
    Posts
    8

    Re: Automatically find a paste data from range

    Spreadsheet for reference. Thanks
    Attached Files Attached Files

  4. #4
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,135

    Re: Automatically find a paste data from range

    Hi,

    Try the following formula in X6:

    =INDEX($L$3:$U$504,MATCH($W6,$L$3:$L$504,0),COLUMN(C$2))

    drag this formula to the right.

    Also, I see that there are no EXACT matches for 0.25 and 0.5 in T/Ts column. How would you go about them?
    Attached Files Attached Files

  5. #5
    Forum Contributor Potholes's Avatar
    Join Date
    11-25-2011
    Location
    Brisbane
    MS-Off Ver
    Office 2021
    Posts
    765

    Re: Automatically find a paste data from range

    Good evening

    I have used a vlookup formula in your file, If will help.

    Pete
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    04-17-2015
    Location
    Australia
    MS-Off Ver
    2011
    Posts
    8

    Re: Automatically find a paste data from range

    Thanks, cbatrody. Your formula worked for me. As for the 0.25 and 0.5 values, I will have to perform interpolation separetly in order to get those values.

    Thank you Pete. Your formula also worked. Its going to save me alot of time!

+ 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. Replies: 6
    Last Post: 09-22-2014, 05:57 AM
  2. Replies: 6
    Last Post: 03-26-2014, 11:40 PM
  3. Macro needed to find cells that are automatically populated, then copy and paste
    By ten10thmuse in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-04-2014, 04:34 PM
  4. Find Date Range data's and paste the next sheet blank row.
    By rskfriends in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-09-2013, 03:41 AM
  5. Need help for range to automatically copy and paste as values before closing workbook
    By trickyricky in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2011, 08:31 PM
  6. Dynamic Range,Find last row & paste.
    By JapanDave in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-25-2011, 01:19 AM
  7. automatically copy and paste a predefined range of cells
    By Dewy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-10-2010, 10:49 AM

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