Macro for copying csv

**Jignesh2012** · 04-14-2011, 05:20 AM

HiGuys, need help to write a macor:

Here is my requirement.
I have a daily Status Code report which has 5 sheets
Sheet1:- Overview - This has calculations from other 4 sheets
Sheet2:- Today- This has todays order data which I want to import from a orders.csv automatically
Sheet3:- Yesterday - This should have yesterdays orders which we currently manually copy daily from Today's sheet before overriding it with today's Order
Sheet4:- Today's Outstanding Order - This sheet has todays outstanding orders which I want to import it from outstandingorders.csv automatically
Sheet 5:- Yesterdays Outstanding Order- This should have yesterdays orders which we currently copy daily from Todays Outstanding Order before overriding it with Todays Outstanding Orders

What I want:
A Macro with following steps,
1) When the excel is opened, clear Sheet3 and Sheet5.
2) Move Sheet2 data to Sheet3
3) Move Sheet4 data to Sheet5
4) Automatically read the orders.csv file from its location (Local) and copy data to Sheet2
5) Automatically read the outstandingorders.csv file from its location (Local) and copy data to Sheet4
6) Sheet 1 which uses this 4 sheets expected to calculate on its own.

Can anyone help me on writing this macro.
My knowledge on macro is zero.

Have attached Status Code report and the sample csv files (zip file) .Please note that number of records will differ daily in the csv files.

I appreciate all the help.

Thanks
Jignesh

**pike** · 04-15-2011, 05:10 AM

Hello,

this is a pretty big request in one chunk. I'm sure you'll get better response if you break down your question into several parts, so that they can be tackled one after the other.

Also, we're happy to help you with your effort, but nobody here will be keen on developing a solution from scratch.

godd place to starthttps://sites.google.com/a/madrocket...svs-to-1-sheet

**Phil_V** · 04-15-2011, 05:55 AM

Please see the attached.

I have tried to document the macro code, but if your knowledge is truely zero then it may not help a huge amount.

Still the code is below for reference;

Private Sub Workbook_Open()

EDIT
Don't know why I bothered. If you want the solution then at least follow up the thread.
Workbook and solution removed until a reply from the OP is received.