Re: $$Excel-Macros$$ Security Manager :: Boston, MA

2012-11-01 Thread Amol Shrivastava
Moderator plz ban all this.. On Fri, Nov 2, 2012 at 9:52 AM, Satendra kumar wrote: > Yes Kuldeep you are right... > > > On Fri, Nov 2, 2012 at 9:50 AM, Kuldeep Singh wrote: > >> >> Hi Ankush, >> >> It's not a job posting portal, So don't post any job mail. Keep posting >> only excel

$$Excel-Macros$$ Re: QC results update tool

2012-11-01 Thread Nevin
HI Rajan/Friends, Thanks for your intrest in helping me. Objective of the tool is to update all the test case results in QC from an excel file through macros which inturn will avoid manual work. We have around 1200 TC's for every execution and once we develop it as tool it will reduce a lot

$$Excel-Macros$$ Senior Project Manager :: Boston, MA

2012-11-01 Thread Ankush Chaudhary
Hi Partners, DIRECT CLIENT - In person interview is needed. Location: Boston, MA Duration: 9+ months Rate: Open C2C/W-2 (37.5 hrs/week) Skills Needed: . Minimum 3 years of project management experience in a technology environment . Proven track record of delivering large-scale proj

$$Excel-Macros$$ Security Manager :: Boston, MA

2012-11-01 Thread Ankush Chaudhary
Hi Partners, DIRECT CLIENT - In person interview is needed after TELEPHONIC ROUND. Location: Boston, MA Duration: 6+ months Rate: open/hr C2C Skills Needed: . Experience should include security policy development, security education, network penetration testing, applic

$$Excel-Macros$$ Re: QC results update tool

2012-11-01 Thread Nevin
> > Hi Friends, > Can anyone please help me with the code which is used to establish the connectivity between HP ALM and macros and also to update some fields in ALM. Regards Nevin -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (11

Re: $$Excel-Macros$$ Pls help

2012-11-01 Thread Rohan Young
Hi, try this, Ctrl+F, put value in Find What, Find All, Ctrl+A and then Esc regds On Thu, Nov 1, 2012 at 8:30 PM, karthikeyan sankaran < karthikeyansankar...@gmail.com> wrote: > Hi, > > How to select particular cell value within one click.I need to select > value 2 only. > without using macr

$$Excel-Macros$$ sharepoint to acces

2012-11-01 Thread Rakesh Joshi
Hi- Our team is currently using an Infopath form in SharePoint but looking to move to an Access database. We would like to be able to use as a resource request and have questions posted to the Access database. Does anyone know if this is something that can be done in Microsoft Access- and if

Fwd: $$Excel-Macros$$ How to delete alternate sheets faster

2012-11-01 Thread Pravin Gunjal
*Hi Paul,* * * *Could you please inform me the full code, so that I can apply it in the attached file for test purpose and later on in my original file for use.* * * *And thanks to all for their solutions too.* * * *Regards* *Pravin Gunjal* -- Forwarded message -- From: Paul Schrei

Re: $$Excel-Macros$$ How to delete alternate sheets faster

2012-11-01 Thread Paul Schreiner
Yeah, Sam.. I thought about that. But he said he had 43 sheets! (OK, he's "only" deleting 21) That's kind of a cumbersome array to manage, although I'm sure it could be done.   Paul - “Do all the good you can, By all the means you can, In all the ways you can

Re: $$Excel-Macros$$ How to delete alternate sheets faster

2012-11-01 Thread Sam Mathai Chacko
Another way would be to create an array of sheet names and the delete it accordingly. So even if you go with a positive Step, it would still work. Based on the suggestions above, you can come up with the loop... however, in the end, the array should be passed like this ThisWorkbook.Sheets(Array(

Re: $$Excel-Macros$$ How to delete alternate sheets faster

2012-11-01 Thread Ahmed Honest
Dear Pravin, Use the solution which suit your need and meets your requirement. But my solution will be something like this : By holding Ctrl Key and by using Mouse click select the sheets you wish to delete. Once the selection of sheets is done --- right click and choose delete --- this will dele

Re: $$Excel-Macros$$ excel macros for pasting to selected range

2012-11-01 Thread Paul Schreiner
I tried it and it worked fine. However, I didn't spend the time to create a bunch of drop-down menus. I just used some data I already had. Maybe the problem is with copying the selected values of the drop-downs. perhaps if you posted your file? (or an edited version) Otherwise, we could spend a

Re: $$Excel-Macros$$ How to delete alternate sheets faster

2012-11-01 Thread Paul Schreiner
That's not going to work out well. Let's say you have 11 sheets the Sheets() array looks like: Sheets(1).Name = "One" Sheets(2).Name = "Two"  Sheets(3).Name = "Three"  Sheets(4).Name = "Four"  Sheets(5).Name = "Five"  Sheets(6).Name = "Six"  Sheets(7).Name = "Seven"  Sheets(8).Name = "Eight"

Re: $$Excel-Macros$$ Macro for Find

2012-11-01 Thread Shrinivas Shevde
Dear Vijay File is not working Regards Shrinivas On Tue, Oct 30, 2012 at 6:31 PM, Vijay Kr. Aggarwal < vjaggarwal2...@gmail.com> wrote: > Hi Shrini, > > First sheet:- Raw Data > Second Sheet :- Criteria is given in this sheet. > third sheet :- Final output would be pasted here by using criteri

Fwd: $$Excel-Macros$$ How to delete alternate sheets faster

2012-11-01 Thread Pravin Gunjal
*It would be better... * -- Forwarded message -- From: Aamir Shahzad Date: Thu, Nov 1, 2012 at 12:13 PM Subject: Re: $$Excel-Macros$$ How to delete alternate sheets faster To: excel-macros@googlegroups.com Dear Noorain Sir, Can you ammend your code that when we run macro, a

Re: $$Excel-Macros$$ need solutions

2012-11-01 Thread rajeyssh
Hello Satendra Thanks for the help. One more thing I want to know If I want to do this from other file and process how can I put this formula in the sheet. Once again thanks On Wednesday, October 31, 2012 1:29:03 PM UTC+5:30, Satendra kumar wrote: > > Hi, > > Find Another solution i think this is