Help! Automate linking data

P

penroma

I am creating 14 reports (each have their own tab) in an Excel workbook.
I pull the information for the reports from a CSV file. Currently, I
am manually opening both the CSV sheet and the Excel workbook and
linking Excel cells to CSV cells. I am using one sheet in the CSV file
to populate information on the 14 sheets in the Excel workbook. The
CSV file and the Excel workbook are on a shared drive. The CSV file is
updated early every morning through an automated process.

Is there a way to automate populating the Excel cells with the CSV
data? I would like to schedule this so that when I come in to work,
the Excel workbook is already populated.

I am novice at this type of thing, so I am hoping this is not over my
head.

Any assistance is appreciated!
 
C

Chris W

I don't know if you can automate the process without creating a macro. If your 14 tab workbook is already linked to the CSV then you should be able go to Edit, Links and click update now.
 
P

penroma

I agree that a macro will be needed to automate this, I am just not sure
how to write the macro.
 
Top