Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I Subtotal, then Sort by Subtotal Amounts? | Excel Discussion (Misc queries) | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
Bolding the subtotal lines automaticlly When using the Subtotal fu | New Users to Excel | |||
copy subtotal value only, subtotal value can be vlookup by others | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |