Results 1 to 6 of 6

Automatically find a paste data from range

Threaded View

Poppin1337 Automatically find a paste... 09-14-2015, 09:23 PM
quekbc Re: Automatically find a... 09-14-2015, 11:36 PM
Poppin1337 Re: Automatically find a... 09-15-2015, 03:26 AM
Potholes Re: Automatically find a... 09-15-2015, 03:46 AM
Poppin1337 Re: Automatically find a... 09-15-2015, 04:20 AM
cbatrody Re: Automatically find a... 09-15-2015, 03:41 AM
  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

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