+ Reply to Thread
Results 1 to 2 of 2

dynamic data macro (using arrays, loops, filters)

  1. #1
    Registered User
    Join Date
    02-28-2014
    Location
    Louisiana
    MS-Off Ver
    Excel 365
    Posts
    3

    dynamic data macro (using arrays, loops, filters)

    I've been doing a lot of research to try to understand as i go along, trying to achieve a small memory footprint, I'm currently stuck in finishing this up.
    I'd really appreciate if someone could help me minimize creating extra lines and doing this the most logical way

    In short- I have a report in which we fill 17 columns per row of data. Each row stands for 1 hour.
    Step 1 is to determine if the cell is empty and if the hours does not exceed current system time
    storing the hours into an array,

    --Open data las file into it's own excel workbook
    Step 2- Looping array and feeding into criteria using each hour as the initial criteria then either using the next value in the array/loop as the ending criteria to find the span of data
    -While Looping each hour, the span of visible cells (1-2am) would be applied with average,max,min to respective fields then stored into array
    Step 3- Position of the first hour, would allow for array to dump onto sheet

    ---- All of these steps to create a easy to use, friendly report, to share with others to cut down on entering data that is already being recorded. The effort of going out the way is to assume nothing except that the user has all of the columns within their las in a particular order.

    Any help would be great, as my mind is swamped from trying to interpret and apply examples for the moment.

    Please note- the data i work with and the excel worksheet has info that is confidential to each well we are a service on. So if i must, i can try to provide samples of the sheet and data to an extent

    Links of other forum's posted on:
    http://www.mrexcel.com/forum/excel-q...lete-code.html
    http://www.ozgrid.com/forum/showthread.php?t=191551
    Please Login or Register  to view this content.
    Last edited by Matheo; 10-23-2014 at 06:13 AM.

  2. #2
    Registered User
    Join Date
    02-28-2014
    Location
    Louisiana
    MS-Off Ver
    Excel 365
    Posts
    3

    Re: dynamic data macro (using arrays, loops, filters)

    Hourly report worksheet
    hourly data range.gif
    Las Data
    raw data.gif
    Last edited by Matheo; 10-23-2014 at 06:11 AM.

+ 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. How to display output from one locked data piece and one client-input data piece?
    By tnovak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2014, 12:48 PM
  2. Stuck and Need to Loop a Particular Piece of My Code
    By Monkey Brain in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-08-2013, 03:48 PM
  3. Need help with loops and arrays in VBA Macro
    By lealea1982 in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 08-26-2011, 08:51 AM
  4. VBA Loops + Arrays
    By Kengh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-26-2010, 07:41 PM
  5. Loops and Arrays
    By v2jtb in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-29-2010, 12:09 PM

Tags for this Thread

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