Results 1 to 4 of 4

Data reduction macro

Threaded View

migrod1 Data reduction macro 01-20-2014, 02:00 PM
migrod1 Re: Data reduction macro 01-20-2014, 02:15 PM
migrod1 Re: Data reduction macro 01-29-2014, 12:35 PM
bsalv Re: Data reduction macro 01-29-2014, 04:21 PM
  1. #1
    Registered User
    Join Date
    01-20-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    3

    Data reduction macro

    Hey everyone,
    So I'm trying to reduce some data from every second to every minute. I was able to use this macro that i found on here but when it runs it inputs all the data to one column which i cant use to plot since each is a different sensor.

    Sub snb()
    Do
    y = InputBox("number")
    Loop Until Val(y) <> 0 Or y = ""
    If y = "" Then Exit Sub

    Open "Q:\xxx.lvm" For Input As 1
    sn = Split(Input(LOF(1), 1), vbCrLf)
    Close

    For j = 0 To UBound(sn) Step y
    c01 = c01 & "|" & sn(j)
    Next
    sq = Split(Mid(c01, 2), "|")
    Cells(1).Resize(UBound(sq) + 1) = Application.Transpose(sq)
    Columns(1).TextToColumns , , , , False, False, False, True, False
    End Sub
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Data reduction macro
    By pbd3mon in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 04-21-2016, 03:03 AM
  2. [SOLVED] Test data reduction macro
    By a1aexcel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-18-2013, 02:50 PM
  3. Excel 2008 : Data Reduction
    By akuffel in forum Excel General
    Replies: 3
    Last Post: 06-01-2010, 08:56 AM
  4. data reduction
    By Leal72 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-26-2008, 12:27 PM
  5. [SOLVED] Average data/reduction
    By MC in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-09-2006, 11:25 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