+ Reply to Thread
Results 1 to 4 of 4

Large file copy column range problems

  1. #1
    Registered User
    Join Date
    02-21-2017
    Location
    BOULDER, COLORADO
    MS-Off Ver
    2013
    Posts
    0

    Large file copy column range problems

    So I have collected a lot of log data from some tools I have and it puts all the info in 2 columns with about 30,000 to 40,000 rows.
    The data ranges are in 350 contiguous cells and then the next set up data starts - there are 4 sets of data and then the next measurement starts.
    What I'd like to do is take the first 350 cells and copy them over to a new worksheet column, then the next 350 cells and paste them in the next column and do that for 4 columns
    After this I'd like to rinse and repeat with cell 1401 (4 x 350) and do the next 4 columns and then repeat this cycle until the end of the data.

    I'm not a VBA user by any extent, formulas would be nice or walk me thorugh a pivot table....

    Example Data

    PCI 20
    PCI 20
    \/ \/ (350 rows later)
    EAF 5230
    EAF 5590
    \/ \/ (350 rows later)
    SNR -11
    SNR 3.95
    \/ \/ (350 rows later)
    RF 29
    RF 38

    This continues on for +30,000 rows - lots of data to parse manually....

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello eolbrich,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    03-09-2017
    Location
    Seattle, WA, USA
    MS-Off Ver
    MS Office 10
    Posts
    1

    Re: Large file copy column range problems

    I've had data stream dumps that needed similar parsing based on numbers of rows just like this. I've just done it manually, I'm eager to see what solution you find!

  4. #4
    Forum Expert Doc.AElstein's Avatar
    Join Date
    05-23-2014
    Location
    '_- Germany >Outside Building things.... Mostly
    MS-Off Ver
    Office 2003 2007 2010 PC but Not mac. XP and Vista mostly, sometimes Win 7
    Posts
    3,618

    Re: Large file copy column range problems

    Hi eolbrich
    Welcome to Excel Forum
    Do you realise that this Sub Forum where you have posted is just the Sub Forum to say hello ?

    You must start a new Thread in one of the main Sub Forums here, if you need help:

    Excel General : http://www.excelforum.com/excel-general/
    or here:
    Formulas and Functions: http://www.excelforum.com/excel-formulas-and-functions/
    or if you would consider a macro solution then here:
    VBA Programming: http://www.excelforum.com/excel-programming-vba-macros/

    If you are not sure of exactly the type of solution you require, then probably the first Sub Forum will do: http://www.excelforum.com/excel-general/

    _............................................

    Alan

    _..............................................

    P.s. Unless someone is very familiar with having done something exactly as you are doing, then I think you may need to give a bit more detail. Some test data is helpful
    Remember to reduce the amount of test data to the minimum required to demonstrate typical scenarios. Desensitize the data if necessary.
    If appropriate, show us clearly what you have ( The BEFORE ) and the results you want to achieve ( the AFTER ).
    Please do not use images !!! as we cannot copy them to a worksheet.

    Regarding how to give us that data ( Most people prefer b) to upload a File BUT remember to minimize the amount and desensitise data )

    Either:
    _a) Post screenshots COPYABLE !!! to a Spreadsheet: ( !!! Not Images please !!! )– See my signature below,
    or here:
    http://www.excelforum.com/excel-prog...ml#post4399581
    Practice here in the Test Sub Forum:
    http://www.excelforum.com/development-testing-forum/ ( Start a new Thread. Title it something like “Just Testing, no Reply needed” )
    OR:
    _b) Upload a Workbook
    : See here:
    http://www.excelforum.com/the-water-...his-forum.html ( ** Use Method 2 and Method 3 ( Method 1 is currently not working )
    http://www.excelforum.com/suggestion...ml#post4335120
    OR:
    There is also the file share site option such as this free thing:
    https://app.box.com/signup/personal
    (_ .Remember to select Share after uploading and give us the link they provide if you use that )
    But Note: a lot of people can’t / won’t download a File from an external site. So this method is not preferred here
    For security reasons and to increase your chances of a response, It is preferable to upload a File with no codes in it and post any codes in the Thread ( using Code Tags: [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] ; or Short Cut Editor Icon ( you may need to Hit Go Advanced to see it if Replying to a Thread ) # ).

    OR:
    _c) Select the table Icon above, select an appropriate size table and fill it in (***If replying to a Thread you may need to select the Go Advanced Button, ( bottom right of reply Window ) to get the Table Icon to show )


    You can Practice Posting techniques here:
    http://www.excelforum.com/development-testing-forum/
    Just start a Thread there with a title like “Just testing, No reply needed”. Or just do a reply to any other Thread were someone is “just testing”
    Thanks,
    Alan

    P.s. Also: Please, also, if you haven’t already , take some time before posting to read the Forum Rules here:

    English: http://www.excelforum.com/forum-rule...rum-rules.html
    http://www.excelforum.com/showthread...42#post4519006

    Other languages: http://www.excelforum.com/forums-rules/
    It is usually worth it in the long run.

    Thanks



    _....
    '_- Google first, like this _ site:ExcelForum.com Gamut
    Use Code Tags: Highlight code; click on the # icon above,
    Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
    http://www.excelforum.com/the-water-...ml#post4109080
    https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
    http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )

+ 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. [SOLVED] How to copy a value or a formula over a very large range
    By icestationzbra in forum Tips and Tutorials
    Replies: 1
    Last Post: 03-15-2014, 07:25 PM
  2. Copy and paste macro results in a large size file
    By rz6657 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2014, 04:50 PM
  3. Problems with ADO copy from one excel file to another
    By Dahlgren in forum Excel General
    Replies: 1
    Last Post: 04-23-2012, 10:49 PM
  4. How to quickly copy down in very large file?
    By excel0123 in forum Excel General
    Replies: 7
    Last Post: 10-05-2009, 08:52 PM
  5. Compare Rows column by Column in Large Excel File
    By arunsinghpundir in forum Excel General
    Replies: 1
    Last Post: 03-05-2007, 09:38 AM
  6. [SOLVED] copy and paste between xls file syntax problems
    By dr chuck in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-26-2006, 11:15 AM
  7. [SOLVED] large data file problems - pivot table with vba
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-28-2005, 10:05 PM
  8. Large excel file problems?
    By gkaste in forum Excel General
    Replies: 2
    Last Post: 06-22-2005, 04:05 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