Thread: Subtotal
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
  
Posts: 3,101
Default 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.
Reply With QuoteReply With Quote