to Read content from one excel file and paste that in master excel in one column

Hi,

I want to read a particular application from a excel (current) and count it the number of times it has appeared in the excel.
Then in my master excel i have defined these applications, i want to create a column with name as "Aug 20" and corresponding to the application in excel it should add the count in master excel.
If there are not applications found in current excel then in master excel i want to add the count value to corresponding application in master excel as 0.

Please let me know how this can be achieved. I am not getting the logic to do this :(

Thanks!

Moved From The CodeBank (which is for sharing code rather than posting questions :) )

You could start by adding reference to Microsoft Excel Object Library in your application. Then, familiarize with Excel classes such as worksheet, workbook, range and etc...
There, you can open/add columns and format excel values and the like..

Cheers!

You could start by adding reference to Microsoft Excel Object Library in your application. Then, familiarize with Excel classes such as worksheet, workbook, range and etc...
There, you can open/add columns and format excel values and the like..

Cheers!