Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Moving data from CSV to Excel sheet

Basically trying to take data from csv files and populate the Columns in a
excel migration excel sheet template Cut & Paste seem like the worse
option€¦€¦anything else out there I could use to help? I need move the data in
selected columns in the CSV file and have them populate columns in the excel
sheet. In most cases the columns will not have the same name I will need to
select where they go€¦..is there a function/tool/process that can do this
without me having to copy and paste from one sheet to the other? Im not
very Excel savvy€¦so detail is welcomed ïŠ
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JCS JCS is offline
external usenet poster
 
Posts: 93
Default Moving data from CSV to Excel sheet

Hi,

Sounds like you want to automate this process and the only way to do this is
through a macro. Macros allow you to automate repetitve tasks. Sorry I
couldn't give you an easier/better way.

John

"Darren20" wrote:

Basically trying to take data from csv files and populate the Columns in a
excel migration excel sheet template Cut & Paste seem like the worse
option€¦€¦anything else out there I could use to help? I need move the data in
selected columns in the CSV file and have them populate columns in the excel
sheet. In most cases the columns will not have the same name I will need to
select where they go€¦..is there a function/tool/process that can do this
without me having to copy and paste from one sheet to the other? Im not
very Excel savvy€¦so detail is welcomed ïŠ

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
moving data from a form to another sheet Kimberly Heffernan Excel Worksheet Functions 1 March 13th 08 02:29 AM
Moving data in one excel column to another sheet based on user input [email protected] Excel Discussion (Misc queries) 1 May 10th 07 05:47 PM
moving data from one sheet to another David Excel Discussion (Misc queries) 3 February 1st 07 04:58 PM
Moving data from one sheet to another automatically holyman Excel Discussion (Misc queries) 2 July 4th 06 02:44 PM
Moving data from one sheet to another- How to? mbqc Excel Worksheet Functions 2 May 8th 06 06:05 AM


All times are GMT +1. The time now is 07:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"