$$Excel-Macros$$ Re: EmEditor Macro

2014-07-16 Thread Sandes Bagwe
this is urgent On Thursday, July 17, 2014 11:43:00 AM UTC+5:30, Sandes Bagwe wrote: > > Hello All, > > Anyone can help me on EmEditor Macro? > > > d="131" > restype="x-p" > phase-name="pretrans">Good morning mtype="seg" > mid="1">Good morning mty

Re: $$Excel-Macros$$ common kgid no problem

2014-07-16 Thread Vaibhav Joshi
Cheers!! On Thu, Jul 17, 2014 at 11:25 AM, daya p wrote: > Sir, > thanks a lot > it is very helpful to me & my friends to work easy > to complete work within seconds > > thank you ince again > > from: > Daya > > > > > > On 16 July 2014 19:08, Vaibhav Joshi wrote: > >> Refer this.. i made it mo

$$Excel-Macros$$ EmEditor Macro

2014-07-16 Thread Sandes Bagwe
Hello All, Anyone can help me on EmEditor Macro? d="131" restype="x-p" phase-name="pretrans">Good morningGood morning Shall it become id="131" restype="x-p" phase-name="pretrans">Good morningGood morning*Good morning*"> I have 5000 files and I need to run thi

$$Excel-Macros$$ Fwd: Interview Question,(QUIZ)

2014-07-16 Thread Satendra kumar
Dear All, Please share answer of below question in your own words.. *Questions* 1] write vba code if list >=0 then Red and <0 then green. 2) write functun in excel to sort a list. 3. Extract a emp name based on emp ID. 4. Year=2004, name=ibm and Segment=AT&T then extract value from tabl

Re: $$Excel-Macros$$ common kgid no problem

2014-07-16 Thread daya p
Sir, thanks a lot it is very helpful to me & my friends to work easy to complete work within seconds thank you ince again from: Daya On 16 July 2014 19:08, Vaibhav Joshi wrote: > Refer this.. i made it more dynamic! > > Cheers!! > > > On Wed, Jul 16, 2014 at 6:43 PM, Vaibhav Joshi wrote:

Re: $$Excel-Macros$$ Re: Multiple Web Page Extraction

2014-07-16 Thread Pramod Singh
Hi Bill, The website is so heavy so it is taking lot of time to load .I am also working on it from another method. Regard Pramod On Thu, Jul 17, 2014 at 7:23 AM, Bill Q wrote: > Pramod, > > Would you have any idea why it stops ? > > On Monday, July 14, 2014 7:16:58 AM UTC-4, Bill Q wr

Re: $$Excel-Macros$$ Re: Consolidating Multiple Categories from Separate New Workbooks Each Week

2014-07-16 Thread Sean M
Hi, Thanks for your response. I have spent a little while going over the code to figure out what is going on. I really like the filename parsing for determining what column to put data in. That will be very useful. I don't think I explained the consolidating objective well enough and I am hopin

$$Excel-Macros$$ Re: Multiple Web Page Extraction

2014-07-16 Thread Bill Q
Pramod, Would you have any idea why it stops ? On Monday, July 14, 2014 7:16:58 AM UTC-4, Bill Q wrote: > A great first effort Pramod. I called it up a few times. I always get the > same 3 first lines returned - then I get the following error from your code > and it stops: > > wk.Cells(i,

$$Excel-Macros$$ Re: Excel commands to Electronic user interface.

2014-07-16 Thread The Frog
Hi Charles, To interface with the 'outside world' as such you need to have a method of communication. Typically you would use something like a serial or network interface to send / receive commands to a programmable logic controller (PLC) and the controller would then do the actual work of firi

$$Excel-Macros$$ Excel commands to Electronic user interface.

2014-07-16 Thread Cab Boose
Hi Looking for vba requirements for exporting commands (on, off, etc) to a relay board for control of led lights etc. Can someone send me in the right direction etc. Do I need an add-in or activate some controls. Using 2000 at the moment but shortly onto Excel 2013. Thankyou Charles Harri

$$Excel-Macros$$ Data Logging

2014-07-16 Thread Cab Boose
Hi There are a lot of commercial software based around Excel for live logging of incoming data from instruments etc. Where can I find a site that covers the vba required for receiving data. Say direct from data recorders and/or thru SMS and a website. That is a temperature is sent by SMS from a

$$Excel-Macros$$ Conditional Formatting for a cell based on another

2014-07-16 Thread Ahmed Emam
I have an excel sheet and i want some cells to be highlighted by some colors if other 3 cells filled by text. please see the attached example: What i mean that Cell A to be highlighted Yellow if Cell A1 filled by text And to be highlighted Blue if Cell B1 filled by text And to be highlighted Gree

$$Excel-Macros$$ Urgent required QA Tester (Manual UI) - Anoka, MN

2014-07-16 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com * *Position: QA Tester (Manual UI Tester) (4 positions)Location: Anoka, MNDuration: Long term* Best Rate: $40-42/hr MAXX Note: *Need complete educational details along with two professional references from two most recent projects at the time

Re: $$Excel-Macros$$ VBA to populate cells based on cirteria

2014-07-16 Thread Paul Schreiner
You're welcome!   I just figured that if I simply supplies the formula, there would be some that would like to see how it came together, so I'd just take care of that right away!  Paul - “Do all the good you can, By all the means you can, In all the ways y

Re: $$Excel-Macros$$ VBA to populate cells based on cirteria

2014-07-16 Thread Renton Cheung
Hi Paul. This works quite well. Such a solution with well explanation! Thank you! On Wed, Jul 16, 2014 at 11:07 PM, Paul Schreiner wrote: > > I used this formula in Cell E2: > > =IF(OR((COLUMN()-4)=$C3,MOD((COLUMN()-4)-$C3,$D3)=0),$B3,"") > > then copied it to the other cells. > > Basically, it

Re: $$Excel-Macros$$ VBA to populate cells based on cirteria

2014-07-16 Thread Vaibhav Joshi
Vry well explained Paul!! Cheers!! On Wed, Jul 16, 2014 at 6:37 PM, Paul Schreiner wrote: > > I used this formula in Cell E2: > > =IF(OR((COLUMN()-4)=$C3,MOD((COLUMN()-4)-$C3,$D3)=0),$B3,"") > > then copied it to the other cells. > > Basically, it uses two concepts: > the "Data" portion occupi

Re: $$Excel-Macros$$ VBA to populate cells based on cirteria

2014-07-16 Thread Paul Schreiner
  I used this formula in Cell E2:   =IF(OR((COLUMN()-4)=$C3,MOD((COLUMN()-4)-$C3,$D3)=0),$B3,"")   then copied it to the other cells.   Basically, it uses two concepts: the "Data" portion occupies (4) cells. A:D, so the column for year 1 is in column E. so, column() - 4 gives the "Year Number" of 1

Re: $$Excel-Macros$$ common kgid no problem

2014-07-16 Thread Vaibhav Joshi
hi do you want output to be shown in excel sheet? On Wed, Jul 16, 2014 at 2:10 PM, daya p wrote: > Hi Friends, > > I need your help to find common kgid no (like aadhar card no) which is > entered in A,B,C,D .up to n th column (up to n no of section) > i tried conditional formatting, its to

$$Excel-Macros$$ VBA to populate cells based on cirteria

2014-07-16 Thread Huard
Dear experts, I need your help to populate the cells in the attached spreadsheet. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,

$$Excel-Macros$$ Transpose column to row basis column heading

2014-07-16 Thread Prakash Gusain
Hi All, Attached file has two tabs (Raw Data & OutCome). What I am trying to achieve is transposing column F & G of the Raw Data onto OutCome tab. The catch is to transpose basis the role which is listed as heading of Outcome tab. If in the list we have more than open person with similar role

Re: $$Excel-Macros$$ Re: How to direct multiple hyperlink ?

2014-07-16 Thread Pramod Singh
Yah this can be done I am busy right now .when I have time I must solve this one.. Pramod On 16 Jul 2014 12:37, "Nitya" wrote: > Dear Pramod sir, > > Can we get the link in exel too. I mean if the link data is pulling the > data from web, than the same link should be capture with res

$$Excel-Macros$$ common kgid no problem

2014-07-16 Thread daya p
Hi Friends, I need your help to find common kgid no (like aadhar card no) which is entered in A,B,C,D .up to n th column (up to n no of section) i tried conditional formatting, its too slow and not for regular work so i need macro code. The problem here is how to find out the kgid Nos who wo

$$Excel-Macros$$ common kgid no problem

2014-07-16 Thread daya p
Hi Friends, I need your help to find common kgid no (like aadhar card no) which is entered in A,B,C,D .up to n th column (up to n no of section) i tried conditional formatting, its too slow and not for regular work so i need macro code. The problem here is how to find out the kgid Nos who

Re: $$Excel-Macros$$ Re: How to direct multiple hyperlink ?

2014-07-16 Thread Nitya
Dear Pramod sir, Can we get the link in exel too. I mean if the link data is pulling the data from web, than the same link should be capture with respect to its row. and than loop to next link, same the running link should be pasted in its respective rows till all the link is completed pulling d

Re: $$Excel-Macros$$ Change date format

2014-07-16 Thread Ashish Bhalara
Oh Thanks to both of you, its very easy...Cheers!! Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Wed, Jul 16, 2014 at 12:29 PM, Amresh Maurya wrote: > see the attachment > > > On Wed, Jul 16, 2014

Re: $$Excel-Macros$$ - merge and pivot excels

2014-07-16 Thread pradeep palande
Hello .. Need urgent help on this please.. Thanks. On Mon, Jul 14, 2014 at 8:49 PM, pradeep palande wrote: > Okay Pramod.. first of all Thanks for your quick response. > > I assume below is the help you needed to move forward on this topic. > > - There are 35 to 40 excels in similar format i r