Macro to compare the 3 columns "SEC Code [Closed]

Question

Macro to compare the 3 columns "SEC Code [Closed]

Report

Kaef - Updated on Feb 13, 2018 at 04:32 PM
Blocked Profile - Feb 13, 2018 at 05:01 PM

Hi All,

I would really appreciate your help in providing me with a macro to save me some time on the following.

1- Everyday i receive 2 reports in .txt that i convert to excel after reorganizing the data (dlimit)
2- Once the 2 sheets are created in excel the columns are as follows
SYSTEM A SEC CODE ACCT TDATE F ROC AMT

Is there any way that a macro will be able to compare the 3 columns "SEC CODE" "Trade date" and "ACCT" and if these 3 numbers together matches between the 2 sheets create a new sheet with all the information of these rows from sheet 1 and sheet 2.

In addition to that i would need on the new sheet 3 to have an extra row that will sum the ROC AMT for the columns that have the same data simultaneously in the 3 columns "SEC CODE" "Trade date" and "ACCT"

Thanks
Kaef

Macro to compare the 3 columns "SEC Code
Excel macro to compare two columns and write to a third ✓ - Forum - Excel
Compare values in two columns and return the value from third ✓ - Forum - Excel
Comparing data in 3 columns on a Microsoft Excel spreadsheet ✓ - Forum - Excel
Compare 3 Columns excel ✓ - Forum - Excel
Macro to compare two columns in excel and highlight differences ✓ - Forum - Excel

1 reply

Ask a question

Blocked Profile · Answer 1 · 2018-02-13T17:01:50-0500

Answer 1 / 1

Blocked Profile
Feb 13, 2018 at 05:01 PM

The syntax for inspecting the value of a cell is as follows:


thevariable = ThisWorkBook.WorkSheets(sheet_name).Range(cell_reference).value

Now just make your logic for who wins!

Macro to compare the 3 columns "SEC Code [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!