Moving data from CSV to Excel sheet

D

Darren20

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? I’m not
very Excel savvy…so detail is welcomed ïŠ
 
J

JCS

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Macro to open CSV files 6
large amount of data moving to excel 1
Can Not get cell to accept any format change! Source from html 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Function or Formula help - get data from another sheet 10
Importing multiple lines into Excel from txt. 3
from .asc to .excel 2

Top