Hi All,

I have an excel sheet (*.csv) format system generated sheet. In the sheet I need to search for a word that starts with "ser" and all the information that is below the "ser" row needs to be grouped with summation.

I would like to create a master file that pulls information from the *.csv file into another sheet in the required format.

Example:
I have around 10 columns with data. In the Col A, there is a word starts with "ser" (alphanumeric with hyphens "-" in between). Now there is data below such row having the "ser".

Now I would like to have all these rows below "ser" to be grouped automatically with summation of all the 10 columns data (column wise sum).


Need your suggestion if anyone have a better idea.

Thanks in advance. Expecting a quick reply.