+ Reply to Thread
Results 1 to 3 of 3

Pre-set processing of surveying data

  1. #1
    Registered User
    Join Date
    09-03-2008
    Location
    Canada
    Posts
    1

    Pre-set processing of surveying data

    I have raw surveying data from a total station that I'm dropping into an excel workbook. My goal is to create a workbook that will process the raw data and output a profile (xy scatter plot) under a new tab for future surveys that I might not be a part of.

    I have set up the formula's in the worksheet. They fill row 4-500. However, the issue is that I don't know how many data points (i.e., rows of data) will be collected at every survey in the future and I don't to include the rows of formulas with no data in them in the xy scatterplot. Is there any command to get around this (i.e., only include data in xy scatterplot from column m & n if there is data in row a)? Should I make a macro? Do you have any insight on the best way to approach this?

    I hope that this question is straightforward. Please let me know if I can clarify. Thanks so much for any help you can provide.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,655
    Moved to Charting forum.

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,769
    search for Dynamic named ranges.
    Cheers
    Andy
    www.andypope.info

+ 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. automatically move left one cell after data input by scanner.
    By dgbillings in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2010, 10:58 PM
  2. How can I speed up this slow macro?
    By rs2k in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-18-2008, 08:34 PM
  3. Replies: 2
    Last Post: 02-14-2008, 05:02 PM
  4. importing data:What i would like to do is be able to import
    By censura in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2007, 08:32 AM
  5. Macro to create new sheets from master data sheet
    By adsigel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2006, 09:21 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