Need "Macro" to import CSV file into excel worksheet - Reg.

[bala04msw]

Dear Forum Experts,

I would like to get your support and guidance on the following requirements.

1. I have a excel workbook for my project analysis, which has 3 worksheets (A, B & C).

2. "A" worksheet has the master record (People come for counseling service on every month) and its the dynamic record (Every month data will be keep on adding). Data is not directly entered here in this sheet. The data is shared by other people as CSV file, we just copy and paste the data.

3. "B" and "C" worksheets have preprogrammed descriptive data analysis tables. When "A" worksheet data changes, "B" and "C" data will be changing. This works perfectly.

Challenges:

1. As said above, "A" worksheet data is not directly entered here in this sheet. Manually copied from other sheet and paste it here. Due to manual copy and paste process, data error is happening.

Requirements

1. Need to set "Macro" to import CSV file data into "A" worksheet.

Kindly do the needful.

Regards

[mehmetcik]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[bala04msw]

Dear Mr. Mehmetcik,

First of all, thanks for your reply with guidance. As you suggested, I have attached two excel worksheet, respectively names are Doc 1 - Analysis sheet, includes, Master_record (Sheet 1) and formula based pre templated data analysis tables (Sheet 2) are there. Doc 2 - Data transferring Sheet.

Process: Now, I have to import Doc 2 (Master_Record - Sheet 1) data (from 3rd Row to complete sheet) into Doc 1 - Master_record (Sheet 1). I need macro support to import this data.

Other points: In Doc 1 - Master_record as of now only 5 entries are there and Doc 2 - Master_record, there are 15 entries are there. Now I need to transfer this 15 entries to Doc 1.

Regards


Regards

[bala04msw]

Dear All,

thanks for everyone. I found the solution and given code below for your reference. Works perfectly.

Please Login or Register  to view this content.