Hello

I am new to Excel VBA and I am having a tough time writing a VBA to convert a set of data in sheet 1 to one in sheet 2(I am enclosing that as a Excel document"Test -Original").I have described what needs to be done (step by step ) below.

Could you please help ?Any input will be greatly appreciated

Thanks

Raja

Develop a macro

1. I have a report from SAP BW, the original format of which is in sheet 1.I need to develop a macro using VBA and need the report with the format in sheet 2.

2. I need a “Results “row after every Bill to Party in column A as below(screen shot 1.doc):

P.S: The number of customers is dynamic i.e.it keeps changing every month

4. Nothing needs to be done to column.SAP BW will not overwrite the format and the data in column G.Hence leave it as it is.

5. Calculate the number of Sales document numbers for each customer and put the value of 1 for every value. If it is blank it should not be counted and put the value of 0 for those rows. (Shown below) Display the sum of the number of sales document numbers in the results row for column H

6. In the column I, put the value of 1 if the difference column (column G) is 0 and put the value of 0 if the value in the difference column (column G) is any value apart from 0.now sum the value in the results row for each customer and display the summation value in the results row under column I

7. Compute the percentage which is the values in (column I/Column J)*100 .This should be done only for the results row

I am new to Excel VBA and I am having a tough time writing a VBA to convert a set of data in sheet 1 to one in sheet 2(I am enclosing that as a Excel document"Test -Original").I have described what needs to be done (step by step ) below.

Could you please help ?Any input will be greatly appreciated

Thanks

Raja

Develop a macro

1. I have a report from SAP BW, the original format of which is in sheet 1.I need to develop a macro using VBA and need the report with the format in sheet 2.

2. I need a “Results “row after every Bill to Party in column A as below(screen shot 1.doc):

P.S: The number of customers is dynamic i.e.it keeps changing every month

4. Nothing needs to be done to column.SAP BW will not overwrite the format and the data in column G.Hence leave it as it is.

5. Calculate the number of Sales document numbers for each customer and put the value of 1 for every value. If it is blank it should not be counted and put the value of 0 for those rows. (Shown below) Display the sum of the number of sales document numbers in the results row for column H

6. In the column I, put the value of 1 if the difference column (column G) is 0 and put the value of 0 if the value in the difference column (column G) is any value apart from 0.now sum the value in the results row for each customer and display the summation value in the results row under column I

7. Compute the percentage which is the values in (column I/Column J)*100 .This should be done only for the results row

## Comment