Menu

Macro for Sub total

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.misc

galimi

galimi is offline

external usenet poster

Posts: 210

Default

Macro for Sub total

Kumar,

Feel free to email me @ the address shown below.
--
http://www.ExcelHelp.us

Call me at
1-888-MY-ETHER ext. 01781474

"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 Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Worksheet Total and Macro	RHoskins	Excel Worksheet Functions	0	September 16th 08 03:47 PM
Macro to total values with certain criteria...	neilcarden	Excel Worksheet Functions	2	December 3rd 07 08:06 PM
How does a macro total columns when sheets have diff row counts?	Chuck@qgold	Excel Discussion (Misc queries)	1	April 20th 07 04:24 PM
Macro that counts the Nbr of Teams and calculate the total & Ratio	Jurassien	Excel Discussion (Misc queries)	0	March 6th 07 05:20 PM
Macro Total Sum	Joey	Excel Discussion (Misc queries)	1	August 8th 05 08:11 PM

All times are GMT +1. The time now is 06:46 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement