Re: $$Excel-Macros$$ IF Function

2010-08-25 Thread NOORAIN ANSARI
Dear Vebhav, Please see attachment with solution. Thank,s Noorain On Thu, Aug 26, 2010 at 9:39 AM, vebhav jain wrote: > Hi All, > > Please find the attachment, where i finding the difficulty to get the right > solution.I have narrated the problem clearly in the excel file. > > Thankyou, > Vebhav

Re: $$Excel-Macros$$ IF Function

2010-08-25 Thread Kal xcel
Dear Vebhav, Your problem is solved, see the attachment. Kalyan On Thu, Aug 26, 2010 at 9:39 AM, vebhav jain wrote: > Hi All, > > Please find the attachment, where i finding the difficulty to get the right > solution.I have narrated the problem clearly in the excel file. > > Thankyou, > Vebhav

Re: $$Excel-Macros$$ Help Required ----

2010-08-25 Thread rsPrashant
Hi Venkat, I was wondering if you could do away with simple sort command. Given below is the result i got after sorting the provided data. Emp id Product C1101 A C1104 A C1107 A C1110 A C1113 A C1116 A C1119 A C1102 B C1105 B C1108 B C B C1114 B C1117 B C1120 B C1

$$Excel-Macros$$ IF Function

2010-08-25 Thread vebhav jain
Hi All, Please find the attachment, where i finding the difficulty to get the right solution.I have narrated the problem clearly in the excel file. Thankyou, Vebhav Jain -- -- Some important links for excel users: 1

$$Excel-Macros$$ Re: creat box and copy information into it

2010-08-25 Thread siti Vi
If you mean with TextBox please see workbook at http://www.box.net/shared/nh5zl1vvhh Regards, siti On 25 Agu, 17:39, Steen wrote: > Hi > i'll try to tell whta i'm trying to at what my problem is hope that > you  understand what i'm trying to do. > i have made Work break sturcture, which describ

$$Excel-Macros$$ Re: Hi guys I need your help again.

2010-08-25 Thread siti Vi
Hi, why not using Keyboar-ShortCut: Ctrl + PgUp and Ctrl+PgDown Regards, siti On 23 Agu, 21:21, shariqcoo...@gmail.com wrote: > Hi, > Can any one tell me how we can link the macro code to hyperlink. > I want to navigate the sheet by click the next or previous by using > Activesheet.next.sel

$$Excel-Macros$$ Help!?

2010-08-25 Thread Mike
Thanks in advance! 1. I am using MS Excell 2007 2. Problem: I have a Column of serial #'s and they are listed low to high. Some of the Serial # are listed once, some twice and some 3 times. 3. I want to alternate shading for each set of the same serial #'s. EX: 276CHK0130 276CHK0130 276CHK0131 27

$$Excel-Macros$$ Creating an XPath function in Excel

2010-08-25 Thread Illithian
I've been using Google Docs with the importXML function to pull information off many external XML feeds at the same time. This has been very useful but I'm starting to have a lot of trouble, specifically in that Google Docs is limited to only 50 such functions on any given spreadsheet, and I need s

$$Excel-Macros$$ Code to enter value in multiple worksheets

2010-08-25 Thread Kurt
I have 4 worksheets (WS1, WS2, etc.) with cells that get populated with data from a linked source sheet. In Column B on each worksheet is a dynamic range of cells (on WS1 it's "WS1Data," WS2 it's "WS2Data," etc.) When rows in the range are blank, I'd like to insert the word "no data." I can do thi

Re: $$Excel-Macros$$ Lookup Multiple values and display horizontally

2010-08-25 Thread Maries
Hi! Shine, Pls. find the attached file. This is also one of the way to solve your query by using V LOOKUP. Regards, Maries On Mon, Aug 23, 2010 at 5:32 PM, wrote: > Attached: Lookup Multiple values and display horizontally > Message from shin...@gmail.com: > > Hi > > It would be helpful if s

Re: $$Excel-Macros$$ Help Required ----

2010-08-25 Thread Venkatesan c
Dear Kalyan, My Correct Requirement Is Attached below On Wed, Aug 25, 2010 at 4:30 PM, Kal xcel wrote: > Hi venkat, > > VLOOKUP formula will solveyour problem, see the attachment. > > On Wed, Aug 25, 2010 at 3:15 PM, Venkatesan c wrote: > >> Dear Group, >> >> I have attached sample data belo

Re: $$Excel-Macros$$ Help Required ----

2010-08-25 Thread Kal xcel
Hi venkat, VLOOKUP formula will solveyour problem, see the attachment. On Wed, Aug 25, 2010 at 3:15 PM, Venkatesan c wrote: > Dear Group, > > I have attached sample data below i want to get defined criteria Emp id's. > Can i have any formula's or Macros > > Best Regards, > * > > Venkat > * >

Re: $$Excel-Macros$$ Formula Correction

2010-08-25 Thread Kal xcel
Dear Jay, Problem is solved. See the attachment. On Wed, Aug 25, 2010 at 2:26 PM, lucky singh wrote: > > Hi, > > Need help in formula... > > I just need the only the first name to be extracted without space or gap... > > Regards, > Jay S > 8108932708 > > -- > > -

Re: $$Excel-Macros$$ Formula Correction

2010-08-25 Thread Norman May
Jay Try putting the following formula in cell C3: =LEFT(B3,FIND(" ",B3,1)) Norman On Wed, Aug 25, 2010 at 4:56 AM, lucky singh wrote: > > Hi, > > Need help in formula... > > I just need the only the first name to be extracted without space or gap... > > Regards, > Jay S > 8108932708 > > -- > > -

$$Excel-Macros$$ creat box and copy information into it

2010-08-25 Thread Steen
Hi i'll try to tell whta i'm trying to at what my problem is hope that you understand what i'm trying to do. i have made Work break sturcture, which describes some given taks FX Taks Start dateend date design12-aug-2010 20-sep-2010 these information i would lik

Re: $$Excel-Macros$$ Formula Correction

2010-08-25 Thread NOORAIN ANSARI
Dear Lucky, Please find attachement with solution. Thanks, Noorain Ansari On Wed, Aug 25, 2010 at 2:26 PM, lucky singh wrote: > > Hi, > > Need help in formula... > > I just need the only the first name to be extracted without space or gap... > > Regards, > Jay S > 8108932708 > > -- > > ---

$$Excel-Macros$$ Excel automatic download from web

2010-08-25 Thread zheng yu
Hi Excel Gurus, I have been working with excel,VBA, C++ for 2 years. lately I have come across this task where I need to download this excel sheet from web page. I have no idea how to automate the downloading .Can some gurus give some tips and help? any advice is welcome. The web page

$$Excel-Macros$$ Help Required ----

2010-08-25 Thread Venkatesan c
Dear Group, I have attached sample data below i want to get defined criteria Emp id's. Can i have any formula's or Macros Best Regards, * Venkat * -- -- Some important links for excel users: 1. Follow us on TWITTE

$$Excel-Macros$$ Formula Correction

2010-08-25 Thread lucky singh
Hi, Need help in formula... I just need the only the first name to be extracted without space or gap... Regards, Jay S 8108932708 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

$$Excel-Macros$$ Re: Hi guys I need your help again.

2010-08-25 Thread Kishan Reddy, K
Alternate proposal Instead of creating the links in each sheet dynamically, I think it is easy to create a customised toolbar with two buttons for your purpose, which can be used on any sheet, that is active. Regards, Kishan Reddy, K On Aug 23, 7:21 pm, shariqcoo...@gmail.com wrote: > Hi, > > C