Subtotal
 

If any One Can Give me any Mail Address i can attach my file to be more
Clear ........ I need a MACRO for my EXCEL Work book which contains 3
Work sheets (Raw Data, Final Data, Sub Total), The 1st Sheet (Raw Data) Sheet
Contains the Centre name & Supplier Names with different Months Data€¦ and
the Data Varies from Expenditure to Expenditure (there may be 150 rows / 450
rows /80 columns), Now I Need to delete the First 2 columns of which 1st
Column is Blank (No Data) and 2nd Col is Particulars and I Need to remove the
Blanks in between the Rows. And I Need to Replace the €œCr€� Balance with
€œ€“€œand €œDr€� With Blank. And the Data from APR- OCT should be in Number
Format. Which is shown in 2nd Sheet (Final Data). Now I Need Sub Totals for
my Data as Shown in 3rd Sheet (Final Output).I Need the MACRO for this
Process.

Subtotal
 

I'll try


"Kumar" wrote:

If any One Can Give me any Mail Address i can attach my file to be more
Clear ........ I need a MACRO for my EXCEL Work book which contains 3
Work sheets (Raw Data, Final Data, Sub Total), The 1st Sheet (Raw Data) Sheet
Contains the Centre name & Supplier Names with different Months Data€¦ and
the Data Varies from Expenditure to Expenditure (there may be 150 rows / 450
rows /80 columns), Now I Need to delete the First 2 columns of which 1st
Column is Blank (No Data) and 2nd Col is Particulars and I Need to remove the
Blanks in between the Rows. And I Need to Replace the €œCr€� Balance with
€œ€“€œand €œDr€� With Blank. And the Data from APR- OCT should be in Number
Format. Which is shown in 2nd Sheet (Final Data). Now I Need Sub Totals for
my Data as Shown in 3rd Sheet (Final Output).I Need the MACRO for this
Process.