K
Kumar
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 Month’s 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 Total’s for
my Data as Shown in 3rd Sheet (Final Output).I Need the MACRO for this
Process.
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 Month’s 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 Total’s for
my Data as Shown in 3rd Sheet (Final Output).I Need the MACRO for this
Process.