$$Excel-Macros$$ Agile Architect California

2021-06-11 Thread Om Prakash Reddy
Hi, We are looking for Agile Architect California Agile Architect Primary Skill: Archer, Secondary Skill: Agile Methodology Location: California Certification : Archer 6.x * Archer 6.x Associate and Professional Certification * Hands on experience in RSA Archer GRC platform an

$$Excel-Macros$$ Palo Alto Firewall Engineer at Chicago, IL

2021-06-10 Thread Om Prakash Reddy
Hi, We have an immediate opening for Palo Alto Firewall Engineer at Chicago, IL Responsibilities 1. Implementing Palo Alto firewalls 2. Palo Alto High Availability configuration 3. Deployment of PA in different scenarios ,large environments . 4. VPN Configuration in Palo Alto 5

$$Excel-Macros$$ Remote Recruitment Manager Position without Placement Target.

2021-06-09 Thread Om Prakash Reddy
anks! Om Prakash -- 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, accurate thread titles. Poor thread titles, like Please Help, Urgent, N

$$Excel-Macros$$ Vendor Updation

2021-06-07 Thread Om Prakash Reddy
Good Afternoon! Om Prakash here, working on our vendor database! Please find the below link to get connect yourself with us. Keep my email id also added to your address book. Submit Your Email ID: https://forms.gle/snD8g1mf96kb72mZ8 Telegram Group: https://t.me/joinchat/H0POJ_mA79U0ODhh

$$Excel-Macros$$ DO YOU HAVE ANY CONSULTANT WHO IS WORKING FOR ANY BANK?

2021-06-02 Thread Om Prakash Reddy
rectly call me to discuss more about the position right at (734) 408 4698 **We can schedule interview with 4 workings hours with our client and we have really good control over the position, Kind Regards! Om Prakash | V2 Innovations Inc Phone: (734) 408 4698 Email:

$$Excel-Macros$$ INVESTMENT BANKING DOMAIN .NET POSITION

2021-06-02 Thread Om Prakash Reddy
Good Afternoon, My name is Om Prakash, dedicated to source IT Resource for V2 Innovations Inc. Currently I am working on .net (Investment Banking) position. Client needs the professional to have core investment banking domain experience. DO YOU HAVE ANY INVESTMENT BANKING DOMAIN .NET

$$Excel-Macros$$ .NET Developer in Charlotte, NC

2021-06-02 Thread Om Prakash Reddy
money. - SQL Server/TSQL - .Net Framework core - Entity Framework - C# - ASP.NET<http://asp.net/> WebAPI - JQuery Thanks, Om Prakash | IT Recruiter V2 Innovations Inc 42180 Ford Rd, Ste 302, Canton, MI 48187 Phone: (734) 408 4698 Fax: 734-408-4744 Email: omprak...@v2innova

$$Excel-Macros$$ Immediate Backend Core .net Position at Charlotte, NC

2021-06-01 Thread Bhanu Prakash
Good Morning Group Members, My name is Bhanu, dedicated to source IT Resource for V2 Innovations Inc. Currently I am working on Core (Backend) .net position. Client needs the professional to be expert on backend Core .net expertise. Tech Stack - .Net Core, Entity Framework Core, C#, SQL Server/

$$Excel-Macros$$ .NET Developer in Charlotte, NC

2021-06-01 Thread Om Prakash Reddy
- .Net Framework core - Entity Framework - C# - ASP.NET WebAPI - JQuery Thanks, Om Prakash | IT Recruiter V2 Innovations Inc 42180 Ford Rd, Ste 302, Canton, MI 48187 Phone: (734) 408 4698 Fax: 734-408-4744 Email: omprak...@v2innovationsinc.com www.v2innovationsinc.com<http://www.v2innovationsinc.

$$Excel-Macros$$ Happy Long Weekend !!

2021-05-28 Thread Bhanu Prakash
You can also join our active telegram recruitment channel by clicking https://t.me/joinchat/H0POJ_mA79U0ODhh Kind Regards! Bhanu Prakash | (734) 259 4824 -- 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

$$Excel-Macros$$ US IT Recruiters - Looking for Work From Home - Recruiters

2021-05-28 Thread Om Prakash Reddy
Hi, We are looking for Work From Home – US IT Recruiters to expand our Team. 1. Minimum 2 Yrs. Exp. 2. Strong understanding of US IT Recruitment 3. Familiar with ATS 4. Strong in MS Office – Outlook, Excel, Word 5. Should have Laptop with MS Outlook – Latest Version 6. Have

$$Excel-Macros$$ Remote US IT Recruiters - 5 Positions

2021-05-28 Thread Om Prakash Reddy
Hi, We are looking for Work From Home – US IT Recruiters to expand our Team. 1. Minimum 2 Yrs. Exp. 2. Strong understanding of US IT Recruitment 3. Familiar with ATS 4. Strong in MS Office – Outlook, Excel, Word 5. Should have Laptop with MS Outlook – Latest Version 6. Have s

$$Excel-Macros$$ .NET Developer in Charlotte, NC

2021-05-28 Thread Om Prakash Reddy
- .Net Framework core - Entity Framework - C# - ASP.NET WebAPI - JQuery Thanks, Om Prakash | IT Recruiter V2 Innovations Inc 42180 Ford Rd, Ste 302, Canton, MI 48187 Phone: (734) 408 4698 Fax: 734-408-4744 Email: omprak...@v2innovationsinc.com www.v2innovationsinc.com<h

$$Excel-Macros$$ URGENT REQUIREMENT FOR VDI ENGINEER in Atlanta, GA

2021-05-26 Thread Om Prakash Reddy
security, and compliance perspective. Providing mentoring and guidance to other VDI Administrators. Document designs, development plans operations procedures for the VDI solution. Thanks, Om Prakash | IT Recruiter V2 Innovations Inc 42180 Ford Rd, Ste 302, Canton, MI 48187 Phone: (734) 408 4698 Fax

$$Excel-Macros$$ URGENT REQUIREMENT FOR VDI ENGINEER in Atlanta,GA

2021-05-25 Thread Om Prakash Reddy
security, and compliance perspective. Providing mentoring and guidance to other VDI Administrators. Document designs, development plans operations procedures for the VDI solution. Thanks, Om Prakash | IT Recruiter V2 Innovations Inc 42180 Ford Rd, Ste 302, Canton, MI 48187 Phone: (734) 408 4698 Fax

$$Excel-Macros$$ URGENT REQUIREMENT for .Net Developer at Tallahassee, FL

2021-05-24 Thread Om Prakash Reddy
s, Om Prakash | IT Recruiter V2 Innovations Inc 42180 Ford Rd, Ste 302, Canton, MI 48187 Phone: (734) 408 4698 Fax: 734-408-4744 Email: omprak...@v2innovationsinc.com www.v2innovationsinc.com<http://www.v2innovationsinc.com/> Disclaimer: We respect your Online Privacy. This e-mail message, in

$$Excel-Macros$$ URGENT REQUIREMENT for .Net Developer at Tallahassee, FL

2021-05-21 Thread Om Prakash Reddy
cript Thanks, Om Prakash | IT Recruiter V2 Innovations Inc 42180 Ford Rd, Ste 302, Canton, MI 48187 Phone: (734) 408 4698 Fax: 734-408-4744 Email: omprak...@v2innovationsinc.com www.v2innovationsinc.com<http://www.v2innovationsinc.com/> Disclaimer: We respect your Online Privacy. This e-m

$$Excel-Macros$$ Senior .Net Developer­_ NYC, NY & Raleigh, NC

2021-05-20 Thread Om Prakash Reddy
OO principles - RDBMS experience (e.g. SQL Server / Oracle) and writing SQL stored Procedures - Demonstrates experience of using Design Patterns (advantages and drawbacks) Om Prakash | IT Recruiter V2 Innovations Inc 42180 Ford Rd, Ste 302, Canton, MI 48187 Phone: (734

$$Excel-Macros$$ QA TEST ENGINEER AUTOMATION//Orlando, FL//Corp To corp//6months

2020-03-17 Thread mani prakash
Hi Greeting from Simba Staffing Job Tille : QA TEST ENGINEER AUTOMATION Location : Orlando, FL contract : Corp To corp Duration: s REQUIRED TECHNICAL SKILLS: -Minimum of 8 years experience in a software testing environment -Minimum of 4 years experience in automated testing -Mi

$$Excel-Macros$$ QA TEST ENGINEER AUTOMATION//Orlando, FL//Corp To corp//6months

2020-03-17 Thread mani prakash
Hi Greeting from Simba Staffing Job Tille :QA TEST ENGINEER AUTOMATION Location : Orlando, FL contract : Corp To corp Duration: 6months REQUIRED TECHNICAL SKILLS: -Minimum of 8 years experience in a software testing environment -Minimum of 4 years experience in automated testing

Re: $$Excel-Macros$$ Excel Macro Help

2017-10-09 Thread Ram Prakash Palaniswamy
all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ----- > > > On Saturday, October 7, 2017 7:48 AM, Ram Prakash Palaniswamy < > ramcb...@gmail.com> wrote: > > > I have a master excel file (

$$Excel-Macros$$ Excel Macro Help

2017-10-07 Thread Ram Prakash Palaniswamy
I have a master excel file (ABC.xls) which has n number of rows and columns. And also i have another excel file (DEF.xls) which has limited number of same data from the master excel file (ABC.xls). I need a macro code for if i update some values in the master excel file (ABC.xls), automatica

Re: $$Excel-Macros$$ Conditional calculation required for multiple criteria.

2016-10-16 Thread indu prakash
Hi Dheeraj, Please find plausible solution in file attached. formula in cell L7 (highlighted in green) can be used for all the scenarios, other formulas in column L are scenario specific. On Saturday, 15 October 2016 11:11:05 UTC+5:30, Dheeraj Bankoti wrote: > > Hi > Can any expert resolve the q

Re: $$Excel-Macros$$ URGENT : Help on excel for matching data

2014-07-27 Thread bhanu prakash
Hi, Had checked your response, still I see the same issue ..if you see the attachment ( Data match sheet) last 3 rows are reflecting wrong, shold be lvl - 2. On Mon, Jul 28, 2014 at 11:16 AM, Vaibhav Joshi wrote: > PFA > > > On Mon, Jul 28, 2014 at 10:40 AM, bhanu prakash >

Re: $$Excel-Macros$$ URGENT : Help on excel for matching data

2014-07-27 Thread bhanu prakash
6:44 PM, Vaibhav Joshi wrote: > >> Hi >> >> Pl refer attachment, due to your data formula became complex, you can >> check example next to it for an explanation. >> >> Cheers!! >> >> >> On Fri, Jul 25, 2014 at 3:45 PM, bhanu prakash >&

Re: $$Excel-Macros$$ URGENT : Help on excel for matching data

2014-07-27 Thread bhanu prakash
“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > >*From:* bhanu prakash > *To:* excel-

Re: $$Excel-Macros$$ URGENT : Help on excel for matching data

2014-07-25 Thread bhanu prakash
ur samples, none of these criteria match data in the Source > sheet. > > ?? > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people

Re: $$Excel-Macros$$ URGENT : Help on excel for matching data

2014-07-25 Thread bhanu prakash
Team, Any experts for help on below mentioned request..please help Regards, Bhanu On Fri, Jul 25, 2014 at 11:41 AM, bhanu prakash wrote: > Hello Team, > > Hope everyone doing good. > > Had attached the excel sheet for reference > > in that Excel you will find 2 tabs

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

2014-07-17 Thread Prakash Gusain
Yes they are static On Thursday, July 17, 2014 3:21:37 PM UTC+5:30, Vabz wrote: > > Is header in Raw data static? > > > On Wed, Jul 16, 2014 at 5:22 PM, Prakash Gusain > wrote: > >> Hi All, >> >> Attached file has two tabs (Raw Data & OutCome). Wha

$$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

$$Excel-Macros$$ Re: Cell value distribution formula

2014-04-19 Thread satya prakash
i want to distribute first table quantity automatically as per second table and final table as given On Friday, April 11, 2014 6:18:15 PM UTC+5:30, satya prakash wrote: > > > -- 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

$$Excel-Macros$$ Cell value distribution formula

2014-04-11 Thread satya prakash
-- 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, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, F

$$Excel-Macros$$ Vlookup Help **URGENT**

2013-05-06 Thread bhanu prakash
Dear All, In Vlookup, when we have more than 3 to 4 return values, how to pick all the return values..in Vlook up it picks the first value . Need your help at the earliest..let me know if my query is not clear..will elaborate..thanks Regards, Bhanu -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in E

Re: $$Excel-Macros$$ Re: Repair File

2013-03-20 Thread Prakash
Hi Kantilal, What are the error messages??? Can you share the error message? Without the error message, I am unable to answer. On Tuesday, March 19, 2013 7:10:00 PM UTC+5:30, kantila...@gmail.com wrote: > > Thanks Prakash, > > I tried following steps before sharing the file. B

$$Excel-Macros$$ Re: My Excel is Crashing!!

2013-03-19 Thread Prakash
Hi Rajan, Excel crashing issue can be caused by several things like: Problem with add-ins, outdated anti-virus software, Excel is used by another program, and many mode. Users can get rid from this problem by following methods: - Start Excel in Safe - Update anti-virus software - Make

$$Excel-Macros$$ Re: Repair File

2013-03-19 Thread Prakash
Hello Kantilal, Have you tried to repair the file at your end? If no then try to repair it first and share the result. You can repair the file by following below steps: 1. On the *File* menu, click Open. 2. In the Open dialog box, select the file you want to open, and click the arrow

$$Excel-Macros$$ Re: convert Excel into pdf

2013-02-13 Thread Prakash
Some free Excel to PDF converter software are also available on the Internet like freepdfconvert.com, doctopdf.net -- 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/discussexc

$$Excel-Macros$$ Re: How to write letter to boss

2013-02-10 Thread Prakash
Have a look here: http://www.readwritethink.org/files/resources/interactives/letter_generator/ On Thursday, February 7, 2013 10:48:36 AM UTC+5:30, nandu wrote: > > Hello Guys, > > I need your help, how to write a letter for additional staff in our branch. > > Please give me u r format here > > T

$$Excel-Macros$$ Re: Damage file Unable to retrive

2013-02-10 Thread Prakash
have used Stellar Excel file repair software before and found successful result.Try its demo version first and it is free of cost. Thanks, Prakash On Sunday, February 10, 2013 10:24:55 PM UTC+5:30, SAJID MEMON wrote: > > dear I have done as per your suggestion but unable to retrieve my

Re: $$Excel-Macros$$ Re: Cell Referencing

2013-01-25 Thread indu prakash
Sorry Kahlid, I am at zero with VBA. Hope some one here will help you out. On Friday, January 25, 2013 10:15:29 PM UTC+5:30, Sadia Khalid wrote: > > > *@indu prakashany * > any VBA code for this > > -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RU

Re: $$Excel-Macros$$ Re: Cell Referencing

2013-01-25 Thread indu prakash
r absolute references as* * done in column E.* * * *you can use this formula in place of D22 "D22*..." and part after * can be given absolute references.* * * On Friday, January 25, 2013 7:44:57 PM UTC+5:30, Sadia Khalid wrote: > > @indu prakash > thanks for your reply. b

$$Excel-Macros$$ Re: Cell Referencing

2013-01-25 Thread indu prakash
We are getting different values in column D and E because the formula used in column D has relative cell reference because of which references are changing but in case of column E cells are fixed. Result of which when we are moving to D24, in case of column D references are $D$23 but it column E

Re: $$Excel-Macros$$ Re: Need to create a summary sheet

2012-12-12 Thread Satya Prakash
Hi Prince I got my final solution. If you wish you can go through the excel sheet, so that you can come to know what I was looking for. Thanks for your support and help. On 12 December 2012 14:25, Prince wrote: > Hi Satyas. > > I feel if there is more then one person exist on the same slot on

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

2012-11-27 Thread bhanu prakash
Dear All.. Bhanu Prakash, works for Oracle as Business analyst...Im proud to be part of loverly group...Keep rocking.. Thanks Bhanu On Mon, Nov 26, 2012 at 10:43 PM, Ayush Jain wrote: > CSk, start the new topic please > > Thanks. > On Nov 25, 2012 10:01 PM, "CSK"

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

2012-11-06 Thread bhanu prakash
t; your time and mine. > > But perhaps we've both learned something. > > > > Paul > > ----- > > “Do all the good you can, > > By all the means you can, > > In all the ways you can, > > In all the places y

Re: $$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

2012-11-05 Thread bhanu prakash
times you can, > To all the people you can, > As long as ever you can.” - John Wesley > *- > > > -- > *From:* bhanu prakash > *To:* excel-macros@googlegroups.com > *Sent:* Sun, November 4, 2012 11:55:01

$$Excel-Macros$$ VBA ( macro ) sheet need to unprotect ** Urgent Help Required**

2012-11-04 Thread bhanu prakash
Dear Team , Need your help in Unprotecting the VBA ( macro ) sheet..Or please let me know how to do it..this is required little urgent..kindly help Had attached the sheet for refference ..thanks Regards Bhanu -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ How to add combo box in a sheet.....Need Help.....

2012-06-11 Thread Ved Prakash
--- On Fri, 8/6/12, NOORAIN ANSARI wrote: Humbaly requested not to e mail me in future ved -- 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

Re: $$Excel-Macros$$ MACRO

2012-05-31 Thread Prakash Paul
Dear Noorian, Please send the 2007 file to jprakashp...@gmail.com. Thanks in advance Regards Paul -- 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 Problem, and Nee

Re: $$Excel-Macros$$ Capture Image using VBA

2012-02-08 Thread Prakash Gusain
You can use any excel file. I just want to trigger the webcam using VBA. Hope you guys can help me provide the solution. On Feb 8, 11:14 pm, NOORAIN ANSARI wrote: > Dear Prakash, > > Please share a sample workbook with excel macro group > > On Wed, Feb 8, 2012 at 8:04 PM, Praka

$$Excel-Macros$$ Capture Image using VBA

2012-02-08 Thread Prakash Gusain
I want to capture an image and save to specified location in system using vba. Also need the file address in the active cell. Thank you in advance for your help. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please H

$$Excel-Macros$$ Re: Excel Symbol.

2012-01-31 Thread Prakash Gusain
Insert> Symbol Select the one you want. If not found change the font from drop down. Prakash On Jan 31, 7:47 pm, bhupendra singh raghav wrote: > Hi Group, > > I Need a spacial Symbol insert to excel work sheet. there is any opetion. > > Please suggest. > > Regards &g

Re: $$Excel-Macros$$ Send Personalized emails in Lotus Notes

2011-12-30 Thread Prakash Gusain
> parameters > Sub sendMymail() > SendNotesMail(Subject , attachment, ReceipentEmailID, bodytext, ,True) > End Sub > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Prakash Gusain > Sent: Dec/Fri/2011 02:5

Re: $$Excel-Macros$$ Send Personalized emails in Lotus Notes

2011-12-30 Thread Prakash Gusain
Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > > On Behalf Of Prakash Gusain > Sent: Dec/Fri/2011 01:56 > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ Send Personalized emails in Lotus Notes > > Hi > > I want to send emails with

$$Excel-Macros$$ Send Personalized emails in Lotus Notes

2011-12-30 Thread Prakash Gusain
Hi I want to send emails with constant subject but with variable matter to people in the my list. I am using Lotus notes as email client. For example: Column A has my mail matter. A1: xcvb, A2: assd A3: qwer A4: poiu Column B has email addresses. B1: x...@gmail.com B2: a...@gmail.com B3: q...@g

Re: $$Excel-Macros$$ Disable delete

2011-12-29 Thread Prakash Gusain
can't delete, possibly even read-only access if > appropriate) and you and/or the project developers have full access to. > > Asa > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > > On Behalf Of Prakash Gusai

Re: $$Excel-Macros$$ Backup file on every save

2011-12-26 Thread Prakash Gusain
--- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > > On Behalf Of Prakash Gusain > Sent: 26 December 2011 11:20 > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ Backup file on every save > > Hi > > I am trying to find the code to

$$Excel-Macros$$ Disable delete

2011-12-25 Thread Prakash Gusain
How can I disable the delete of an excel file? I don't want my user to delete the excel file kept at a location. Thanks in advance. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Form

$$Excel-Macros$$ Backup file on every save

2011-12-25 Thread Prakash Gusain
Hi I am trying to find the code to create a backup of file on every occasion user saves the file. But I want to specify the location where the backup file will be created. I know the feature to create the backup of file but want to specify the location where it saves the backup. Thanks in advan

Re: $$Excel-Macros$$ Run time code error

2011-10-20 Thread Prakash Gusain
I, myself not being able to understand this. On Oct 20, 4:24 pm, Sam Mathai Chacko wrote: > Unable to comment further without proper understanding of what could be this > strange issue. > > Regards, > > Sam > > On Fri, Oct 21, 2011 at 1:51 AM, Prakash Gusain &g

Re: $$Excel-Macros$$ Run time code error

2011-10-20 Thread Prakash Gusain
Sam, this is still giving me the same error. My code worked on one of my friends machine but not on mine. I believe there is some problem with the settings in my VB editor and that is what I want to figure out. Prakash On Oct 20, 4:05 pm, Sam Mathai Chacko wrote: > Doesn't seem t

Re: $$Excel-Macros$$ Extract from date and time

2011-10-20 Thread Prakash Gusain
The best Answer so far by XLS S! On Oct 20, 1:24 pm, XLS S wrote: > for only date use int() > and time use mod fuction > > On Tue, Oct 18, 2011 at 3:02 PM, Muhammad Arslan > wrote: > > > > > > > > > Dear Experts > > I need to disjoint date and time form a text. Help me out how to tackle in > > e

$$Excel-Macros$$ Run time code error

2011-10-20 Thread Prakash Gusain
Wend Loop objIE.Document.getElementById("txtSupplierName").Value = "PRAKASH" Do While objIE.busy While objIE.busy DoEvents Wend Loop End Sub this code is giving me run time error with message as "Method 'Docum

Re: $$Excel-Macros$$ values and percentages in stack chart

2011-09-27 Thread Prakash Singh Gusain
you were looking for this. Let me know -- Prakash Singh Gusain *To learn amazing MS-Excel tricks (**click here<http://prakashgusain.blogspot.com/> **)* -- -- Some important links for excel users: 1. Follow us

Re: $$Excel-Macros$$ Very slow performance by Excel file

2011-08-23 Thread Prakash Paul
Hi Amit, Try this method. Go to the task manager and set the excel.exe to high priority. Regards Prakash Paul On Tue, Aug 23, 2011 at 4:56 PM, Amit Desai (MERU) wrote: > I have more than 1000 formulaes...spreaded in 4 sheets...pls suggest > solutions.. > > Best Regards,

Re: $$Excel-Macros$$ Can you please help regd. lists

2011-08-10 Thread Prakash Paul
Hi Naresh, Based on your query i have attached the sample file for your reference. Regards Prakash Paul On Wed, Aug 10, 2011 at 4:51 PM, naresh v wrote: > Hello experts, > > Let us assume in the particular cell i want a dropdown like "south" or > "north". &

Re: $$Excel-Macros$$ How to add a name column to scatter chart's data label?

2011-08-05 Thread Prakash Paul
Hi, I have tried the charting, please check whether you want like this. Regards Prakash Paul On Sat, Aug 6, 2011 at 6:04 AM, Excel 009 wrote: > Hi All, > > I have the following data and want to create a scatter chart. I am > using either 2003 or 2007. > >

Re: $$Excel-Macros$$ Creating Linked Drop-Downs in a User form

2011-08-03 Thread Prakash Paul
Dear Robb, I have attached a simple example on drop down list box. Based on the first selection the details in the second list box get changed. Similarly in the third list box. 1. name the range 2. go data ---> data validation ---> select list box 3. use indirect function to call the named r

Re: $$Excel-Macros$$ Two major milestones : 8000 members and 1000+ posts

2011-07-25 Thread Prakash Paul
Dear Group members, It is a great news. I would like to congratulate the members who have shared their knowledge to others. Congratulation Ayush.. Regards Paul On Tue, Jul 26, 2011 at 9:22 AM, Ayush wrote: > Dear members, > > I am glad to share that this forum has achieved two

Re: $$Excel-Macros$$ Date & Time picker on a userform

2011-07-25 Thread Prakash Paul
Hi, Sam could you share the access mdb file, so that new user like me can learn how to link mdb with excel forms. Thanks in advance Regards Paul On Mon, Jul 25, 2011 at 6:12 AM, KAUSHIK SAVLA wrote: > U can use date function or today function of excel. > > On 7/24/11, alisha malhotra wrote:

$$Excel-Macros$$ Re: help req.I want to -ve value replace with 0.

2011-07-01 Thread Prakash Gusain
ext cl Next sh End Sub Prakash Singh Gusain On Jul 1, 11:49 am, Rakesh Sharma wrote: > *Dear All, > * > * > * > * > * > *i want to replace -ve values into 0 .in 30  or more sheet. plz let me know > if any formula, > * > > note:- -ve values are n

$$Excel-Macros$$ Remove Password Protection

2011-04-22 Thread Prakash Gusain
Hi, Can any one provide me any code using which I can break the password of any excel add in? Prakash -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

Re: $$Excel-Macros$$ Excel help

2011-04-03 Thread bhanu prakash
xCell = Replace(xCell, "0", "") Next End Sub since you ask for "REMOVING ZERO IN EVERY CELL" 1500 will be 15 2100500 will be 215 and so on On Sun, Apr 3, 2011 at 9:55 PM, bha

$$Excel-Macros$$ Excel help

2011-04-03 Thread bhanu prakash
Hi - need it help excel. Removing zeros in alpha numeric data, ex ,,07855a need help in removing zeros in every cell. Regards ,- bhanu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips trick

Re: $$Excel-Macros$$ RASHI QUERRY

2011-02-16 Thread Prakash Gusain
=VLOOKUP(IF(SUM(VLOOKUP(DAY(L1),A20:B50,2,FALSE),VLOOKUP(MONTH(L1),C20:D31,2,FALSE),VLOOKUP(TIME(HOUR(L1),MINUTE(L1),SECOND(L1)),E21:G44,3,TRUE))>K8,SUM(VLOOKUP(DAY(L1),A20:B50,2,FALSE),VLOOKUP(MONTH(L1),C20:D31,2,FALSE),VLOOKUP(TIME(HOUR(L1),MINUTE(L1),SECOND(L1)),E21:G44,3,TRUE))- K8,SUM(VLOOKUP(

RE: "$$Excel-Macros$$ RASHI QUERRY"

2011-02-15 Thread Prakash Gusain
KUP(DAY(L1),A20:B50,2,FALSE),VLOOKUP(MONTH(L1),C20:D31,2,FALSE),VLOOKUP(TIME(HOUR(L1),MINUTE(L1),SECOND(L1)),E21:G44,3,TRUE))),A3:C15,3,TRUE) will give you the solution! -- Best Regards! Prakash Singh Gusain *Please visit my blog (**click here <http://prakashgusain.blogsp

$$Excel-Macros$$ RE: Excel graphs and formula for adding time spent

2011-02-15 Thread Prakash Gusain
Dear Vinod, The sum formula is giving correct solution if you mean by 0:20 mins. Kindly explain where are you facing the issue or why do you think the sum for 4:30 is not correct. -- Best Regards! Prakash Singh Gusain *Please visit my blog (**click here <http://prakashgusain.blogspot.

$$Excel-Macros$$ Re: Weekday only from column to rows!

2011-01-30 Thread Prakash Gusain
this is done plz ignore -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid

Re: $$Excel-Macros$$ Help with nested Vlookup

2011-01-27 Thread Prakash Gusain
>From your email client just send an email to excel-macros@googlegroups.comwith the same subject line mentioned in this mail. We all will receive it in the group! Best Regards! Prakash Singh Gusain *Please visit my blog (**click here <http://prakashgusain.blogspot.com/>**)* On Th

Re: $$Excel-Macros$$ Help with nested Vlookup

2011-01-27 Thread Prakash Gusain
Can you post the file? It will help us a lot! -- Best Regards! Prakash Singh Gusain *Please visit my blog (**click here <http://prakashgusain.blogspot.com/>**)* -- -- Some important links for excel us

$$Excel-Macros$$ Re: Lookup values in different sheets

2011-01-25 Thread Prakash Gusain
=IF(ISERROR(VLOOKUP(B4,$E$3:$F$3,2,FALSE)),IF(ISERROR(VLOOKUP(B4,$H $3:$I$3,2,FALSE)),VLOOKUP(B4,$K$3:$L$3,2,FALSE),VLOOKUP(B4,$H$3:$I $3,2,FALSE)),VLOOKUP(B4,$E$3:$F$3,2,FALSE)) On Jan 25, 10:57 pm, Aamir Shahzad wrote: > Hi experts, > > Can I find values in multiple sheets with vlookup function

$$Excel-Macros$$ How to attach solution file while responding to any post

2011-01-22 Thread Prakash Gusain
Hi, I would like to know, how can I attach file with solution while responding? Sorry being new to group I don't know anything about it. Please take time to answer my query. It'll be a great help. Regar

$$Excel-Macros$$ Re: Help req

2011-01-21 Thread Prakash Gusain
HOW TO PASTE THE EXCEL FILE WHILE REPLYING.. RAKESH I AM SENDING YOU THE SOLUTION ON YOUR ID... LET ME KNOW IF THAT HELPED.. On Jan 21, 11:34 am, saggi wrote: > not getting any idea after seeing ur data, > plz elaborate ur issue > > On Jan 21, 4:21 am, Prakash Gusain wrote

$$Excel-Macros$$ Re: Help req

2011-01-20 Thread Prakash Gusain
What are you looking for Rakesh? Kindly explain it little bit more. Prakash Singh Gusain http://prakashgusain.blogspot.com On Jan 20, 6:01 pm, Rakesh Sharma wrote: > *Hi ,* > * > * > * > * > *Please help me to make simple dashboard to modified .* > * > * > *f

$$Excel-Macros$$ Re: unsubscribe

2009-03-28 Thread OM PRAKASH SAHARAN
PLEASE UNSUCRIBE ME On 3/27/09, mohammed farhaan wrote: > > > pls unsubsribe me... > -- > Add more friends to your messenger and enjoy! Invite them now. > > > > --~--~-~--~~--

$$Excel-Macros$$ Re: Fwd: Abt macro

2008-11-25 Thread bhanu prakash
Hello Sharad, Wat's wrong with you.. This is very popular group..!! and really shock that this kind of people in this..?? *Group Moderator - Request you to please do some action on this kind of activities pls..thanks* Cheers. Regards, Bhanu On Tue, Nov 25, 2008 at 10:15 AM, S