I am writing a macro, which will take an excel sheet as input, process the data and after processing the data, will create a new excel sheet with the processed data.
In the input excel sheet, there will be some blank row, which I need to be ignored. But i can't get how to fetch the whole row at a instance.
The input excel sheet will be as img1 attached -
when there will be a new currency, the previous set will be subtotalled and a blank row will be there before the next section. There is no limit on the number of currency.
The output excel should be as img2 attached - same as img1 except the subtotalled rows and the blank rows between two sections.
The logic I applied as make a cell active and iterate over a loop until the active cell is empty. But in this logic only the three row will be printed in the new excel sheet.
Please suggest how to implement this.
Thanks and Regards,