Re: $$Excel-Macros$$ Develop a macros for a problem

2016-02-05 Thread Saurabh Karangutkar
On Friday, February 5, 2016 at 6:54:21 PM UTC+5:30, Saurabh Karangutkar wrote: > > HELLO PAUL YOU HAVE BEEN A GREAT HELP . BUT I M JUST A AMATEUR IN MACROS > SO CAN YOU DO THE NECESSARY CHANGES AND SEND ME THE UPDATED TOOL . I HAVE > UNPROTECTED THE SHEET SO YOU CAN MAKE THE NECE

Re: $$Excel-Macros$$ Develop a macros for a problem

2016-02-05 Thread Saurabh Karangutkar
B3 > and B4. >Without those, I cannot test further. > *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

$$Excel-Macros$$ Develop a macros for a problem

2016-02-04 Thread Saurabh Karangutkar
The name of the software is price mapping tool . Here it is what it is intented to do . Here is the problem Sheet 1 - file 1 is base datafile thats maps our master product file with master product file received from our suppliers / merchants listing supplier product code to our product code,

Re: $$Excel-Macros$$ Develop a macro to solve below problem

2016-02-04 Thread Saurabh Karangutkar
you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Thursday, February 4, 2016 5:57 AM, Saurabh Karangutkar < > saurab...@gmail.com > wrote: > > > > >- Here is the problem > >

$$Excel-Macros$$ Re: Develop a macro to solve below problem

2016-02-04 Thread Saurabh Karangutkar
On Thursday, February 4, 2016 at 4:27:07 PM UTC+5:30, Saurabh Karangutkar wrote: > > >- Here is the problem > > >Sheet 1 - file 1 is base datafile thats maps our master product file >with master product file received from our suppliers / merchants l

$$Excel-Macros$$ Develop a macro to solve below problem

2016-02-04 Thread Saurabh Karangutkar
- Here is the problem Sheet 1 - file 1 is base datafile thats maps our master product file with master product file received from our suppliers / merchants listing supplier product code to our product code, and supplier name to our name. This is prepared basis a one ti

$$Excel-Macros$$ Evaluation Sheet for Job

2014-04-09 Thread Saurabh Madhusudan Patel
Regards, Saurabh Patel Assistant Manager - Marketing Mediscribes, Inc. ezDI, LLC. +91 99099 94490 <https://www.facebook.com/ezdius> Description: Description: Description: facebook <http://www.linkedin.com/company/ezdi-llc> Description: Description: Description: linkedin "The

$$Excel-Macros$$ REMOVE ME

2012-05-18 Thread saurabh kumar
-- 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 Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thre

RE: $$Excel-Macros$$ suggest a formula on this attachement

2012-05-16 Thread Saurabh Madhusudan Patel
Hope this solution helps From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Smitha S R Sent: Wednesday, May 16, 2012 2:32 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ suggest a formula on this attachement Hi, Please suggest a formula o

FW: $$Excel-Macros$$ Sum of all the random numbers generated

2012-03-26 Thread Saurabh Madhusudan Patel
Dear All, Can we get the required details? Regards, Saurabh Patel From: Saurabh Madhusudan Patel [mailto:saurabh.pa...@in.aegisglobal.com] Sent: Saturday, March 24, 2012 7:49 PM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Sum of all the random numbers

RE: $$Excel-Macros$$ Sum of all the random numbers generated

2012-03-24 Thread Saurabh Madhusudan Patel
is already there in file. Want SUM of that random number which is getting generated till the batsman gets out or comes to 0. Regards, Saurabh Patel | Asst. Manager - Operations | Aegis Limited | 4th Floor, Essar House, Ahmedabad - 380006 | T +91 79 66086753 | M +91 99099 94490 | E saurabh.pa..

$$Excel-Macros$$ Sum of all the random numbers generated

2012-03-24 Thread Saurabh Madhusudan Patel
Hi All, Need a help in attached file. There is a column were random numbers are generated. Need sum in a cell for all the random numbers which gets generated. Attached herewith the file where and all the requirements are mentioned. Regards, Saurabh Patel DISCLAIMER:The information

$$Excel-Macros$$ Values before "_"

2012-02-02 Thread Saurabh Madhusudan Patel
Hi, I have list with the values. I need only text which comes before "_". Please find attached herewith the file. I want the result shown in the highlighted cell. Required formula with out doing text to column. Regards, Saurabh Patel DISCLAIMER:The information co

RE: $$Excel-Macros$$ breaking my head last six months-PLsssssss. Help

2011-01-21 Thread SAURABH VISHWAKARMA
hi, pls provide the clearity you want to student attendance tracker regards saurabh Date: Fri, 21 Jan 2011 02:03:04 -0800 From: rvijayanan...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ breaking my head last six months-PLsss. Help ddsd

RE: $$Excel-Macros$$ breaking my head last six months-PLsssssss. Help

2011-01-21 Thread SAURABH VISHWAKARMA
hi, pls provide the clearity you want to student attendance tracker regards saurabh Date: Fri, 21 Jan 2011 02:03:04 -0800 From: rvijayanan...@gmail.com To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ breaking my head last six months-PLsss. Help ddsd

$$Excel-Macros$$ Extracting Number from Cell

2010-09-22 Thread Saurabh Patel
Dear All, I have attached a sheet wherein I want the result by a formula that I get the number starting from "80" in another raw. Result which is required is been highlighted in yellow. Regards, Saurabh Patel DISCLAIMER:The information contained in this electronic mess

FW: $$Excel-Macros$$ Entering Data in Excel

2010-09-11 Thread Saurabh Patel
Change the cell format to "Number" by right clicking on cell. Regards, Saurabh Patel -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of viju mobile Sent: Saturday, September 11, 2010 5:39 PM To: excel-macros@google

RE: $$Excel-Macros$$ Need to sum if data is in another cell

2010-08-04 Thread Saurabh Patel
Hi, Hope attached is the required solution Regards, Saurabh Patel _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Nadine S Sent: Wednesday, August 04, 2010 3:23 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need to sum

RE: $$Excel-Macros$$ Time Slot from Time

2010-07-19 Thread Saurabh Patel
Thanks :-) Dave Regards, Saurabh Patel | Asst. Manager - Operations | Aegis Limited | 4th Floor, Essar House, Ahmedabad - 380006 | T +91 79 66086753 | M +91 99099 94490 | E saurabh.pa...@in.aegisglobal.com | www.aegisbpo.com | "The earth is enjoyed by heroes"-this is the unfailing

$$Excel-Macros$$ excel to send auto mail

2010-07-18 Thread Saurabh
hi guys, need a help, i have to prepare a calender where a mail is send to a particular address ( a...@gmail.com) on a particular date (like today) -SD -- -- Some important links for excel users: 1. Follow us on TW

$$Excel-Macros$$ Time Slot from Time

2010-07-17 Thread Saurabh Patel
Dear All, Need help in attached excel file. Regards, Saurabh Patel DISCLAIMER:The information contained in this electronic message and in any attachments to this message is confidential, legally privileged and intended only for the person or entity to which this

$$Excel-Macros$$ Separate the values in different columns

2010-06-15 Thread Saurabh Patel
Hi All, Required help in attached file Regards, Saurabh Patel DISCLAIMER:The information contained in this electronic message and in any attachments to this message is confidential, legally privileged and intended only for the person or entity to which this electronic

RE: $$Excel-Macros$$ How to display cell contects as password *****

2010-06-11 Thread Saurabh Patel
Just go to format Cell --> Protection Tab --> Check the hidden box and uncheck the locked box. Then protect the work sheet. Regards, Saurabh Patel -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Rajesh Bedse Sent:

RE: $$Excel-Macros$$ Duplicates in Pivot table - Help pls

2010-06-11 Thread Saurabh Patel
Is the attached resolution you want? Regards, Saurabh Patel _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Steven Dsouza Sent: Thursday, June 10, 2010 12:07 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Duplicates in

Re: $$Excel-Macros$$ Need Help for Macro or Formula

2010-05-14 Thread saurabh singh
t; <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > >

Re: $$Excel-Macros$$ Converting .xlsm to .xls

2010-02-06 Thread saurabh singh
orials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to t

Re: $$Excel-Macros$$ Excel Solver

2010-01-11 Thread Saurabh
pls send that acrossi may give sm inputs On Sat, Jan 9, 2010 at 12:58 AM, Mark Reuber wrote: > I have what I believe to be a very simple solver problem, but keep > getting the wrong answers, I can easily answer the problem myself, but > solver doesn't come up with the same solution. > > Is th

Re: $$Excel-Macros$$ Dropdown

2010-01-07 Thread Saurabh
com >>> New Delhi - 110062 >>> >>> >>> On Wed, Jan 6, 2010 at 9:49 AM, Doki wrote: >>> >>>> Thanks Dilip, >>>> >>>> It is on the same line of my requirement. just one more thing. Can we >>>> make a ref

Re: $$Excel-Macros$$ Downloading file from URL

2009-12-03 Thread saurabh singh
lt;><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and su

$$Excel-Macros$$ VBA - which object to use

2009-11-22 Thread saurabh
Hi , i have automated some websites which are based on HTML . It automates login and password input and then it clicks login. I am not able to figure out which object will be used to handle frames on this webpage. 1)https://login.isso.db.com/websso/sso_ext_Logon.sso 2)https://sf.citidirect.com

Message Recall Failure: Recall: $$Excel-Macros$$ Re: Subtract dates

2009-10-09 Thread Saurabh Patel
<>

$$Excel-Macros$$ Splitting a text file

2009-09-18 Thread Saurabh
Hi All, I am importing a text file into excel where there is more data than 65536 rows. Can I have any macro, xla file or any addin to spilt the text file into different sheets. Regards, Saurabh Patel +91982814 "The earth is enjoyed by heroes"-this is the unfailing truth.

$$Excel-Macros$$ PDF Convert Add in

2009-09-04 Thread Saurabh
Hi Team, Request you to please provide any add in available to convert document into PDF. Regards, Saurabh Patel +91982814 "The earth is enjoyed by heroes"-this is the unfailing truth. Be a hero. Always say, "I have no fear." - Swami Vivekanand DISCLAIMER:The i

$$Excel-Macros$$ Re: How to convert number into hrs & min.

2009-08-09 Thread Saurabh
=A1/(24*60) then change the format it in Time format _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Prasad Gadgil Sent: Sunday, August 09, 2009 10:24 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How to convert number into hrs &

$$Excel-Macros$$ Re: urgent - How to calculate sum of only positive numbers

2009-08-07 Thread Saurabh
Attached is the solution _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ANIL NAIR Sent: Friday, August 07, 2009 2:11 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ urgent - How to calculate sum of only positive numbers excel sh

$$Excel-Macros$$ Re: Urgent help required with Date/Time Format

2009-08-07 Thread Saurabh
Just have to add ' in front of Time to make it text. Then can be used in the formula as desired outcome _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Amitabh Bose Sent: Friday, August 07, 2009 3:45 PM To: VBA_ Google Subject: $$Excel-Macros$$ Ur

FW: $$Excel-Macros$$ how to hide #N/A

2009-08-06 Thread Saurabh
Attached is the solution... -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of harris a Sent: Thursday, August 06, 2009 12:02 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ how to hide #N/A Hello, In case a formula is

$$Excel-Macros$$ Re: Need Help

2009-07-28 Thread Saurabh
Hope this what you want. Saurabh Patel -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of hemant shah Sent: Tuesday, July 28, 2009 4:13 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need Help Hi All, Can you pls

$$Excel-Macros$$ Re: Can any one resolve this?????

2009-07-28 Thread Saurabh
Hope this solution works for you. Regards, Saurabh Patel -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of hemant shah Sent: Tuesday, July 28, 2009 5:48 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Can any one

$$Excel-Macros$$ Re: Segregation of data on a button click in excel

2009-07-27 Thread Saurabh
I think you just have to use Data->Text to Column->Delimited->Space->Finish Saurabh Patel -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Pinky Sangani Sent: Monday, July 27, 2009 4:19 PM To: MS EXCEL AND VBA MA

$$Excel-Macros$$ Re: Count of Status

2009-07-22 Thread Saurabh
Thanks Vivek, Just need more help. Result wanted was count of P divided with count all. Thanks, Saurabh Patel _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of vivek agrawal Sent: Wednesday, July 22, 2009 5:03 PM To: excel-macros

$$Excel-Macros$$ Count of Status

2009-07-22 Thread Saurabh
Hi All, I m having a trouble in attached file. Want to have a Team Wise Count of Status. Attaching the file for the reference. Thanks, Saurabh Patel DISCLAIMER:The information contained in this electronic message and in any attachments to this message is confidential

$$Excel-Macros$$ Feedback Web Page

2009-07-15 Thread Saurabh
Hi All, Can anyone help me with a feedback web page. Wherein if somebody post a feedback i can reveice in Mail, Access or Excel. I know this is not the right group to ask the question but if anyone can help then would be very grateful. Regards, Saurabh Patel DISCLAIMER:The information

$$Excel-Macros$$ Re: Match date to enter data in table

2009-07-01 Thread Saurabh
Hi Amol, Attached is the solution. Hope this is what u want. Regards, Saurabh Patel _ From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Amol Shende Sent: Wednesday, July 01, 2009 5:45 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros

$$Excel-Macros$$ Re: A Macro needed for the task beow

2009-05-27 Thread saurabh singh
hi dave, can the user open both the workbooks(company names and workbook with company name) together or you want to keep company name workbook closed ? On Thu, May 28, 2009 at 8:32 AM, Aindril De wrote: > Hi Dave, > > I guess this will help you. > > > http://www.experts-exchange.com/Software/

$$Excel-Macros$$ Re: Trouble with find

2009-05-27 Thread saurabh singh
Hi , chk if this works for u Sub test() On Error Resume Next Application.DisplayAlerts = False Criteria = "No Sales" For i = 1 To Sheets.Count Sheets(i).Select cellf = Cells.Find(what:=Criteria, after:=ActiveCell, LookIn:=xlFormulas, _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirec

$$Excel-Macros$$ Re: help needed regarding protecting excel files

2008-11-17 Thread saurabh jain bombay
my skill on it since long time.. >> here i need small helpi have put all my excel works in one folder and >> i want to protect it puting password ( for folder ) >> can somone hlp me on this ?? >> thnx >> Suneeta >> * >> >> &

$$Excel-Macros$$ Re: Vlookup Help

2008-08-31 Thread Saurabh Agrawal
master sheet. *Is there a way to automatically redirect the links in both the sheets ???* Thanks & Reagrds, Saurabh On Sun, Aug 31, 2008 at 12:28 PM, Mayank Patel <[EMAIL PROTECTED]> wrote: > Hi shaily, > I saw ur problem i think this is because u have made the entire cell o