+ Reply to Thread
Results 1 to 5 of 5

Import specific columns past a certain row into another spreadsheet.

  1. #1
    Registered User
    Join Date
    08-10-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    20

    Import specific columns past a certain row into another spreadsheet.

    Please just ignore this post. I can't figure out how to delete the attached files that are irrelevant and I can't figure out how to upload new ones. I also don't know how to word what I need to happen



    I want the data from everything, starting from row 5 and going to row 100, and not include column B or E.

    How do I grab just that data? I have different formulas in each document. This is for invoicing, so the columns with the $ numbers can't be changed and I haven't been able to figure out how to not overwrite them when importing another spreadsheet.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Nexion21; 08-10-2013 at 08:54 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Import specific columns past a certain row into another spreadsheet.

    How do I grab just that data?
    I haven't been able to figure out how to not overwrite them when importing another spreadsheet.
    These sound like 2 different questions?

    for the 1st 1, where do you want to put it? cant you just reference it from where you need it to be?

    Also, please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    08-10-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Import specific columns past a certain row into another spreadsheet.

    How do I upload a sample of my workbook? The reason I didn't is because I couldn't figure out how to.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Import specific columns past a certain row into another spreadsheet.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.

  5. #5
    Registered User
    Join Date
    08-10-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    20

    Re: Import specific columns past a certain row into another spreadsheet.

    1010101010
    Last edited by Nexion21; 08-10-2013 at 08:54 PM.

+ 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] Import specific data from multiple text files to an excel spreadsheet
    By westerp in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-02-2012, 04:51 PM
  2. vba only import columns from csv with specific text in row A
    By CuvelieY in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-17-2011, 09:41 AM
  3. Import specific cells from a user chosen spreadsheet
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-30-2009, 02:06 PM
  4. Replies: 2
    Last Post: 09-19-2005, 10:05 AM
  5. import data to specific columns
    By marlea in forum Excel General
    Replies: 1
    Last Post: 08-11-2005, 10: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