Results 1 to 3 of 3

Thread: what shoud i do to have one sheet of every 1hour data & min max data with vb code

  1. 03-05-2014, 11:06 PM #1
    CORAL
    CORAL is offline
    Junior Member
    Join Date
    Feb 2014
    Posts
    24
    Rep Power
    0

    what shoud i do to have one sheet of every 1hour data & min max data with vb code

    hi
    i have two sheet one of them is one hour data of graph and another one min max data of graph and i have to mix them and then sort
    now i do it without code and it is time cunsuming

    what shoud i do to have one sheet as sheet1 of every 1hour data & min max data(guran.xlsx) and sort( with vb code_) i attached guran. xlsx
    with best wishes

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    https://eileenslounge.com/viewtopic.php?p=320960#p320960
    https://eileenslounge.com/viewtopic.php?p=320957#p3209573
    https://eileenslounge.com/viewtopic.php?p=318868#p318868
    https://eileenslounge.com/viewtopic.php?p=318311#p318311
    https://eileenslounge.com/viewtopic.php?p=318302#p318302
    https://eileenslounge.com/viewtopic.php?p=317704#p317704
    https://eileenslounge.com/viewtopic.php?p=317704#p317704
    https://eileenslounge.com/viewtopic.php?p=317857#p317857
    https://eileenslounge.com/viewtopic.php?p=317541#p317541
    https://eileenslounge.com/viewtopic.php?p=317520#p317520
    https://eileenslounge.com/viewtopic.php?p=317510#p317510
    https://eileenslounge.com/viewtopic.php?p=317547#p317547
    https://eileenslounge.com/viewtopic.php?p=317573#p317573
    https://eileenslounge.com/viewtopic.php?p=317574#p317574
    https://eileenslounge.com/viewtopic.php?p=317582#p317582
    https://eileenslounge.com/viewtopic.php?p=317583#p317583
    https://eileenslounge.com/viewtopic.php?p=317605#p317605
    https://eileenslounge.com/viewtopic.php?p=316935#p316935
    https://eileenslounge.com/viewtopic.php?p=317030#p317030
    https://eileenslounge.com/viewtopic.php?p=317030#p317030
    https://eileenslounge.com/viewtopic.php?p=317014#p317014
    https://eileenslounge.com/viewtopic.php?p=316940#p316940
    https://eileenslounge.com/viewtopic.php?p=316927#p316927
    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 10-04-2024 at 10:22 PM.
    Reply With Quote Reply With Quote
  2. 03-06-2014, 08:19 PM #2
    Excel Fox
    Excel Fox is offline
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    The sorting should be based on time, and not based on the decimal value on the right?
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook
    Reply With Quote Reply With Quote
  3. 03-08-2014, 04:22 PM #3
    CORAL
    CORAL is offline
    Junior Member
    Join Date
    Feb 2014
    Posts
    24
    Rep Power
    0
    sorting based on time but the first problem is that we have two excel file that one of them is one hour data and the other is min max data of graph and these two file must be combined then sort
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Looking at data sheet and then transferring data according to date to fixed range
    By jeff in forum Excel Help
    Replies: 16
    Last Post: 12-23-2013, 03:44 PM
  2. Pull data within the work sheet and save as master sheet with pulled sheet name.
    By amar.kshirsagar in forum Excel Help
    Replies: 2
    Last Post: 09-30-2013, 03:40 PM
  3. Min, Max, Average Vba for Situation
    By afm1985 in forum Excel Help
    Replies: 1
    Last Post: 09-14-2013, 07:16 PM
  4. VBA Code To Move Data From One Sheet To Another And Delete From Source Sheet
    By rich_cirillo in forum Excel Help
    Replies: 14
    Last Post: 06-24-2013, 06:17 PM
  5. Data sorting & Graph making according filters
    By leopaulc in forum Excel Help
    Replies: 2
    Last Post: 04-05-2012, 08:56 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
  •  

Forum Rules