Re: $$Excel-Macros$$ Fwd: Help required for formule

Check the attachment see if it helps On Tue, Nov 30, 2010 at 11:35 AM, Jagadeesh B S wrote: > > Hello Friends > > I need a formula or macro( preferabley formule) need to prepare this report > . > > I need a formula which should get the details for the account # mentioned > in the column A with

$$Excel-Macros$$ Fwd: Help required for formule

Hello Friends I need a formula or macro( preferabley formule) need to prepare this report . I need a formula which should get the details for the account # mentioned in the column A with the reference to the currency,form the sheet DATA, if the currency is USD It should pull the value in the colu

$$Excel-Macros$$ Re: issue with Data validation

I have mailed you back your sheet as I have been unable to attach it here ... I have used an IF ( ) function to solve your problem in case you need any assistance in implementing the solution or there is something which is not proper pleas let me know. Regards, Anand Kumar On Nov 29, 3:26 pm, ani

$$Excel-Macros$$ Re: headcout dashboard report

Hi, Just mailed you a few dashboards which I had collected from different sources on internet. Hope they solve your visualization problem. In case you have something specific in mind do let us know. Regards, Anand Kumar On Nov 29, 9:19 pm, bhavya khanna wrote: > Hi All, > > Can someone explain

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

Sir, Thanks for the prompt action, But I have a Data of 9000 Employees. I have to Send the Letters to Employees without using the Mail Merge. Only with The Hlp of Concatenate. Eg. ="Your Salary is increased with Rs. "&A1&"/- Please find enclosed attachment which contains the breakup of amount"

Re: $$Excel-Macros$$ help required

for alphabets, have filter as "equal to *" & filter as "greater than 0" for numerals On Tue, Nov 30, 2010 at 7:09 AM, Srinivasan Ethirajalu < srinivasan.ethiraj...@gmail.com> wrote: > Have a filter "greater than 0" > > > On Mon, Nov 29, 2010 at 11:55 PM, Aamir Shahzad > wrote: > >> Hi expe

Re: $$Excel-Macros$$ help required

Have a filter "greater than 0" On Mon, Nov 29, 2010 at 11:55 PM, Aamir Shahzad wrote: > Hi experts, > > > > Can anybody resolve the below issues: > > > > 1) More than one value from vlookup function > > > > 2) In office 2007 how I use custom filter e.g. > > 123 > > 456 > > 789 > > Abc

$$Excel-Macros$$ help required

Hi experts, Can anybody resolve the below issues: 1) More than one value from vlookup function 2) In office 2007 how I use custom filter e.g. 123 456 789 Abc Efg Hij Klm If value begins with alphabets or number I want only alphabets or numbers. Your early respo

Re: $$Excel-Macros$$ Selecting specified information from within a cell under a condition and paste that information to a second sheet

It worked perfectly, a thousand thank you for your help :) 2010/11/29 ashish koul > try this > > Sub Macro1() > Dim z As Long > >Sheets("Folha1").Activate > If Sheets("Folha1").FilterMode Then > Sheets("Folha1").ShowAllData > End If > >Sheets("Folha1").Range("a65356").Select >

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

Dear Team, I Checked the appendedlinks, It only shows the Format, I want my output in bold format. Thanks On Nov 29, 3:54 pm, roberto mensa wrote: > 2010/11/29 Chandra Shekar > > > Hi, > > > Pls check this site it might help you. > > >http://www.mrexcel.com/forum/showthread.php?t=20611 > > >

$$Excel-Macros$$ headcout dashboard report

Hi All, Can someone explain about headcount report in dashboard .how to make . If some one has idea plz explain about that or send useful sheet. Thanks -- -- Some important links for excel users: 1. Follow us on TWI

Re: $$Excel-Macros$$

Thanks a million Dave. You have just served it on a platter for me. Simply awesome. But would request you to explain the steps if possible as I am a begginer in excel. What I could decipher is that You have formed a separate column and have put the formula. Then you have formed a separate drop

$$Excel-Macros$$ How to set up:payments made and due on a calendar?

In XL2000, I have a calendar set up. I can set the month and year, and formulas create the calendar for that month and about the next two weeks of the next month. On another sheet, I can list events (example: client name, date and time of event, activity), and the info shows up in the calendar on

$$Excel-Macros$$ 'Automatic' change to Line Chart from XY Scatter Chart

Hello, I've been working with (x,y) data which is typically ordered in groups, but the groups are unordered (e.g. points 50->100 then points 151->101 then points 49->1). I add the appropriate index (x-value) and then re-order the data based on that index. The index is a distance (in metres) and

Re: $$Excel-Macros$$ Selecting specified information from within a cell under a condition and paste that information to a second sheet

try this Sub Macro1() Dim z As Long Sheets("Folha1").Activate If Sheets("Folha1").FilterMode Then Sheets("Folha1").ShowAllData End If Sheets("Folha1").Range("a65356").Select Selection.End(xlUp).Select z = ActiveCell.Row Sheets("Folha1").Range("$A$6:$J" & z).AutoFilter Fi

Re: $$Excel-Macros$$

of course is: =OFFSET($B$1,SMALL(IF(MONTH($D$2:$D$29)=11,ROW($B$2:$B$29)),ROW(A1))-1,) regards r 2010/11/29 roberto mensa > =OFFSET($B$1,SMALL(IF(MONTH($D$2:$D$29)=3,ROW($B$2:$B$29)),ROW(A1))-1,) > > CTRL+SHIFT+ENTER > drag down > regards > r > > 2010/11/28 Anindya Roy > > Suppose I have a fi

Re: $$Excel-Macros$$

=OFFSET($B$1,SMALL(IF(MONTH($D$2:$D$29)=3,ROW($B$2:$B$29)),ROW(A1))-1,) CTRL+SHIFT+ENTER drag down regards r 2010/11/28 Anindya Roy > Suppose I have a file which contains names of the candidates along with > their date of birth. Now if i want to sort out names which have birthday > falling in t

Re: $$Excel-Macros$$ Guidance needed for intercompany reco...stmt..

without a sample sheet with your data is not understood your request regards r 2010/11/29 Jagadeesh B S > Hello all, > > Could someone please help me for my requirement > > Thanks in advance > Jagadeesh B S > > On Fri, Nov 26, 2010 at 12:44 PM, Jagadeesh B S wrote: > >> Hello all >> >> I

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

2010/11/29 Chandra Shekar > Hi, > > Pls check this site it might help you. > > http://www.mrexcel.com/forum/showthread.php?t=20611 > > Thanks > > Chandra Shekar > get.cell returns (not set) information about the formatting, location, or contents of a cell. A function used in a formula can return

$$Excel-Macros$$ issue with Data validation

Dear All, Please help me on Data Vadidation :-) I have issue in multi validation I want in first cell A1 Anil & B1 I want list of anil like 5 name & second is A2 Sunil & B2 list 4 names. Thanks & Regards Anil Kumar --

Re: $$Excel-Macros$$ Guidance needed for intercompany reco...stmt..

Hello all, Could someone please help me for my requirement Thanks in advance Jagadeesh B S On Fri, Nov 26, 2010 at 12:44 PM, Jagadeesh B S wrote: > Hello all > > I need to prepare the reconciliation report for my company and send it to > all the person who is responsible for their a/c. >

Re: $$Excel-Macros$$ Bold a Text with Help Of Formula

Hi, Pls check this site it might help you. http://www.mrexcel.com/forum/showthread.php?t=20611 Thanks Chandra Shekar On Mon, Nov 29, 2010 at 4:23 AM, roberto mensa wrote: > with UDF you can not: > look here: > > http://spreadsheetpage.com/index.php/oddity/a_user_define_function_cant_change_t

Re: $$Excel-Macros$$ Salary sending problem

Hi Again, I can generate in PDF for that u will require to have Office 2007, but password protection is not possible at present. Is it OK. Sent on my BlackBerry® from Vodafone -Original Message- From: Ankit Agrawal Date: Mon, 29 Nov 2010 11:42:43 To: Cc: Subject: Re: $$Excel-Macros