+ Reply to Thread
Results 1 to 3 of 3

Extract Readings from One sheet to another sheet

  1. #1
    Forum Contributor
    Join Date
    01-31-2011
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    191

    Extract Readings from One sheet to another sheet

    Hello All,

    I have a reading of temperatures and Humidity for one month every five minutes. My problem is I want to copy only selected time to another worksheet.

    the Time that I want to copy are,

    1/1/2019 0:02
    1/1/2019 1:02
    1/1/2019 2:02
    1/1/2019 3:02
    1/1/2019 4:02
    1/1/2019 5:02
    1/1/2019 6:02
    1/1/2019 7:02
    1/1/2019 8:02
    1/1/2019 9:02
    1/1/2019 10:02
    1/1/2019 11:02
    1/1/2019 12:02
    1/1/2019 13:02
    1/1/2019 14:02
    1/1/2019 15:02
    1/1/2019 16:02
    1/1/2019 17:02
    1/1/2019 18:02
    1/1/2019 19:02
    1/1/2019 20:02
    1/1/2019 21:02
    1/1/2019 22:02
    1/1/2019 23:02

    Up to 1/31/2019 11:02:00 PM

    Please find attached file that I'm currently working on.

    Also Cross posted to this link

    Thank you so much.

    thong
    Attached Files Attached Files
    Last edited by thong127; 02-06-2019 at 03:08 PM.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,078

    Re: Extract Readings from One sheet to another sheet

    On a Clean sheet insert this in B2
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    and copy down as far as needed.
    The insert the extra rows as needed for the Average etc

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: Extract Readings from One sheet to another sheet

    Using Power Query, here is Mcode
    Please Login or Register  to view this content.
    Attached is file with step by step
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Compare new sheet vs old and extract data from old sheet into new sheet.
    By AndersW in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-05-2017, 03:57 PM
  2. [SOLVED] extract and split data in one cell from one sheet to another sheet in two cells in vba
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-16-2017, 08:21 AM
  3. [SOLVED] Desire data extract from the sheet “input” to the sheet “output”
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 06-24-2014, 02:19 PM
  4. [SOLVED] Automatically Extract comment/data from Sheet 1 to populate Sheet 2
    By nadagoat83 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-13-2014, 08:07 AM
  5. VBA to extract sheet in multiple closed workbooks to a sing sheet on new workbook (HELP!)
    By The1theycallp in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-12-2014, 08:19 AM
  6. How to transfer the weighing balance readings into Excel sheet?
    By ahmadchemeng in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2014, 03:46 PM
  7. Replies: 1
    Last Post: 12-09-2012, 06:50 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