Re: $$Excel-Macros$$ Query.

Hi, PFA On Tue, May 1, 2012 at 11:53 AM, Pramod Kumar wrote: > Hi Experts, > PLease solve my query. > > I need age betbeen in two dated like as ""2 year 3 Month) > > -- > Regards, > Pramod Kumar > Technocare Solution(TCS) > Rudrapur > +91 9927033573 > E-Mail:-kumar.pramod03i...@gmail.com > >

$$Excel-Macros$$ Query.

Hi Experts, PLease solve my query. I need age betbeen in two dated like as ""2 year 3 Month) -- Regards, Pramod Kumar Technocare Solution(TCS) Rudrapur +91 9927033573 E-Mail:-kumar.pramod03i...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thre

Re: $$Excel-Macros$$ Help required on how to create iterative formula

In your spreadsheet d will always be a - all the other deductions therefore row 19 will always be zero. Is that what you wanted? If so you could replace all the row 19 formulas with 0 The label for row 13 (G ESIC) is (a+b+c) x 4.75 % but the formula is b+c+d x 4.75%. Which should it be? If r

Re: $$Excel-Macros$$ Help required on how to create iterative formula

Dear All, Please at least let me know if it is not possible... Regards, Milin On Mon, Apr 30, 2012 at 12:01 PM, Milin Sulakhi wrote: > Dear All, > > Please help me with below mentioned query. > > > On Sat, Apr 28, 2012 at 10:05 PM, Milin Sulakhi wrote: > >> Dear Rajan, >> >> What will be that

Re: $$Excel-Macros$$ Need help to make good format of report

Thanks Noorain for replying, but I'm not able to understand this file. I would request you all to solve my problem with combo box, I would be very thankful to you. Kindly solve my problem according to my format. Thanks Karan Singh On Tue, May 1, 2012 at 12:49 AM, NOORAIN ANSARI wrote: > Dear

$$Excel-Macros$$ Re: Find column # of first value greater than specified value?

Let me rephrase: Eventually I'll have one of two words in a row of cells (e.g. "up" or "down") and I want to know which one comes first. How can I get Excel to tell me whether the *first* instance of "up" or "down" comes in an earlier column? -- FORUM RULES (986+ members already BANNED for vio

Re: $$Excel-Macros$$ Re: Find column # of first value greater than specified value?

My 2 cents What I understand is row 8 has data today price minus previous day price. So in row 7 you can give: =if(d7<1,"down","up") Sent on my BlackBerry® from Vodafone -Original Message- From: Filip Houdek Sender: excel-macros@googlegroups.com Date: Mon, 30 Apr 2012 20:26:18 To: Rep

$$Excel-Macros$$ Re: Find column # of first value greater than specified value?

Here is an example. I want to check row 8 ("Price move") to see whether a value greater than 1 or less than -1 comes first, and return "up" or "down" in a specified cell based on which comes first ("up" if 1 comes first and "down" if -1 comes first). Eventually I want to check the next 30 value

Re: $$Excel-Macros$$ data download from different Sites, Through VBA Coading

Thank you Mahesh On Friday, April 27, 2012 12:02:35 AM UTC+5:30, Mahesh wrote: > > Hi > > you can do it through web queries. Check below link. > http://www.jkp-ads.com/Articles/WebQuery.asp > > HTH > Mahesh > > On Wed, Apr 25, 2012 at 8:59 AM, prince sethi wrote: > >> Hi >> >> Can you plea

RE: $$Excel-Macros$$ problem in copy paste

Hi Yasir, Do you have Skype installed? See http://answers.microsoft.com/en-us/office/forum/office_2010-excel/text-loses -formatting-when-i-use-cut-copy-paste/0371d013-1e5a-4d2b-874f-792d34d16c61?a uth=1 for more details and fix. Asa From: excel-macros@googlegroups.com [mailto:excel-mac

RE: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file

Hi Pascal! Not sure what you mean by "optical hard drive" (HDs use electromagnetic heads). I have not had the chance to try your scripts, and I haven't relally played with Scripting.FileSystemObject, but some quick thoughts for you-- File locking and permissions are controlled by the OS and

RE: $$Excel-Macros$$ Re: Hi friends, I want to know

Hi Anil, How to copy multiple sheets between workbooks: https://office.microsoft.com/en-us/excel-help/move-or-copy-sheets-HP00520146 9.aspx How to create linked cells: http://www.keynotesupport.com/excel-linking-worksheets.shtml How to create a QueryTable: http://www.dicks-clicks.com/excel/Extern

Re: $$Excel-Macros$$ Insert row after every unique name

thanks Don, but when I save file as add in & create tab then this code not working kindly brief and where below code will apply Sub test() ' from other excel file Application.Run ("youraddin.xlam!macroname") End Sub Aamir Shahzad On Tue, May 1, 2012 at 12:55 AM, dguillett1 wrote: > Applicati

Re: $$Excel-Macros$$ Insert row after every unique name

Application.Run "youraddin.XLAM!macroname", _ Sub test() ' from other excel fileApplication.Run ("youraddin.xlam!macroname") End Sub1- Open a new Workbook. 2- Add a macro that contains the code MsgBox("Add-In") 3- Save as xlam file. 4- Open new Workbook. 5- Click Office Button -> Excel Op

Re: $$Excel-Macros$$ Insert row after every unique name

thanks Don, can you tell me? if I save this code to .xlam (add in) format then how I recall this macro. Aamir Shahzad On Sat, Apr 28, 2012 at 5:28 PM, dguillett1 wrote: > Use this macro in a macro enabled workbook > > Sub insertrows() > Dim i As Long > On Error Resume Next > For i = Cells(Row

Re: $$Excel-Macros$$ Need help to make good format of report

Dear Karan, Please find the attached solved query, Hope it will help to you. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Apr 30, 2012 at 9:11 PM, Karan Singh wrote: > Thanks for replying and your solution, but I know very well that I can

Re: $$Excel-Macros$$ change color depending from cell value

another solution =IF(ISBLANK(B3),"",IF(AND(B3="green",B2="red"),30,0)) Aamir Shahzad On Mon, Apr 30, 2012 at 6:33 PM, dguillett1 wrote: > And, if you really want only change from red to green, add And LCase(c) > = "green" > > Sub checkmatchwithblanks() > Dim c As Range > For Each c In Range(

$$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file

Hi cyberspace, I have 2 vba scripts with the same purpose, create and write to a text file. The 1st script works fine when creating and writing the file to my optical hard drive and doesn't work on my flash drive. The 2nd script works fine on both optical and flash drive. I wonder if the issue

RE: $$Excel-Macros$$ Re: Find the cell value from other sheet

Hi What Error ? can you please share .. ? Rajan verma http://www.facebook.com/buzinesstransformation www.ExcelPowerUser.blogspot.com From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of prabhat.shrivasta...@

Re: $$Excel-Macros$$ formula required for count or count if

Hi Sara, PFA Regards Lalit Mohan https://www.facebook.com/buzinesstransformation On 4/27/2012 10:00 AM, Sara Lee wrote: hi i have data as in the attached data. i need count of unique values of column A i.e i need output as in column AB, AC... pls advise a formula thanks -- FORUM RULES

$$Excel-Macros$$ Re: Find the cell value from other sheet

thanks don for your kind help, rajan, your function giving some error... anyways thanks a lot to you both, this is really very to seeing people helping other with their skills Thanks Ashish for creating such a nice group with good people like, Don, Rajan, Noorain, Dipilthanks buddy for

$$Excel-Macros$$ Financial Analysis Dashboard

Hi Guys, i just completed my Financial Analysis Dashboard, pls have a look at it at the address below cheers http://www.sendspace.com/file/tlim30 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, N

Re: $$Excel-Macros$$ Need help to make good format of report

Thanks for replying and your solution, but I know very well that I can do this with filters. But my dear I need this in that excel format which I'v posted on group. I need to automate this file with combo box as I have to give this to my seniors and they dont have much knowledge of excel. So I woul

Re: $$Excel-Macros$$ change color depending from cell value

And, if you really want only change from red to green, add And LCase(c) = "green" Sub checkmatchwithblanks() Dim c As Range For Each c In Range("b4:b24").SpecialCells(xlCellTypeConstants) If c <> c.Offset(-1) And LCase(c) = "green" Then c.Offset(, 4) = 30 Next End Sub Don Guillett Microsoft MVP

Re: $$Excel-Macros$$ change color depending from cell value

Sub checkmatchwithblanks() Dim c As Range For Each c In Range("b4:b24").SpecialCells(xlCellTypeConstants) If c <> c.Offset(-1) Then c.Offset(, 3) = 30 Next End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Shaik Waheed Sent: Monday, April 30, 2012 3:31 AM To:

RE: $$Excel-Macros$$ Find the cell value from other sheet

Try this: =IF(SUM(--(NOT(ISERR(FIND(A1,Sheet1!A1:P21,1),"Found","Not Fond") If will find the string if string Exists in anywhere in cell Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: 30 April 2012 18:

Re: $$Excel-Macros$$ Find the cell value from other sheet

=IF(SUMPRODUCT(--(LEFT(Sheet1!$A$1:$P$21,5)=Sheet2!A1)),"Found","Not Found") Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: prabhat.shrivasta...@gmail.com Sent: Sunday, April 29, 2012 9:34 PM To: excel-macros@googlegroups.com Subject:

Re: $$Excel-Macros$$ Re: Hi friends, I want to know

If you don't want a macro and you don't want to open suggest a LOT of linking formulas. You could then use edit>replace to change the name of the source workbook (if needed) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: anil kumar S

Re: $$Excel-Macros$$ Need help to make good format of report

Can you just use data>filter>autofilter on the data sheet. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Karan Singh Sent: Monday, April 30, 2012 7:21 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need help to make good format of report Dear All

Re: $$Excel-Macros$$ Re: Hi friends, I want to know

Hello sir, How r u, there is no need of sample sheet, simply u have 4-5 workbook of any data. and now u have to copy all data from 4-5 workbook. than we have to open 1 by 1 workbook and copy in 1 sheet. now i want to know that can i open 1 sheet from that 4-5 workbook copy all data in 1 sheet.

Re: $$Excel-Macros$$ change color depending from cell value

IF(AND(B3="green",B2="red"),30,IF(AND(B3="red",B2="green"),30,IF(AND(B3="red",B2=""),30,IF(AND(B3="",B2="red"),30,0 From: pawel lupinski To: "excel-macros@googlegroups.com" Sent: Monday, April 30, 2012 2:45 PM Subject: Re: $$Excel-Macros$$ change color dep

Re: $$Excel-Macros$$ change color depending from cell value

Thanks a lot for this but what if there will be more then 1 empty cells e.g. gap will be 4 cells. See attachment.   regards,   Pawel From: Shaik Waheed To: excel-macros@googlegroups.com Sent: Monday, April 30, 2012 9:31 AM Subject: Re: $$Excel-Macros$$ change c

Re: $$Excel-Macros$$ change color depending from cell value

Hi, PFA On Mon, Apr 30, 2012 at 5:11 AM, pawel lupinski wrote: > Hi All, > > I'm asking you for help, I have a problem with compering two cells base on > conditions. There is no problem if everything is running in order, but if > there is a gap ... there is wrong answer given, pls see attachmen

Re: $$Excel-Macros$$ Re: Hi friends, I want to know

Hi Anil,   can u share sample sheet with example.     Regards LAKSHMAN From: anil kumar To: excel-macros@googlegroups.com Sent: Monday, April 30, 2012 12:35 PM Subject: Re: $$Excel-Macros$$ Re: Hi friends, I want to know I exprot data from busy in 5 workbook. a

Re: $$Excel-Macros$$ Re: Hi friends, I want to know

I exprot data from busy in 5 workbook. and now i open 1 workbook wnat to copy other 4 workbook data in open workbook -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code