Update Work Book with a macro

[tkraju]

I have a w/book named as Sales Report xlsm file > file path > C:\Users\Raju\Sales Report.xlsm

I have to update this w/book data with 2 csv files which I down load > file paths are >>>
C:\Users\Raju\Dropbox\PC\Desktop\Mumbai.csv > > variable data exisis *
C:\Users\Raju\Dropbox\PC\Desktop\New Delhi.csv >> variable data exists **
I need a macro to update Sales Report using above source csv files.

Task: Check Mumbai csv file data exists or not in Sales Report w/book > If Mumbai csv sheet “A2” date exists in Sales Report sheet entire column B > macro gives msg “Data Already Exists” > Exit macro after accepting msg result > If Mumbai csv sheet “Ä2” date not found in Sales Report column B > Copy variable data of Mumbai csv sheet (“A2: E”) and paste them in Sales Report last row (B :F) > Copy variable data of New Delhi csv sheet(“Ä2:E”) and paste them in Sales Report last row(H:L) > Msg “sheet Updated”. > End Sub.

If I rerun this macro > macro should give msg “Data Already Exists”
Macro has to run from Sales Report w/book
Csv files * and ** in both files variable data exists some times one row and some times more than 2 rows.

 

[OaklandJim]

You'll have to help me out if I can assist.

I need a macro to update Sales Report using above source csv files.

What does update mean? You'll have to be more specific.

What worksheet(s) in the workbook are updated? Are there two worksheets: one each for Mumbai and New Delhi? How do the worksheet(s) get updated.

It sounds like there is a third worksheet that is named Sales Report too?

Where does the csv data get placed?

Task: Check Mumbai csv file data exists or not in Sales Report w/book

What does the workbook have in it that indicates that the "csv file data exists"?

Sorry but this is confusing.

If Mumbai csv sheet “A2” date exists in Sales Report sheet entire column B > macro gives msg “Data Already Exists”

Might you share the workbook and csv files with fake but realistic data? Put files into Dropbox. Use the link icon above the message area.

 

[tkraju]

You'll have to help me out if I can assist.

What does update mean? You'll have to be more specific.

What worksheet(s) in the workbook are updated? Are there two worksheets: one each for Mumbai and New Delhi? How do the worksheet(s) get updated.

It sounds like there is a third worksheet that is named Sales Report too?

Where does the csv data get placed?

What does the workbook have in it that indicates that the "csv file data exists"?

Sorry but this is confusing.


Might you share the workbook and csv files with fake but realistic data? Put files into Dropbox. Use the link icon above the message area.

Thank you. I have clearly mentioned w/book Sales Report (Destination w/book) has to be updated using Mumbai.csv and New Delhi csv files (source files). Before updating Sales Report W/book > check whether Mumbai.csv file data exists or not in Sales Report w/book > Conditional check to this initial task is to check Mumbai csv file A2 ( date field) exists or not in Sales Report w/book Column B> if the date(Mumbai csv A2 date value) exists in Sales Report > that means the W/book already updated > If the said date not exists in Sales Report w/book > Copy dynamic data ranges from Mumbai csv & New delhi csv and paste them in Sales report destination columns/rows. Mumbai csv and New delhi csv files data varies every day as I download them daily or few days interval.

 

[OaklandJim]

We have a language issue. And you did not answer my questions.

Start by answering these questions: How many worksheets are in the workbook? What are their names?

Try showing the data. Use Mr. Excel's excellent add-in called XL2BB that enables you to post a portion of the workbook. Show us what cell(s) contain the date(s).

 

[OaklandJim]

See XL2BB - Excel Range to BBCode for details about XL2BB.