Compare 2 sheets, match data in 1 column, update row in sheet 2 & add new rows not matched

hi Synchronicity, welcome to ExcelForum, please check attachment, run code "test".

The code actually recreates sort of .csv file so it would be more logical to have a file dialog option to select .csv file with data to import. If you approve this option, please provide original .csv file I will amend the code.

Wow that was fast! This looks really promising! I like the idea of pulling from the file instead of having to make a new sheet. Let me test this out and see how it works. Thanks watersev!

Hi watersev! Here are the new files. One is the CSV you requested, the other is a new master file. I have added two columns at the end of the master file that I will be populating with formulas later. It looks like the code does exactly what I need it to do! And as a bonus it doesn't appear to overwrite more columns than necessary so I am hoping the new columns for formulas are safe.

Is it possible for the macro to copy cells in these new columns (the future formulas) to the end of the table when new rows are added? I was hoping to have a formula in column "I" that would search for the text "eai-incident" in column "H" and record a 1 if found and a 0 if not found. Then another simple formula in "J" that does some basic calculations. I was hoping the macro could copy them down and save me the manual step. Not sure if this is the right place to ask though.

Anyway, I really appreciate the help. This will save me a lot of time.

~CS

please check attachment, press Run and choose csv-file to import data from. I've added some simple formula to I2:J2 to visualize that code extends existing formula till the last data row.

Perfect! Thank you! This is exactly what I needed! I appreciate the effort.

Spoke too soon. Tried it with some real data and got an error. Looks like it is related to their being too much data in the H, "Description" column cells. At least if I take the sample CSV and add several lines of text to that cell and copy down I can replicate the error with the dummy file. Here are some screen shots.Debug error.jpgRun-time error.jpg

I did tried converting to 2010 with no luck. I was able to modify the existing sample file to reproduce the error so I will provide that shortly along with what I did. Thanks again!

Okay, now I am confused. I am uploading the three files I am using. Here is a brief description:

SAMPLE OFFICIAL MASTER_UPDATED v3.xlsm - This is the file with the code. I updated the formulas and saved as an xlsm 2010 format.
051612-FROM TAB-D.csv - This is a sample data file that fails.
051612-FROM TAB-D-1.csv - This is the same file as above, but I copied cell H2 down about 1,000 rows.

As noted, I updated the MASTER sheet to a 2010 format and made some changes to the formulas in columns I and J. I doesn't look like it has to do with the amount of data in the individual cells. This last export 051612-FROM TAB-D-1.csv I truncated that field so you will see it doesn't have a lot of data. However, importing the file fails. I tried to isolate if it was a particular cell in that column that was causing it to fail but didn't have any success. I changed 100 rows at a time and couldn't isolate it. But when I duplicate about 1,000 cells then the import succeeds. Does that make sense?

So the second file 051612-FROM TAB-D-1.csv is just the first 1000 cells of that column copied down.

SLA REPORT v3.zip

please check attachment (tested on the sample files provided)

This looks good so far. Still testing. Thanks a lot!

All testing went well. Thanks again!

Thanks in advance.
am looking same macro but am not able to capture any data here.

Please can any one help on this how to Compare 2 Sheets & Copy Non Matching Data in separate sheet.

Thanks
Mohan

Excel Problem
Sheet 1...Received
Date From Do NoS Item Qty Units
10-Oct-13 XY Traders 321 Pencil 27 Nos
11-Oct-13 AAB tools 2013 Grinder 2 Nos
12-Oct-13 SS Traders 3098 Pen 27 Nos
Sheet 2...Issued
Date From Do No Item Qty Units
11-Oct-13 XY Traders 321 Pencil 6 Nos
12-Oct-13 AAB tools 2013 Grinder 1 Nos
19-Oct-13 SS Traders 3098 Pen 13 Nos
Sheet 3...Summary
Date From / To Do No Item Received Issued Balance
10-Oct-13 XY Traders 321 Pencil 27
11-Oct-13 AAB tools 2013 Grinder 2
11-Oct-13 XY Traders 241 Pencil 6
12-Oct-13 SS Traders 3098 Pen 27
12-Oct-13 AAB tools 2013 Grinder 1
19-Oct-13 SS Traders 3098 Pen 13

I need updated entry for sheet 3 date wise whatever enter sheet 1 and sheet 2

Pls guide
Regards
raja