Re: $$Excel-Macros$$ discussexcel.com Launched today

Hi Ayush, Congrats to you and the team. Regards Umesh On Mon, Mar 21, 2011 at 10:08 PM, neil johnson wrote: > Hi , > Congratulation to you sir > On 3/20/11, Ayush Jain wrote: > > Dear Excel Group Members, > > > > I am very glad to share that* discussexcel.com < > http://www.discussexcel.com> >

Re: $$Excel-Macros$$ Please Help

Hi Sudhir, In the excel sheet which you have send me, for the party name "b" on 14th March you have mentioned 1700 as the pending amount. My question is How do you come to arrive at this figure? 1700 Regards Umesh On Mon, Mar 21, 2011 at 9:13 PM, sudhir kumar wrote: > Hi, > > Thanx and It'

Re: $$Excel-Macros$$ Find all NamedRanges in Worksheet/workbook

hi hanumant if your text in A1 as " =Sheet1!$F$4:$F$7 " type the below formula anywhere in the worksheet =MID(SUBSTITUTE(SUBSTITUTE(TRIM(SUBSTITUTE(A1,"$","")),"=","")," ",""),2,LEN(TRIM(SUBSTITUTE(SUBSTITUTE(TRIM(SUBSTITUTE(A1,"$","")),"=","")," ","")))-2) -- *Thanks & Regards Thamu * On

$$Excel-Macros$$ Need coding help!

Hello- I have a data set that has lists of names that recorded the person in position each year. For a study, I need to create a column for each year that records the years the person in that position. For example, if Johnson Smith was in the position in the first year, I recorded 1; the next year

$$Excel-Macros$$ Remove a missing reference that is in use

Hello, When my work converted to Office 2010 a spreadsheet that I maintain started throwing error messages. When I check my references there is a reference listed that is missing: MISSING: Microsoft Calendar Control 11.0 I thought it would be easy and I could just uncheck the reference as the

Re: $$Excel-Macros$$ Find all NamedRanges in Worksheet/workbook

Dim nm as name, r as long For each nm in thisworkbook.names r = r + 1 Cells(r, 1) = nm.Name Cells(r, 2) = nm.address(false, false) Next On 3/18/11, wrote: > Hi friends, > > i want to find out all the namedranges from worksheet / workbook. can > somebody > please help me. > > eg. lets say A1 to

Re: $$Excel-Macros$$ Find all NamedRanges in Worksheet/workbook

Hi Guys, thanks for your reply. i wanted macro for this. from the code generated i tried this selection.listanames but it gives values as " =Sheet1!$F$4:$F$7 " so i will have to remove this = sign using replace or is there any way where i will get same data without = sign. also, just for the sak

Re: $$Excel-Macros$$ discussexcel.com Launched today

Hi , Congratulation to you sir On 3/20/11, Ayush Jain wrote: > Dear Excel Group Members, > > I am very glad to share that* discussexcel.com > *website is launched today. The website development was initiated three > months back and here is what I achieved. As promised

Re: $$Excel-Macros$$ discussexcel.com Launched today

Ayush first of all congratulations & thanks a lot for your valuable inputs on excel & Macros. This is a very good platform for everyone who ever wants to learn excel. On Mon, Mar 21, 2011 at 19:21, Ayush wrote: > Thank everyone ! > > Regards > Ayush Jain > > -- > > -

Re: $$Excel-Macros$$ Please Help

Hi, Thanx and It's feel good to see done with macro. And how to copy it to my main workbook. Meaning of Pending Amount : It mean's payment which was not collected yet. Regards Sudhir On 21/03/2011, Umesh Dev wrote: > Hi Sudhir, > > Check if its working. I have done it for only "Running Balance

$$Excel-Macros$$ Personal Budget Tracker

Dear members, One of our group member 'Abi Joseph' has shared the Personal Budget Tracker template. I have uploaded the template on the discussexcel.com. If you are interested in the template, Please visit the below URL. http://www.discussexcel.com/downloads Thanks Abi :) Regards Ayush Jain -

Re: $$Excel-Macros$$ Bug Rectification required for Random Data Selection Macro.

Hi Friends, Is there any updates on my below query... On Fri, Mar 18, 2011 at 1:42 AM, Mariappan Kulasekaran wrote: > HI Team, > > I have written a code for selecting random data from master data. Please > find the checkpoints below. > > Data Format: > >- Master Data will have n number of r

Re: $$Excel-Macros$$ discussexcel.com Launched today

Thank everyone ! Regards Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.

RE: $$Excel-Macros$$ Excel formula for a BOQ

Try : Sub test2() Dim c As Range, inRow As Long For Each c In Range([A4], Cells(Rows.Count, 1).End(xlUp)).SpecialCells(xlCellTypeConstants) If Cells(c.Row, 7).Value = "" Then inRow = Range(Cells(c.Row, 7), Cells(c.Row + 1000, 7)).Find("*", , xlValues).Row Cells(c.Row, 7

Re: $$Excel-Macros$$ Help on TL Recital Snapshot

an *array formula* =IFERROR(INDIRECT(C3)," ") is written in a range C5:H20 at once !! about array formula: http://www.cpearson.com/excel/ArrayFormulas.aspx http://office.microsoft.com/en-us/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx but before you do it, you have to define

Re: $$Excel-Macros$$ Please Help

Hi Sudhir, Check if its working. I have done it for only "Running Balance". I am not clear with the " Pending Amount" the numbers are contradicting in the format which you had attached. if you can let me know how it is done. I can rework the code. Regards Umesh Dev On Sat, Mar 19, 2011 at 12:15