Re: $$Excel-Macros$$ Insert row based on criteria

2011-02-26 Thread Diamond Dave
I'm also trying it insert a row, but in my example, I want to insert in after the "SubTotal" after using the "subtotal function" adding the blank row after the subtotal line. How would you modify the macro in your example to accomplish this? Dave On Feb 26, 12:44 am, Mahesh parab wrote: > Hi Ja

$$Excel-Macros$$ inserting a sample file

2011-02-26 Thread Diamond Dave
How do you insert a sample fine to the inital discussion message? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN

$$Excel-Macros$$ Macro to Average a series of numbers in excel

2011-02-24 Thread Diamond Dave
Expert Team, I’m struck. What I’m trying to do is create a macro that will average a series of numbers and replace the numbers in the predefined series with that average number. Currently I’m assuming two variables. One macro for a set of 4 numbers, and one set for a series of 5 numbers. The fol

$$Excel-Macros$$ SubTotal and Insert Req

2011-02-24 Thread Diamond Dave
Team, 1'm looking for support with the "SubTotal" function in excel 2007 or 2010. I'm looking to insert a blank row between the subtal line, and the next group. Note: the subtoal line exists in column A. Any Ideas? Thanks for your support -- --

$$Excel-Macros$$ Special Suffix Identification

2011-02-18 Thread Diamond Dave
: original number: wyl-927-TH would read TH, wyl-987 would be blank, WMF-123-MX would show MX Any help in sorting out this problem would be appreciated. if there is a formual that could be incorporated into a macro or just a stand alone macro either will work for me. Thanks Diamond Dave