Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

r every column. Thus >> the reason I am looking for macro. >> >> Please help >> >> On Tue, Jul 4, 2017 at 11:21 AM, Swapnil Palande < >> palande.swapni...@gmail.com> wrote: >> >>> Hi, >>> >>> No need of macro, you can do it

Re: $$Excel-Macros$$ Macro for Blank Cell and Duplicate Value

Hi, No need of macro, you can do it using formulas also. Attached is the excel for your reference. Regards, Swapnil On Tue, Jul 4, 2017 at 10:36 AM, Puttu * wrote: > Experts, Any help on this will be much appreciated > > On Mon, Jul 3, 2017 at 10:33 PM, Puttu *

Re: $$Excel-Macros$$ Help with a formula problem.

Hi, Please provide sample data and expected output. Regards, Swapnil Suresh Palande On Thu, May 4, 2017 at 8:21 PM, Spencer Patterson < williamspencerpatter...@gmail.com> wrote: > I need to solve a problem and I need help with the IF:THEN:ELSE > calculation please. > > > I need to create a

Re: $$Excel-Macros$$ advanced formula

Hi, Check attached solution. Regards, Swapnil Suresh Palande On Mon, Apr 17, 2017 at 9:38 AM, GENIUS wrote: > Thank you very much for your help, can you please do it through formula > because if you see my question I've mentioned use formula instead pivot > table. > > --

Re: $$Excel-Macros$$ Re: Macro to Automate a school timetable workbook

Hi, You want do develop kind of WorkForce Management Application. Will recommend not to do it in Excel. For small scale use MS Access. It is complex application. You have to contact software developer to develop it. Regards, Swapnil Suresh Palande. On Sat, Mar 25, 2017 at 10:09 AM, Dollar

Re: $$Excel-Macros$$ Countif Criteria range to be Dynamic

Hi, Need more explanation. If you could provide sample file then it is easy to provide appropriate solution. Have one query, if there is only one criteria then why are you using "COUNTIFS" formula, use "COUNTIF" instead. Regards, Swapnil Suresh Palande. On Fri, Mar 24, 2017 at 6:09 PM,

Re: $$Excel-Macros$$ Select all excel files in computer

Hi, Instead of macro do it manually, it will be faster. use search functionality of windows... Search for *.xls and *.xlsx and then move those files to destination folder. Regards, Swapnil Suresh Palande On 08-Oct-2015 8:28 am, "Pankaj Michael" wrote: > > Hi to ALL, > >

Re: $$Excel-Macros$$ Count If Cell Contains

Great...Learned somthing new today... Thanks Abhishek. Regards, Swapnil Palande On Tue, Sep 8, 2015 at 11:33 AM, Abhishek Jain <abhishek@gmail.com> wrote: > Just one correction, if I may: > > Countif(A1:A100,"(IRE)") would only count the cells having exact text as

Re: $$Excel-Macros$$ Text separated with formula

Hi, Check below link: http://www.get-digital-help.com/2014/12/02/split-text-across-columns/ Regards, Swapnil On Wed, May 13, 2015 at 11:16 AM, Nur Hossain nur2...@gmail.com wrote: Hi Paul Schreiner, thanks for replay , I am using office 2007, yes I agree with you that it is possible by doing

Re: $$Excel-Macros$$ Fwd: formula required in both the sheets

Hi Rajesh, It is not cleare what exactly you want. Please explain more with expected results. Regards, Swapnil. On Fri, Apr 17, 2015 at 10:05 AM, Rajesh Agarwal rajey...@gmail.com wrote: Dear Sir Formula required in both the sheets as per mentioned in sheet 1. -- *Rajesh Kumar Agarwal*

Re: $$Excel-Macros$$ Re: Want to work on single workbook with multiple user at a time.

Hi Nadir, If you share work book you will not get this error. Are you sure you have share it? Regards, Swapnil On 18-Mar-2015 4:30 pm, Nasir Saikh nasirsa...@gmail.com wrote: Dear Anil, Thanks for your reply but the query have not solved. I already given the access to the users but only

Re: $$Excel-Macros$$ Pivot Table from multiple sheets

Refer below link https://support.office.com/en-au/article/Consolidate-multiple-worksheets-into-one-PivotTable-report-3ae257d2-ca94-49ff-a481-e9fc8adeeeb5 On 13-Mar-2015 7:12 pm, B Sharma sharma@gmail.com wrote: Dear All Excel Experts, From a very long time, I am trying to create a pivot

Re: $$Excel-Macros$$ Shape Colors (VBA)

Hi Smith, PFA excel. Press Ctrl + q to run macro. Hope this will solve your problem. Thanks and regards, Swapnil Suresh Palande. On Mon, Mar 9, 2015 at 6:59 PM, Iain Smith iain.nata...@gmail.com wrote: Hi. If anyone can assist. I have a map of the world in individual shapes per country,

Re: $$Excel-Macros$$ Function help for output of particular list from different Input data.

have second sheet for output have third sheet. Only i will run micro. Regards, Sachin On Thursday, January 1, 2015 1:39:53 PM UTC+5:30, Swapnil Palande wrote: Hi, Please find attached excel for solution. Hope it works for you. Regards, Swapnil. On Wed, Dec 31, 2014 at 9:13 PM, sach

Re: $$Excel-Macros$$ Function help for output of particular list from different Input data.

Hi, Please find attached excel for solution. Hope it works for you. Regards, Swapnil. On Wed, Dec 31, 2014 at 9:13 PM, sach so itssac...@gmail.com wrote: Dear experts, I try to get output from differnet input valuse. But I'm not able to do that. Please see attached file for better

Re: $$Excel-Macros$$ split text by pipe sign

Hi, Try text to column option. Regards, Swapnil On 11-Oct-2014 10:19 am, Waseem Saifi waseemsa...@gmail.com wrote: Hi Experts, I have attached a file which contain text in cell A15. I want to split this text by pipe sign [|] in cells next to cell A15. Thanks in Advance. Regards,

Re: $$Excel-Macros$$ Need Help With VBA using VLookup

Pls ptovide sample data with desire output. Regards, Swapnil. On Feb 21, 2014 11:23 PM, Erick C boricua2...@gmail.com wrote: Good morning VBA masters. Let me start off by saying I am not a VB expert by any means. I am getting a bit better with modifying small things here and there, but I am

Re: $$Excel-Macros$$ Need to find out date

Hi, PFA file for solution. Regards, Swapnil. On Tue, Feb 18, 2014 at 1:41 PM, prabhakar_k...@sify.com wrote: Dear Team, I have file where i need to find out when the employee is compelteing 60 Years. Please refer attached file Help. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

Re: $$Excel-Macros$$ Repeat the Number Series based on the Vlookup Number

@googlegroups.com] *On Behalf Of *Swapnil Palande *Sent:* Monday, February 17, 2014 11:24 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Repeat the Number Series based on the Vlookup Number Hi Kathir, There is no straight formula for this. So added one extra column (Col D

Re: $$Excel-Macros$$ Date Picker macro

Hi Anil, PFA. Regards, Swapnil. On Mon, Feb 17, 2014 at 4:40 PM, Anil Bhange anil.bha...@tatacommunications.com wrote: Hi Friends, Can you please share me the macro of Date picker or any sample file which I can use in excel to input the date. I seared on net but unfortunately I

Re: $$Excel-Macros$$ Formual question (creating budget spreadsheet).

Hi Jason, Pls attach excel with sample data and desire output. Regards, Swapnil. On Sun, Feb 16, 2014 at 5:48 AM, Jason Nielsen jason.niels...@gmail.comwrote: I am having an issue with a particular formula and wanted to get someone to see where the error is in my formula. Essentially

Re: $$Excel-Macros$$ Repeat the Number Series based on the Vlookup Number

Hi Kathir, There is no straight formula for this. So added one extra column (Col D). Attahced is the solution excel. Regards, Swapnil. On Mon, Feb 17, 2014 at 10:47 AM, KATHIRVELAN N nkathirv1...@gmail.comwrote: Dear Friends, Expecting your help, please help me on this formula. Thanks,

Re: $$Excel-Macros$$ Codes for SubPart

Hi Arvind, You can achive this using formula also. PFA excel. Regards, Swapnil. On Thu, Feb 13, 2014 at 1:17 PM, pankaj sangotra psangotr...@gmail.comwrote: Please try this hope this will help.. Sub output() Dim i As Integer, k As Integer, j As Integer k = 1 For i = 1 To 5 For j

Re: $$Excel-Macros$$ Excel Formula - Huge Formula - Help to simplfy

Hi Brett, Instead of studying formula, it will be easy to create alternate formula if you could provide calculation steps. Regards, Swapnil. On Fri, Jan 31, 2014 at 10:41 PM, Brett Manning brettmannin...@gmail.comwrote: On Friday, January 17, 2014 6:11:10 AM UTC, Rajan_Verma wrote: i

Re: $$Excel-Macros$$ Average Using Sumproduct

Hi, Try these below mentioned formulas =SUMPRODUCT(((--(A1:A4={a,b})*B1:B4)) / (COUNTIF(A1:A4, a) + COUNTIF(A1:A4, b))) OR =SUMPRODUCT((--(A1:A4={a,b})*B1:B4))/SUMPRODUCT(--(A1:A4={a,b})) Hope this is what you want. Regards, Swapnil. On Fri, Jan 31, 2014 at 8:04 PM, Chandra Shekar

Re: $$Excel-Macros$$ Need exporting help for Records more than 65000 records in Access to Excel

Hi, Usr adodb recordset object and sql query to retrive data. And use copyfromrecordset method to add data in excel. Regards, Swapnil On Feb 3, 2013 3:17 PM, rekha siri rekha.siri2...@gmail.com wrote: hi Group, Need your expertise help i along with my friends uploaded some excel file into

Re: $$Excel-Macros$$ How to get max number from a database ?

Try max formula On Jan 9, 2013 3:35 PM, karan kanuga karankan...@gmail.com wrote: Hi Can anyone pls let me know how do i get the max value or date (using a formula and not pivot) from the database that i have. Attached is the database. Thanks. -- Join official Facebook page of this

Re: $$Excel-Macros$$ Reposition the cursor in an Excel macro

Hi, If you are inserting data automatically then no need to set cursor on sheet 2. Just define range object and assign value to it. If you provide sample data, it is easier to give solution. Regards Swapnil On Dec 17, 2012 2:32 PM, ollyolly andrew.cla...@tiscali.co.uk wrote: I am looking to

Re: $$Excel-Macros$$ Re: Reposition the cursor in an Excel macro

Hi, Please find attached file for solution. In attached excel, macro is updating arrival time without copying it. And there is no key assigned to macro. When you enter value in A2 cell in Sheet1 and hit enter macro will update arrival time in Sheet2 Regards, Swapnil. On Mon, Dec 17, 2012 at

Re: $$Excel-Macros$$ Conditional functions based on multiple criteria

Hi Steve, Not able to understand what exactly you want. Can you explain it with any example or provide what answer you want in saperate column and highlight fields you use to get that answer. So it will be easy to find way to do it. Regards, Swapnil. On Thu, Dec 13, 2012 at 1:20 AM, Steve

Re: $$Excel-Macros$$ Pls help with a lookup formula to pick up ratings.

Hi, Try below formula. =IF(AND(A1=-0.5,A1=-1),STRONG BUY,IF(AND(A1=-0.2,A1=-0.49),BUY,IF(AND(A1=0.19,A1=-0.19),HOLD,IF(AND(A1=0.49,A1=0.2),STRONG SELL,IF(AND(A1=1,A1=0.5),SELL,FALSE) Regards, Swapnik. On Oct 19, 2012 10:08 PM, Hilary Lomotey resp...@gmail.com wrote: Hello Experts i

Re: $$Excel-Macros$$ Help needed to create a function within a macro

from rainy Germany, Henning Am Dienstag, 9. Oktober 2012 19:26:30 UTC+2 schrieb ashish: see the attachment check the cells with Yellow color On Tue, Oct 9, 2012 at 8:48 PM, Swapnil Palande palande@gmail.comwrote: Hi, Insert followibg formula in D1 cell. =if(and(or(a1=1,b1=1),c1

Re: $$Excel-Macros$$ Help needed to create a function within a macro

-and-functions/334159-sumproduct-to-calculate-visible-cells-only.html Regards, Swapnil. On Wed, Oct 10, 2012 at 4:01 PM, Swapnil Palande palande.swapni...@gmail.com wrote: Hi, Pls find attached excel. Check if it is ok with you. Regards, Swapnil. On Wed, Oct 10, 2012 at 1:41 PM, Henning

Re: $$Excel-Macros$$ Is it possible to Open a Particular Website and Login to it using VBA???

Hi, Pls find attached excel. Regards, Swapnil. On Tue, Oct 9, 2012 at 4:36 PM, Pravin Gunjal isk1...@gmail.com wrote: *The file is good but when we click on Google Login in the file it goes to G-Mail entrance page and it is insisting us to enter the details again not opening the mail with

Re: $$Excel-Macros$$ Help needed to create a function within a macro

Hi, Insert followibg formula in D1 cell. =if(and(or(a1=1,b1=1),c123400),3,0) Hope this is what u want. Regards swapnil, On Oct 9, 2012 6:57 PM, Henning Deschka kie...@freenet.de wrote: Hi NG, I need to insert a function into cell D1 with an Excel2007 macro that executes the following:

Re: $$Excel-Macros$$ Formulas for multiple conditions

Hi Anil, Excel provide by you is quite confusing as I can see that there are multiple entries of depot 4101. Pls provide final output you required. Regards, Swapnil. On Mon, Oct 8, 2012 at 1:24 PM, Anil Bhange anil.bha...@tatacommunications.com wrote: Hi Experts, ** ** I need your

Re: $$Excel-Macros$$ Formulas for multiple conditions

– 800105 | Mobile - +31 6 1192 3971 ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Swapnil Palande *Sent:* Monday, October 08, 2012 11:07 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Formulas for multiple

Re: $$Excel-Macros$$ Urgently multiple if condition required in excel

Hi, I didn't get what exactly you want. But attached solutin file as per my understanding. You cannot have more than 7 nested If conditions so I have used different formula. Formula: =IF(A250, IF(MROUND(A2, 5)A2, (MROUND(A2, 5)+5)/100, MROUND(A2, 5)/100), 0.5) pls find attached excel for

Re: $$Excel-Macros$$ How to give the conditional formatting for the full data

Hi Pravin, PFA solution excel. Regards, Swapnil. On Thu, Oct 4, 2012 at 3:31 PM, Pravin Gunjal isk1...@gmail.com wrote: *Hello Friends,* * * *I require a help on the subject matter. The file is attached for your reference.* * * *I have used the conditional formatting as mentioned in

Re: $$Excel-Macros$$ How to give the conditional formatting for the full data

Yes, Actually I apply conditional formating for A2 and then copy it to all cells... thats y date formatting get change.. On Thu, Oct 4, 2012 at 4:19 PM, Pravin Gunjal isk1...@gmail.com wrote: *Thanks Ahmed Swapnil* * * *Yes there was some date formatting went wrong in Swapnil's file.* *

Re: $$Excel-Macros$$ Run-Time Error 3170

, Wireless On Friday, September 14, 2012 1:45:41 PM UTC+5:30, Swapnil Palande wrote: Hi, I don't know exact reason for above error, because when I try to execute code it is giving me error at following line: Set MyDatabase = DBEngine.OpenDatabase(C:\**Database1.mdb) But when I convert

Re: $$Excel-Macros$$ VBA Macro

Hi Shrinivas, Can u provide code. Regards, Swapnil. On Thu, Sep 27, 2012 at 9:14 AM, Shrinivas Shevde shrinivas...@gmail.comwrote: Dear All Some days back I was trying to write macro and I could write small macro. While practising many times I found Error messagr Like Run Time Error 402

Re: $$Excel-Macros$$ Re: Need Help in AutoComplete with Custom List

Hi, Attached is the solution based on link provided by Vabz. But it only work for consecutive cells. Other solution is use Data Validation. It will not give you auto complete option. It will give you dropdown for cell and user have to select value from drop down. Regards, Swapnil. On Tue, Sep

Re: $$Excel-Macros$$ WEEKDAY function of excel - need character day

Hi, Use TEXT function. Ex: =text(A2, ddd) On Sep 24, 2012 11:46 AM, V S Rawat g vsra...@gmail.com wrote: Is there a function in excel 2013 that would give character day of week (e.g Mon, Tue...). Weekday function is giving numeric day, what is the fun of it. do we need to write another

Re: $$Excel-Macros$$ WEEKDAY function of excel - need character day

And if you don't want to use formula then use custom format of cell as ddd On Sep 24, 2012 11:55 AM, Swapnil Palande palande.swapni...@gmail.com wrote: Hi, Use TEXT function. Ex: =text(A2, ddd) On Sep 24, 2012 11:46 AM, V S Rawat g vsra...@gmail.com wrote: Is there a function in excel

Re: $$Excel-Macros$$ Run-Time Error 3170

Hi, Pls you provide sample files. Regards, Swapnil. On Thu, Sep 13, 2012 at 11:03 PM, wirelesscellularguy wirelesscellular...@gmail.com wrote: Hi All, I am trying to query my Access Database(Database1.accdb) through vba. I am getting run-time error 3170 at the highlighted line. Sub

RE: $$Excel-Macros$$ Re: Excel to Access Data

.DropDowns(“ComboBox1”).List= rstRecord.GetRows* * * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Swapnil Palande *Sent:* 14 September 2012 11:14 *To:* excel-macros

Re: $$Excel-Macros$$ Re: Excel to Access Data

Hi, You can populate the combo-box with unique items using Select distinct query Do following steps: 1. Store Select distinct query data in Record Set 2. Loop through record set and add values to the Combo Box Regards, Swapnil. On Thu, Sep 13, 2012 at 11:21 AM, wirelesscellularguy

Re: $$Excel-Macros$$ Re: Excel to Access Data

13, 2012 3:09:23 PM UTC+5:30, Swapnil Palande wrote: Hi, You can populate the combo-box with unique items using Select distinct query Do following steps: 1. Store Select distinct query data in Record Set 2. Loop through record set and add values to the Combo Box Regards, Swapnil

Re: $$Excel-Macros$$ Can I get the day of the week (e.g. Friday) from the date already encoded in a string?

Hi, You can use below formula if you don't want to use vba. =TEXT(C2, ) and if you want to use vba code then use below function format(cdate(02/05/2012), ) Regards, Swapnil. On Wed, Jun 27, 2012 at 9:17 AM, tangledweb domainqu...@gmail.com wrote: If I already have

Re: $$Excel-Macros$$ Can I get the day of the week (e.g. Friday) from the date already encoded in a string?

You can also change custom format . Regards, Swapnil. On Wed, Jun 27, 2012 at 2:14 PM, Swapnil Palande palande.swapni...@gmail.com wrote: Hi, You can use below formula if you don't want to use vba. =TEXT(C2, ) and if you want to use vba code then use below function format

Re: $$Excel-Macros$$ rounding off to nearest multiple of 10

Hi, User following formula: =MROUND(A2, 10) Check following details for more details http://office.microsoft.com/en-us/excel-help/round-a-number-HP003056144.aspx Regards, Swapnil. On Thu, Jan 5, 2012 at 4:38 PM, Shankar Bheema shankar.n...@gmail.comwrote: Dear experts I am using excel

Re: $$Excel-Macros$$ Writing Code for creating pivot table

code from books and forum, I m just newbee) Thanks! Darwin 2011/10/26 Swapnil Palande palande.swapni...@gmail.com Hi, Pls find attached excel. Regards, Swapnil. On Wed, Oct 26, 2011 at 11:23 AM, Darwin Chan darwin.chankaw...@gmail.com wrote: Dear all, Pls find the attached

Re: $$Excel-Macros$$ unable to do any operation with this data

Hi, There are white spaces before number, remove those spaces and then you can use functions. Regards, Swapnil. On Tue, Oct 25, 2011 at 1:30 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Dear Members, Please see the attachment. I am unable to do any operation with this

Re: $$Excel-Macros$$ Writing Code for creating pivot table

Hi, It will be easy to solve issue if you provide sample data. In your code you have not defined DataField, without data field it will show you blank pivot. Share sample data so that group can provide you correct code. Regards, Swapnil. On Wed, Oct 26, 2011 at 10:07 AM, Chan Darwin

Re: $$Excel-Macros$$ Removing specific characters from a string of text

Hi, Try this: =REPLACE(A1, FIND(remark 10/19/2011, A1), LEN(remark 10/19/2011), ) Regards, Swapnil. On Thu, Oct 20, 2011 at 12:43 AM, Zeunasc timothy.ry...@gmail.com wrote: I know that this is relatively easy, but it has been years since I have done any Excel VBA. I am parsing out some

Re: $$Excel-Macros$$ Help

Send sample file On 15 Oct 2011 21:51, santhu santhosh.qat...@gmail.com wrote: Hi, How to extract a text file data to an excel sheet. Ex: Sl.no FirstName MiddleName LastName Place 1 ABC abc India 2 DEF def

Re: $$Excel-Macros$$ comparison between access forms to excel

Hi, Can you provide sample data. Regards, Swapnil. On Thu, Oct 13, 2011 at 5:48 PM, mrinal saha mris...@gmail.com wrote: hi folks, I have an excel sheet wherein column A contains EMP ID and column B contains EMP NAME. I also have an access database with multiple forms and each form

Re: $$Excel-Macros$$ comparison between access forms to excel

. On Thu, Oct 13, 2011 at 6:02 PM, Swapnil Palande palande.swapni...@gmail.com wrote: Hi, Can you provide sample data. Regards, Swapnil. On Thu, Oct 13, 2011 at 5:48 PM, mrinal saha mris...@gmail.com wrote: hi folks, I have an excel sheet wherein column A contains EMP ID and column B

Re: $$Excel-Macros$$ Prefix 0 before the number- Help

hi, Use Text function to prefix 0 before number ex: =TEXT(A1, 000) Pls find attached excel. Regards, Swapnil. On Tue, Oct 11, 2011 at 1:48 PM, karan 1237 karan1...@gmail.com wrote: Hey Waheeb, Pls find enclosed. Kaяan http://www.facebook.com/singhkarann

Re: $$Excel-Macros$$ Prefix 0 before the number- Help

Hi, You can use Text function. =Text(A1, 000) this formula will convert number into text But if you want to keep it number only then use custom format as per suggested by Noorain On Tue, Oct 11, 2011 at 2:09 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Waheed, Please use

Re: $$Excel-Macros$$ Need a help -----very urgent

Hi, Further to Sam's solution, here is the complete code Sub converToDate() Dim sht As Worksheet Dim rng As Range Dim r1 As Integer, r2 As Integer For Each sht In ThisWorkbook.Sheets Set rng = sht.Range(A1) Do While UCase(Trim(rng.Value)) DATE Set rng

Re: $$Excel-Macros$$ Macro Reg:

Hi, Try following code Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) Dim sht As Worksheet Dim shtname As String If Target.HasFormula Then For Each sht In ThisWorkbook.Sheets If sht.Name ActiveSheet.Name And sht.Cells(Target.Row,

Re: $$Excel-Macros$$ regarding date format in excel vba

Hi, Use format function. ex. MsgBox Format(CDate(03/10/2011), dd-mmm-) Regards, Swapnil. On Mon, Oct 3, 2011 at 11:33 AM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Dear Friends, would u please help me about the below mentioned problem in VBA EXCEL I like to put the date

Re: $$Excel-Macros$$ regarding date format in excel vba

. and type dd/mm/ in Type text box Regards, Swapnil On Mon, Oct 3, 2011 at 12:28 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: thank you for your quick responce Swapnil Palande . But i want to say is there any option in excel to put the date value like dd/mm/,without

Re: $$Excel-Macros$$ Nobody is here who can do this?????

Provide URL On Tue, Apr 5, 2011 at 9:33 AM, karan 1237 karan1...@gmail.com wrote: * * ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı -- Forwarded message -- From: karan 1237 karan1...@gmail.com Date: Mon, Apr 4, 2011 at 3:12 PM Subject: $$Excel-Macros$$ Kind Attention :

Re: $$Excel-Macros$$ Macro to Go From One Cell to Another

Hi, I am not able to understand ur question. pls make more clear.. and if possible give sample data Regards, Swapnil. On Sat, Oct 30, 2010 at 10:19 PM, MT mtamia...@gmail.com wrote: I have a worksheet called Offering and was wondering how do I make a Macro to go from say cell C35 to E26 on

Re: $$Excel-Macros$$ Hi

Hi Pankaj, Please find attached excel for solution. Regards, Swapnil. On Thu, Sep 30, 2010 at 9:15 PM, Pankaj Kumar rajputpanka...@gmail.comwrote: Hi, exper it urgent i need u r help i attached my excel sheet -- *Warm Regards Pankaj kumar M: 9899816107 e-mail: rajputpanka...@gmail.com

Re: $$Excel-Macros$$ Outstanding Status Report

Hi Kalyan, I didn't understand your questions. But from figures you have mentioned in columns H to L, I have develop a solution. I hope it is what you are looking for. If have any query email it. Pls find attached excel for solution. Regards, Swapnil. On Wed, Sep 29, 2010 at 4:06 PM, Kal xcel

Re: $$Excel-Macros$$ help need in the fomula

Hi, Instead of Roundup try Round formula. Regards, Swapnil On Thu, Sep 23, 2010 at 3:49 PM, sudarshan rampe sidhu...@gmail.com wrote: hi friends hereby i am attaching a worksheet in which i need a addition in the given formula for getting the desired result. please help me out. -- Sidhu

Re: $$Excel-Macros$$ SumIF Sumproduct

Hi Nandine, Please find attached excel for solution. Here you have to concatenate the values of column A, B, C and then compare it. You will get an idea from attached excel. Regards, Swapnil. On Tue, Jun 29, 2010 at 9:23 PM, Nadine S n8dine4ma...@yahoo.com wrote: I'm resending since I

Re: $$Excel-Macros$$ First sips of Vba for Excel : Worksheet listing

Hi, Following is the correct code: Public Sub SheetList() Range(A1).Select For i = 1 To ActiveWorkbook.Sheets.Count Cells(i, 1) = ActiveWorkbook.Sheets(i).Name Next End Sub There is syntax error in your code in for loop And ActiveWorkbook.Sheets.Count this line will return

Re: $$Excel-Macros$$ Urgent Help needed regarding using macro

Hi Dilip, This is excellent solution. But I am not able to understand it. Can you explain it. Regards, Swapnil. On Sat, Jun 26, 2010 at 4:52 PM, Dilip Pandey dilipan...@gmail.com wrote: Thanks Dave...!!! -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91

Re: $$Excel-Macros$$ Help...Vlook up

Hi Ragina, I tried the Vlookup as you have mentioned in your query, but it is working for me. If you could provide the sample data then we can help you. Regards, Swapnil. On Wed, Jun 16, 2010 at 3:17 PM, ExcelVBA regina.medha...@gmail.com wrote: I am trying to use function Vlookup, but the

Re: $$Excel-Macros$$ Re: popup on s sheet ?

sorry because my english is horrible thanks again. José (from france) On 4 juin, 07:59, Swapnil Palande swapnilp1...@gmail.com wrote: Hi, It is possible to set visibility of chart. You can use the code given in http://cjoint.com/data/fFrTGZSr2t.htm Do following

Re: $$Excel-Macros$$ Re: popup on s sheet ?

Hi, It is possible to set visibility of chart. You can use the code given in http://cjoint.com/data/fFrTGZSr2t.htm Do following changes in that code: Instead of ActiveSheet.Shapes(AutoShape 3).Visible = False use ActiveSheet.ChartObjects(Chart 1).Visible = False Attached is the excel for your

Re: $$Excel-Macros$$ Macro File Access

Hi Deepak, Save you excel as Microsoft Office Excel Add-In. After saving excel as add-in, you will get access to macros of this excel in all other excels. You can add your own menu in menu bar. If you search on google you will get code for it. I have a code for it, if you want I can forward it to

Re: $$Excel-Macros$$ New to the group - basic question

Hi, =F24/(1-F25) In above formula (1-F25) will give you 35%. So basically you are dividing $18.25 by 35%. It will give you the value of 100% (i.e. if $18.25 is 35% then what is 100%) For ex: If I purchase xyz product for $18.25 with 65% discount on it. Now I want to calculate the original price

Re: $$Excel-Macros$$ Excel macro Help : Date of Previous day

Hi Sundarvelan, There is no need to write vba code for this. Use following function: =NOW()-1 //This will return date and time ex.: 5/24/2010 13:11 =DATE(YEAR(NOW()), MONTH(NOW()), DAY(NOW())-1) // this will return only date ex: 5/24/2010 Regards, Swapnil. On Tue, May 25, 2010 at 12:08 PM,

Re: $$Excel-Macros$$ Filling in cells from cell above

entire column select only those cells where you want to fill data. I hope you got it. If have any query get back to me. Regards, Swapnil. On Mon, May 3, 2010 at 12:15 PM, Steve sca...@aol.com wrote: On Apr 27, 2:43 am, Swapnil Palande swapnilp1...@gmail.com wrote: Hi Steve, Please find

Re: $$Excel-Macros$$ Filling in cells from cell above

Hi Steve, Please find attached excel for solution. Select the cells ( from first 3 columns) where you want to fill data and go to MyTools in menubar and press Fill Data. Regards, Swapnil. On Mon, Apr 26, 2010 at 9:59 AM, Steve sca...@aol.com wrote: I have spreadsheets of imported data from

Re: $$Excel-Macros$$ Sumproduct

Hi Jai, Sum product formula will give you sum of product of two columns or arrays. For ex: Check the following table : A B C Product QtyPrice / unit A 2 45 B 5 50 C 10 35 D

Re: $$Excel-Macros$$ Excel-Macro-VBA Code

Hi, Please see attached excel for solution. Regards, Swapnil. On Wed, Apr 21, 2010 at 1:57 PM, Sundarvelan N nsund...@gmail.com wrote: Hi Group Friends, Please help in this regard. I need to deleted the complete rows if the cell contains dates before 1/1/2007. Please provide VBA Code

Re: $$Excel-Macros$$ Permutations and combinations

Hi All, Check this excel. Regards, Swapnil. On Fri, Apr 16, 2010 at 1:51 PM, MD18358 michael.e.dray...@citi.com wrote: GAURAV and everyone. Thank you so much for the collective energy to resolve my questions. It seems like it was a great brain teaser. Here is my confession. I realize

Re: $$Excel-Macros$$ how to declare define global range in vba

Hi Ayush, Do the following steps 1. crate a function for your range ex: Public Function nRange() As Range 'Dim rng As Range 'Set rng = Sheets(M-RAW).Range(A1:A15) Set nRange = Sheets(M-RAW).Range(A1:A15) End Function 2) Now call this function where you want to use the defined range ex: Sub

Re: $$Excel-Macros$$ Bubble Chart

Hi Keith, Check the following link. http://www.winsteps.com/winman/index.htm?bubblecharts.htm Regards, Swapnil. On Fri, Jan 8, 2010 at 4:35 AM, Keith25252 kwersc...@cox.net wrote: Does anyone know how to change the shape in a bubble chart? I would like to change the circles to ovals. I

Re: $$Excel-Macros$$ Need help on Validation

Hi Mahesh, Didn't get what you want. Provide more details. Regards, Swapnil. On Tue, Dec 22, 2009 at 9:23 AM, Mahesh mahender.bi...@gmail.com wrote: Hi Friends, Attached herewith is the excel sheet for ur kind consideration. Please help. -- With Love, Mahesh Bisht --

Re: $$Excel-Macros$$ identifying duplicates

Hi Steve, Please find attached excel for solution to your query. I have use conditional formatting to find duplicate values in the lists. Following is formula: =COUNTIF(D3:D18, B3)=1 I have applied conditional formatting for list 1. If name is there in both the list then it will highlight that

Re: $$Excel-Macros$$ Concatenate, including blank fields

Hi, The answer is in your questions only. Just put space in blank field. I hope you got what I am trying to say. Regards, Swapnil. On Mon, Nov 23, 2009 at 2:31 PM, Steve sca...@aol.com wrote: I am trying to concatenate 8 columns, all of which containe either a single character or a blank.

$$Excel-Macros$$ Re: help plz

Hi Ashish, Use following formula to remove whitespace. =SUBSTITUTE(B2, , ) Regards, Swapnil. On Sun, Sep 6, 2009 at 9:29 PM, ashish koul koul.ash...@gmail.com wrote: hi thanks i went through the site i am able to clean and trim but in below case i am not abe to find the solution

$$Excel-Macros$$ Re: Using IF, AND, OR Function in Single formula

to create userdifined function. or where to see that function. Regards Dharmesh Shah On Wed, Aug 19, 2009 at 6:56 PM, Swapnil Palande swapnilp1...@gmail.comwrote: Hi Prasad, Please find attached excel for solution. I have write user define function for this. You have to use following

$$Excel-Macros$$ Re: Using IF, AND, OR Function in Single formula

Hi Prasad, Please find attached excel for solution. I have write user define function for this. You have to use following formula to calculate rate: =calcRate(A3, C3) In above formula first parameter is type of rate and second parameter is value. You can use If condition also to solve this

$$Excel-Macros$$ Re: help with formula for report

into by work file? can anybody else help me with excel formula. thank you regards Harris On Jul 31, 9:00 pm, Swapnil Palande swapnilp1...@gmail.com wrote: Hi Harris, It may be possible to do this using formula. But I don't know how to do it using formula. You have to just change

$$Excel-Macros$$ Re: Please help me to solve this problem

Hi Serghei, Thanks for your help. It is working fine. Meanwhile I also got the solution. I have written a macro for my 1st query ie. for calculating % value automatically and for second query I am doing conditional formatting. Following is the formula for conditional formatting. =OR(AND(L5 =

$$Excel-Macros$$ Re: help with formula for report

Hi Harris, Please find attached excel for solution to your problem. Press update button to run macro. If you have any query let me know. Best regards, Swapnil. On Fri, Jul 31, 2009 at 10:53 AM, harris a harris...@gmail.com wrote: Hello, I am enclosing file example.xls. I need help in

$$Excel-Macros$$ Re: Please help me to solve this problem

Hi Serghei, Thanks, Macros are working properly. Best regards, Swapnil. On Fri, Jul 31, 2009 at 2:33 PM, Serghei Ovanesov oserg...@hotmail.comwrote: Hello Swapnil, Find attached the same solution in Excel 2007. However you must insure you have macro's security settings set changed to

$$Excel-Macros$$ Re: Please help me to solve this problem

Hi Serghei, Thanks for giving reply. I saw you excel, but it is not solving my problem. I am not able to find macro written in your excel. I want to apply conditional formatting on Major suppliers columns PP and PE i.e. column M and N Suppose If I insert supplier name in PP column (i.e. cell

$$Excel-Macros$$ Re: Simple Question - Search and Replace for Current Sheet Only in VBA

Hi Andrew, Solution given by Norman is working fine. Pls show your code so that we can understand what is the problem. Regards, Swapnil. On Mon, Jul 6, 2009 at 9:49 AM, Andrew Ritland ritl...@gmail.com wrote: I tried your suggestion but the VBA still replaces all occurrences of 1234 across the

$$Excel-Macros$$ Re: How to convert the first letter of every cell in a colum to caps (upper case) and rest to lower case

Hi, Use following formula: =UPPER(LEFT(B15,1))LOWER(RIGHT(B15,LEN(B15)-1)) Regards, Swapnil. On Wed, Jun 24, 2009 at 4:16 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Subu, Use the following function:- =PROPER(MID(A1,1,FIND(_,A1)-1))_LOWER(RIGHT(A1,LEN(A1)-FIND(_,A1))) Solved workbook