+ Reply to Thread
Results 1 to 4 of 4

Import data from an excel spreadsheet into another excel table with a different format

  1. 02-07-2022, 02:39 PM #1
    Track Coach
    Track Coach is offline
    Registered User
    Join Date
    02-07-2022
    Location
    Charlotte, NC
    MS-Off Ver
    V16.57
    Posts
    2

    Import data from an excel spreadsheet into another excel table with a different format

    Attached is an excerpt from a spreadsheet. I need to take the data from the spreadsheet and put it into a new excel spreadsheet in a table with a different format.
    I know Excel basics but I am stuck with this task. Thank you.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-10-2022, 11:05 AM #2
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,565

    Re: Import data from an excel spreadsheet into another excel table with a different format

    Hello Track Coach and Welcome to Excel Forum.
    1. Select cell C17
    2. Paste the following into the formula bar:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    3. Press the Enter key
    4. Drag the fill handle down to cell C33
    5. While C17:C33 are still selected drag the fill handle over to cell I33
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
  3. 02-10-2022, 12:57 PM #3
    Track Coach
    Track Coach is offline
    Registered User
    Join Date
    02-07-2022
    Location
    Charlotte, NC
    MS-Off Ver
    V16.57
    Posts
    2

    Re: Import data from an excel spreadsheet into another excel table with a different format

    JeteMc: Thank you so much for the quick reply and efficient solution! Have a great day!!!
    Reply With QuoteRegister To Reply
  4. 02-10-2022, 01:42 PM #4
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,565

    Re: Import data from an excel spreadsheet into another excel table with a different format

    You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do you import data from one spreadsheet to another in Excel?
    By Jay Sarfati in forum Excel General
    Replies: 2
    Last Post: 05-17-2018, 07:30 PM
  2. Import data from Google Spreadsheet to Excel
    By Avivi24 in forum Excel General
    Replies: 1
    Last Post: 08-28-2017, 04:35 AM
  3. Import from Access table into Excel spreadsheet dependant on multi search criteria
    By DannyJ in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-28-2016, 10:07 AM
  4. [SOLVED] Need to import Data from multiple Excel file in a Excel Table.
    By aatif0712 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-23-2015, 07:39 AM
  5. [SOLVED] How do I import data from a closed Excel Spreadsheet?
    By Tomcat in forum Excel General
    Replies: 2
    Last Post: 05-30-2006, 07:55 AM
  6. [SOLVED] How do I import data from RightFax into an Excel spreadsheet?
    By Barbie in forum Excel General
    Replies: 1
    Last Post: 01-04-2006, 11:25 PM
  7. Can you import data from a scanner into an excel spreadsheet?
    By vas in forum Excel General
    Replies: 2
    Last Post: 09-08-2005, 04:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1