Re: $$Excel-Macros$$ Urgent Requirement :: Hadoop/Bigdata Engineer_Hillsboro,OR/Beaverton,OR_6+Months

Any opening for Excel access vba developer On Mon 20 Aug, 2018, 9:31 PM Atulit Tripathi, wrote: > Hi, > > > > This is Atulit from NLB Services INC. > > Hope you are doing well. > > > > Please find the below position, if you feel comfortable, please share > your/Consultant’s profile and let me

Re: $$Excel-Macros$$ .Net Application Development----Los Angeles, CA-----4 Months Contract

Any opening for Excel access vba developer On Mon 10 Sep, 2018, 7:45 PM kiran Toj, wrote: > Hi Friends, > > Hope you are doing great, > > > > I have an urgent requirement from one of my esteem client, I will > appreciate if you can have an eye on the below requirement and send me your >

Re: $$Excel-Macros$$ Re: Macros for screenshot

first you need to open that excel file and activate that particular excel file by using application.actiavte "workbbok name" and paste into excel file in desired range. On Fri, Mar 31, 2017 at 4:40 PM, suresh k wrote: > Experts any inputs for the below requirement? > On

$$Excel-Macros$$ Export File from SAP

Hi All I am trying to export SAP Data into excel by using vba,i have recorded a VBSrcipt but, Save as step was not recorded,my code will stuck when saveas dialogue box open from SAP window. i was trying by using send key but code is not after opening saveas dialouge box. Please suggest --

Re: $$Excel-Macros$$ Export File from SAP

. > > Thanks > > Rajesh > > On Wed, Dec 16, 2015 at 12:52 PM, priti verma <pritiverma1...@gmail.com> > wrote: > >> Hi All >> >> I am trying to export SAP Data into excel by using vba,i have recorded a >> VBSrcipt but, Save as step was

Re: $$Excel-Macros$$ Multiple Hyperlink

Yeah, You can create name range and put that name range into the hyperlink On Tue, Jun 2, 2015 at 11:43 PM, chintz rajanichintan...@gmail.com wrote: Dear to all, please can anyone help me to resolve below problem. i have attached excel sheet which mention multiple hyperlink error problem

$$Excel-Macros$$ Looking for job

Hi There, Is there any job for vba developer. Thanks Priti -- 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

Re: $$Excel-Macros$$ Help Required in MS Access(Urgent)

Please try these query. Query1. SELECT Table1.Name, Table2.NAme FROM Table1 INNER JOIN Table2 ON cstr(Table1.Name) = cstr(left(Table2.NAme,len(Table1.Name))); query2. UPDATE Table1 INNER JOIN Query1 ON Table1.Name = Query1.Table1.NAme SET Table1.Name = [Query1].[Table2]![NAme] WHERE ((Not

Re: $$Excel-Macros$$ error while sending email with gmail (using CDO)

Hi , Thanks for reply.but now i am getting below error- The transport failed to connect to the server. On Fri, Mar 28, 2014 at 5:07 AM, Ricardo(R) ricardo...@gmail.com wrote: Hi Priti Verma, try this: Sub sendmail() Dim imsg As Object Dim iconf As Object Dim flds As Object Dim schema

$$Excel-Macros$$ error while sending email with gmail (using CDO)

Hi all, Can someone tell me why i am getting this error---The sendusing confugration value is invalid. i am working on access version 2010.and using this code. Sub sendmail() Dim imsg As Object Dim iconf As Object Dim flds As Object Dim schema As String Dim stremailId As String Dim strpassword

Re: $$Excel-Macros$$ Fwd: Lists Output request

for first query try thi with CSE =SMALL(IFERROR(IFERROR(SMALL(IF($C$5:$C$14$B$5:$B$14,$C$5:$C$14,),ROW(INDIRECT(1:$C$5:$C$14))),IF($B$5:$B$11$C$5:$C$14,$B$5:$B$11,)),),ROW(INDIRECT(1:COUNTA($C$5:$C$14 and for second try this wit CSE

Re: $$Excel-Macros$$ how to retrieve already applied conditional formatting on a cell

Do you want this or something else? Sub fc() Dim cf As FormatCondition For Each cf In Sheet13.Range(a1).FormatConditions Debug.Print cf.Formula1 Debug.Print cf.Interior.Color Debug.Print cf.Font.Color Debug.Print cf.NumberFormat Debug.Print cf.AppliesTo.Address

Re: $$Excel-Macros$$ Need VBA code for Sumifs function.

HI, If you want to put formula by vba please try this Sub fillformula() Dim lngLastRow As Long Dim lngLastCol As Long lngLastRow = Sheet2.UsedRange.Rows.Count lngLastCol = Sheet2.UsedRange.Columns.Count Sheet2.Range(d3).Formula = =iferror(if( Range(c3).Address(0, 1) = Count

Re: $$Excel-Macros$$ Need VBA code for Sumifs function.

. Thanks Regards, Prabhu R On 19 March 2014 13:08, priti verma pritiverma1...@gmail.com wrote: HI, If you want to put formula by vba please try this Sub fillformula() Dim lngLastRow As Long Dim lngLastCol As Long lngLastRow = Sheet2.UsedRange.Rows.Count lngLastCol = Sheet2

Re: $$Excel-Macros$$ Name Range Change through VBA

try this, Sub namerange() Dim rngRange As Range Dim rngCell As Range Set rngRange = Application.InputBox(select range, , , , , , , 8) For Each rngCell In rngRange.Columns(1).Cells ThisWorkbook.Names.Add rngCell, rngCell.Offset(, 1).Formula Next End Sub On Thu, Mar 6, 2014 at 11:24 PM,

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

you can also try this without vba please see attach file. On Fri, Feb 28, 2014 at 2:25 AM, Ravinder ravindervbacli...@gmail.comwrote: Thanks dear *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Prafull Jadhav *Sent:* Friday, February 28,

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

Hi Amar, it is simple index match formula and 1 indicates row number. please go over this for more clarification. https://sites.google.com/site/e90e50fx/home/Excel-Hyperlink-to-a-dynamic-range -- 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) !

Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search

- is used for data validation. I have created another file but i am unable to create the hyperlink for the same sheet. Thanks in Advance Regards, Prafull Jadhav 9920553518 On 28 February 2014 17:38, priti verma pritiverma1...@gmail.com wrote: Hi Amar, it is simple index match

Re: $$Excel-Macros$$ Simple ?? Date Format Problem

hi , try this formula and then paste special value. =TEXT(A2,mmdd) it will be convert into number. On Thu, Feb 27, 2014 at 9:19 AM, Bill Q ronsmith...@gmail.com wrote: Please see attached file. - Original date is Row A - I formatted the date through custom formatting to get my

Re: $$Excel-Macros$$ Excel 2010 - VBA Code to sort on multiple columns

Hi, you are getting this error because you did not mention row number here* Range(A2:AG).Select* if you want to sort multiple columns at once please try this. range sheet and range according to yours Sub sortrange() ActiveSheet.Sort.SortFields.Clear ActiveSheet.Sort.SortFields.Add

Re: $$Excel-Macros$$ mail merge with Cc options

HI Vijayendra, please find attach file. On Mon, Feb 17, 2014 at 7:56 AM, Vijayendra Rao vijayendrar...@gmail.comwrote: Dear Ashish, Thanks for your consideration. I know basic mail merge, I need to connect the CC in email and change the subject line for each email. It has to pick from

Re: $$Excel-Macros$$ Border Issue in VBA

you can use only these line change range according to yours- Range(a1).CurrentRegion.borders.Weight = 2 Range(a1).CurrentRegion.BorderAround , xlMedium On Wed, Feb 12, 2014 at 5:43 AM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, am trying to put borders using vba but am getting

Re: $$Excel-Macros$$ wanna halp in conditional icon set

PFA On Fri, Jan 17, 2014 at 10:04 PM, Dhaval Shah ( Ahd ) todhavals...@gmail.com wrote: Hello friends I want help in conditional icon set … pls refer attached sheet -- 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

Re: $$Excel-Macros$$ sum numbers only

2013 21:01, priti verma pritiverma1...@gmail.com wrote: Hi Satiqjaffar ali, Please try this With Control + Shift + enter =SUM(IFERROR(VALUE(IF(G16F17=$E$6:$E$12$F$6:$F$12,$G$6:$G$12,)),)) On Mon, Dec 16, 2013 at 9:46 AM, Satiqjaffar ali satiqjaffar...@gmail.com wrote: Hello experts, Can

Re: $$Excel-Macros$$ sum numbers only

Hi Satiqjaffar ali, Please try this With Control + Shift + enter =SUM(IFERROR(VALUE(IF(G16F17=$E$6:$E$12$F$6:$F$12,$G$6:$G$12,)),)) On Mon, Dec 16, 2013 at 9:46 AM, Satiqjaffar ali satiqjaffar...@gmail.comwrote: Hello experts, Can you please assist me to sum numbers only in cell. Please

Re: $$Excel-Macros$$ currencies

Hi Krishnaraddi, Please see the attachment. On Thu, Oct 10, 2013 at 6:53 AM, Krishnaraddi V. Madolli krishnaraddi.mado...@asia.xchanging.com wrote: Hi Experts, ** ** Please find below table for name and currencies: ** ** *Name* *Currencies* Krishna USD

Re: $$Excel-Macros$$ Delete Line

Sub deleteline() Dim rngRange As Range Dim rngCell As Range Dim rngUnion As Range Dim strvalue As String Dim intcolumn As Integer Set rngRange = ThisWorkbook.Worksheets(1).UsedRange intcolumn = InputBox(Please enter the Column Number,where you have that value

Re: $$Excel-Macros$$ VLOOKUP doubt

you can use index match if you want to do this only with Vlookup You can try This =VLOOKUP(I2,CHOOSE({1,2,3,4},D:D,C:C,B:B,A:A),3,0) On Mon, Sep 23, 2013 at 11:09 AM, Satiqjaffar ali satiqjaffar...@gmail.comwrote: Hello experts, I have some doubt in VLOOKUP, that how can i get lookup value

Re: $$Excel-Macros$$ Clear row contents based on criteria

Hi, Replace these line If Range(l2:l r).Value = Rolled-Over Then Range(A cell :Q cell).ClearContents with If cell.Value = Rolled-Over Then cell.EntireRow.ClearContents On Fri, Sep 20, 2013 at 7:20 AM, Hilary Lomotey resp...@gmail.com wrote: Hello Champs, i have written

Re: $$Excel-Macros$$ Clear row contents based on criteria

priti for the response, the first line of code is ok but i dont want to delete entire because i may have other information on that row in another column, how can i manage that? is it possible? thanks On Fri, Sep 20, 2013 at 2:36 PM, priti verma pritiverma1...@gmail.comwrote: Hi, Replace

Re: $$Excel-Macros$$ Re: PDF to txt by vba code

me on this Regards, Priti verma -- 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

Re: $$Excel-Macros$$ PDF to txt by vba code

Thanks ashish Sir, On Tue, Sep 3, 2013 at 9:43 AM, ashish koul koul.ash...@gmail.com wrote: http://www.myengineeringworld.net/2013/03/vba-macro-to-convert-pdf-files-into.html see if it helps On Tue, Sep 3, 2013 at 6:52 PM, priti verma pritiverma1...@gmail.comwrote: Please ignore

$$Excel-Macros$$ Pdf to .txt

Hi group, i want to convert PDFs file to .txt file. i have been search it on Google ,but not get any solution. Can someone help me on this Regards, Priti verma -- 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

$$Excel-Macros$$ PDF to txt by vba code

Please ignore previous mail and consider on this. i want to convert PDFs file to .txt file. through vba code. i have been search it on Google ,but not get any solution. Can someone help me on this Regards, Priti verma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

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

Most Welcome Niraj On Sat, Aug 3, 2013 at 11:31 PM, xlstime xlst...@gmail.com wrote: Welcome Niraj . Enjoy Team XLS On Sun, Aug 4, 2013 at 10:56 AM, Niraj Shirali nirajshir...@gmail.comwrote: Hello All, My name is Niraj Shirali, from Mumbai. Working with

Re: $$Excel-Macros$$ spit varios sheets of one excel file to related other excel file

sheets. Thanks Regards, sagar On Mon, Jul 22, 2013 at 6:41 PM, priti verma pritiverma1...@gmail.comwrote: Try this code Change Strpath as per your Path Sub creatnewWkb() Dim wkb As Workbook Dim strpath As String Dim wks As Worksheet Dim wkbnwebook As Workbook Set wkb

$$Excel-Macros$$

folderEfile11,file11 folder F folder Nfile 12,file14 folder M file13 folder E file12,file13 folder 4...and so on Regards , priti verma -- Are you =EXP(E:RT) or =NOT(EXP

Re: $$Excel-Macros$$

[mailto: excel-macros@googlegroups.com] *On Behalf Of *priti verma *Sent:* Wednesday, July 24, 2013 5:21 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ ** ** Hi everyone, Help me on this , i want all files name from folders. ** ** Folder1

Re: $$Excel-Macros$$

Call ListIt(sSubFolder.Path, (tCol + 1)) Next End Function Pada 24/07/2013 19:37, priti verma menulis: Thank for quick response But this code is not working fine . Its giving Only first folder 's file name . I mean I have lots of folder and and file in main folder.and folder

Re: $$Excel-Macros$$

20:33, priti verma menulis: Thanks Dp, But its giving only Nested foldersname. I want files name. Anyway i got idea from your Code On Wed, Jul 24, 2013 at 7:22 AM, De Premor d...@premor.net wrote: PFA Dim Rng As Range, iRow As Integer Sub GetFolder() Dim fldr As FileDialog

Re: $$Excel-Macros$$ spit varios sheets of one excel file to related other excel file

Try this code Change Strpath as per your Path Sub creatnewWkb() Dim wkb As Workbook Dim strpath As String Dim wks As Worksheet Dim wkbnwebook As Workbook Set wkb = ThisWorkbook strpath = wkb.Path For Each wks In wkb.Worksheets wks.Copy wks.Paste ActiveWorkbook.SaveAs _

Re: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet

Hi vijay, PFA On Mon, Jul 22, 2013 at 8:26 AM, Vijay Gande vijaykumar.ga...@gmail.comwrote: Hi there, I'm amateur with excel macros and need help with the following task, I've an excel workbook with 16 sheets, all the sheets have same # of columns but different # of rows. My

Re: $$Excel-Macros$$ Excel Formula..Sumproduct..

Hi Deepak, you also try this one =SUMIF($A$2:$A$9,Snickers ,B2:B9)+SUMIF($C$2:$C$10,Potato,D2:D10) On Wed, Jul 17, 2013 at 7:46 PM, ashish koul koul.ash...@gmail.com wrote: =SUMPRODUCT(($A$2:$A$9=Snickers )*($B$2:$B$9)+($C$2:$C$9=Potato)*($D$2:$D$9)) see if it helps On Wed, Jul 17,

Re: $$Excel-Macros$$ Query on lookup left side and second, and third values

PFA On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E emuralidha...@gmail.comwrote: Dear Friends good afternoon, I need help reg. lookup values 1.It is possible to vlookup the values for the left side 2.Vlookup for the second value(occurence), third value Is their any other ways or

$$Excel-Macros$$ Challanging queri

Hi group , Please try to solve this. Queri based on conditional formating If b2 a2 then up arrow and coluor should be green . if b2a2 then Down arrow and colour should be red. See PFA For more clearification Regards , Priti verma -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ Challanging queri

use formula =B2A2 then format---Numbercustom to set colour and arrow. Regards, Rupali Joshi On Mon, Jul 15, 2013 at 4:34 AM, priti verma pritiverma1...@gmail.comwrote: Hi group , Please try to solve this. Queri based on conditional formating If b2 a2 then up arrow and coluor

Re: $$Excel-Macros$$ Challanging queri

If the value is same in both column ,then up arrow should be apply On Mon, Jul 15, 2013 at 6:04 AM, Pravin Gunjal isk1...@gmail.com wrote: And what about if the value is same in both columns. -- Forwarded message -- From: priti verma pritiverma1...@gmail.com Date: Mon, Jul

Re: $$Excel-Macros$$ Challanging queri

can you please share an example file. On Mon, Jul 15, 2013 at 6:44 AM, devanand nayak devnayak_...@hotmail.comwrote: I have a full sheet of monthly party sales on day today basis with qty tin no net amount vat amt . I want it to patywise tinwise total Kindly inform me priti verma

Re: $$Excel-Macros$$ New here

Most welcome Deepak. On Sun, Jul 14, 2013 at 5:59 PM, De Premor d...@premor.net wrote: Hi Deep, glad to see you here too Rgds, [dp] Pada 14/07/2013 19:27, Deepak Singh menulis: *I am Deepak Singh, i have been referred to this group by one of my friend who is already part of this

Re: $$Excel-Macros$$ Pie Chart Help

inserted some pie-shapes above the Doughnut graph in attachment. please find the attachment for data and more clarities. Warm regards, Rajan Sharma On Thu, Jun 27, 2013 at 12:27 PM, priti verma pritiverma1...@gmail.comwrote: Hi vijay, Pfa for more clarification On Wed, Jun 26, 2013 at 1

Re: $$Excel-Macros$$ Sumproduct help

=SUMPRODUCT(N($C$2:$C$11=E5),N($B$2:$B$11=A)) with cse On Tue, Jul 2, 2013 at 6:51 AM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, Could you please help me in the attached file instruction is there in it. Thanks in advance. Regards, Chandra -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Sumproduct help

, 2013 at 7:30 PM, priti verma pritiverma1...@gmail.comwrote: =SUMPRODUCT(N($C$2:$C$11=E5),N($B$2:$B$11=A)) with cse On Tue, Jul 2, 2013 at 6:51 AM, Chandra Shekar chandrashekarb@gmail.com wrote: Hi, Could you please help me in the attached file instruction is there in it. Thanks

Re: $$Excel-Macros$$ Pie Chart Help

Hi vijay, Pfa for more clarification On Wed, Jun 26, 2013 at 1:57 PM, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Respected priti, I tried to paste the donought chart on the pie chart,but only a single chart is showing not both charts,how should we make both charts show at a time like the

Re: $$Excel-Macros$$ Pie Chart Help

Pfa Are you looking for this On Wed, Jun 26, 2013 at 11:56 AM, Rajan sharma rajansharma9...@gmail.comwrote: Yes sir, your points are valid, but you know, My requirement is not that. let me explain you, please see the below image. There you will find A and B is the Main type, C (light orange

Re: $$Excel-Macros$$ Pie Chart Help

HI vijay use following steps 1).prepare two chart one is pie chart based on intermediate data and second is doughnut chart based on original data. 2).paste doughtnut chart on pie chart 3) and then arrange data labels of corresponding chart On Wed, Jun 26, 2013 at 12:53 PM, P.VIJAYKUMAR

$$Excel-Macros$$ Subtatal by VBA(urgent)

Hi group, pleaase help me to solve this .see attachment for more clarification. I want a macro for this. Thanks in advance Priti verma -- 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

Re: $$Excel-Macros$$ Subtatal by VBA(urgent)

Thanks sam its working fine, On Sat, Jun 22, 2013 at 1:14 PM, Sam Mathai Chacko samde...@gmail.comwrote: Range(A1).CurrentRegion.Subtotal GroupBy:=3, Function:=xlSum, TotalList:=Array(4, 5, 6) Sam Mathai Chacko On Sat, Jun 22, 2013 at 1:08 PM, priti verma pritiverma1...@gmail.comwrote

Re: $$Excel-Macros$$ Subtatal by VBA(urgent)

Hi Sam, do you Know any good site from where i Learn array in vba. On Sat, Jun 22, 2013 at 1:22 PM, priti verma pritiverma1...@gmail.comwrote: Thanks sam its working fine, On Sat, Jun 22, 2013 at 1:14 PM, Sam Mathai Chacko samde...@gmail.comwrote: Range(A1).CurrentRegion.Subtotal

Re: $$Excel-Macros$$ Date format to be changed

kya baat h sir On Sat, Jun 22, 2013 at 5:56 PM, Pravin Gunjal isk1...@gmail.com wrote: Dear Ahmed, Thanks it's working fine.. Nice to see you here after long time.. Regards Pravin Gunjal. -- Forwarded message -- From: Ahmed Honest ahmedhon...@gmail.com Date: Sat, Jun

Re: $$Excel-Macros$$ Horizontal to Vertical in One colume

Yes you can do it with macro, See pfa On Fri, Jun 21, 2013 at 11:29 AM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear Madam, Thanks a lot ... Can we make it from macro ... Regards, Prafull Jadhav. On Fri, Jun 21, 2013 at 11:24 AM, priti verma pritiverma1...@gmail.comwrote: Hi

Re: $$Excel-Macros$$ Need a Fastest way

yes i think On Wed, Jun 19, 2013 at 6:41 AM, VBA VABZ v...@vabs.in wrote: Hi Highlighted means cells filled with specific color or selected cells. Thanks On Wed, Jun 19, 2013 at 5:58 PM, rajan verma rajanverma1...@gmail.comwrote: can anyone suggest a faster way to know which cells

Re: $$Excel-Macros$$ Horizontal to Vertical in One colume

Hi prafull, PFA On Fri, Jun 21, 2013 at 11:16 AM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear Expert, Dear All, My date is horizontal ..i want to pull it in one column . thanks in advance Regards, Prafull Jadhav. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ formula require

pfa You can use this one also, On Tue, Jun 18, 2013 at 3:12 PM, Prabhakar S H prabakar.k...@gmail.comwrote: Hi Team, I want to split data into name, bank account no ifsc code separetely in attached file. Please help me to get formula. Rgds, Prabhakar -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ formula require

Great trik On Tue, Jun 18, 2013 at 6:05 PM, De Premor d...@premor.net wrote: Little tricky :D On 18/06/2013 19:13, priti verma wrote: Hi Prabhakar, previous solution was not dynamic , please see another approach On Tue, Jun 18, 2013 at 3:12 PM, Prabhakar S H prabakar.k

Re: $$Excel-Macros$$ CAPTURE ATTENDENCE FROM MULTIPLE SHEET

You can also use this one

Re: $$Excel-Macros$$ Double Click To Copy Data To Another Worksheet

Hi sajid you can also try this Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) ActiveSheet.Next.Range(Target.Address).Value = Target.Value Cancel = True End Sub On Sat, Jun 8, 2013 at 10:34 AM, SAJID MEMON sajidwi...@hotmail.com wrote: Dear Experts,

Re: $$Excel-Macros$$ Double Click To Copy Data To Another Worksheet

on click. We have to change taeget once data is copied in to. Feedback appreciated. Thanks On 16 Jun 2013 16:56, priti verma pritiverma1...@gmail.com wrote: Hi sajid you can also try this Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean

Re: $$Excel-Macros$$ Double Click To Copy Data To Another Worksheet

Sub On Sun, Jun 16, 2013 at 5:04 PM, VBA VABZ v...@vabs.in wrote: Hi priti This will keep on overriding existing data one on anothet on click. We have to change taeget once data is copied in to. Feedback appreciated. Thanks On 16 Jun 2013 16:56, priti verma pritiverma1...@gmail.com wrote

Re: $$Excel-Macros$$ Report (needs to be formatted)

little more explanation would be great to give answer quickly, do you need data validation or formula, can you explain last point specially ? On Thu, Jun 13, 2013 at 1:16 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.uk wrote: Dear Experts, Can someone help me on the below.

Re: $$Excel-Macros$$ AverageIF and ABS function

you can use this, =IFERROR(AVERAGE(IF(AE4:AZ4=1,ABS(E4:Z4))),) On Thu, Jun 13, 2013 at 7:49 PM, arshteynb...@gmail.com wrote: All, Can someone advise me on this formula: =IFERROR(AVERAGEIF(AE4:AZ4,1,E4:Z4),) How can you embed an ABS function in there? You cannot put it in here *

Re: $$Excel-Macros$$ help needed

Can you please share your file On Sun, Jun 9, 2013 at 2:32 PM, thameem thamee...@gmail.com wrote: Dear sir's, I have problem in excel graph, its automatically getting enlarged, if i close and open excel, then again it will be in original size, with out any modification, please advise me

Re: $$Excel-Macros$$ Rerquire Formula.xlsx

Activity for yes status =COUNTIFS($D$3:$D$56,I5,$C$3:$C$56,yes) Activity for no status =COUNTIFS($D$3:$D$56,I5,$C$3:$C$56,no) On Wed, Jun 5, 2013 at 7:26 PM, Gulam Hameed gulamham...@gmail.com wrote: Dear Experts, ** ** Please find the attached xl file formula required please

Re: $$Excel-Macros$$ Know cell.address for a clicked hyperlink

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) MsgBox Target.Parent.Address End Sub On Tue, Jun 4, 2013 at 1:42 AM, Kim Sig Andersen kimsig1...@gmail.comwrote: Hi When clicking a hyperlink, I want to know the address for the cell that holds the hyperlink (internal to

Re: $$Excel-Macros$$ Formula require

try this =SUMIFS($J$9:$J$17,$H$9:$H$17,Cars,$I$9:$I$17,black) On Tue, Jun 4, 2013 at 4:49 PM, Prabhakar S H prabakar.k...@gmail.comwrote: Hi Team, i want to get formula to find Total value of cars with black color only. pls help. Rgds, Prabhakar -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$

PFA, It may be helpul On Tue, Jun 4, 2013 at 5:21 PM, Raj Kumar rajlu...@gmail.com wrote: Hi, i have lots of data in excel Column A. in which some records are in Upper Case. By which formula how can we find out these Records raj kumar Raj kumar SADAN KUMAR MADAN KUMAR sohan kumar

$$Excel-Macros$$ data validation

HI Team, Need your help in data validation.query is mentioned in attached file. -- 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,

Re: $$Excel-Macros$$ Count Names City Wise

use this =SUM(N(FREQUENCY(IF($F$4:$F$13=A4,IF($G$4:$G$13,ROW($G$4:$G$13),),),IF($F$4:$F$13=A4,IF($G$4:$G$13,ROW($G$4:$G$13),),))0)) On Fri, May 31, 2013 at 12:59 PM, Deepak Rawat deepakexce...@gmail.comwrote: Hi, I need a formula to count names of managers city wise, attached Pls advise

Re: $$Excel-Macros$$ Count Names City Wise

have u enter it with CSE, PFA for better clarification On Fri, May 31, 2013 at 1:17 PM, Deepak Rawat deepakexce...@gmail.comwrote: its giving 1 for delhi rather than 3 Kindly check regards On Fri, May 31, 2013 at 1:08 PM, priti verma pritiverma1...@gmail.comwrote: use this =SUM(N

Re: $$Excel-Macros$$ Look up value from Column and rows

try this =SUMPRODUCT(N($A$2:$A$83=$T$8)*N($B$2:$B$83=$U$8)*N($C$2:$C$83=$X9)*N($D$2:$D$83=Y$8)*INDEX($A$2:$P$83,,MATCH($V$8,$A$1:$P$1,0))) On Thu, May 30, 2013 at 1:57 PM, Chaya chayamon...@gmail.com wrote: Thank you so much Dear Xls. I was amazed you have used sum function, Actually i

Re: $$Excel-Macros$$ Uniqe date count citywise

use this as an array formula =SUM(N(FREQUENCY(IF($C$1:$C$85=F9,$A$1:$A$85,),IF($C$1:$C$85=F9,$A$1:$A$85,))0)) On Thu, May 30, 2013 at 1:34 PM, Deepak Rawat deepakexce...@gmail.comwrote: Hi, I have to count unique count of date citywise Kindly help on both ( formula macro) file is attached

Re: $$Excel-Macros$$ Uniqe date count citywise

...@gmail.comwrote: Dear Priti Madam, Can you tell me , What N stand in below formula ? On Thu, May 30, 2013 at 2:22 PM, priti verma pritiverma1...@gmail.comwrote: use this as an array formula =SUM(N(FREQUENCY(IF($C$1:$C$85=F9,$A$1:$A$85,),IF($C$1:$C$85=F9,$A$1:$A$85,))0)) On Thu, May 30, 2013

Re: $$Excel-Macros$$ How to split cell in Excel

Can you please share example file so that we can understand problem. On Mon, May 27, 2013 at 12:29 PM, Prathap prathap@gmail.com wrote: Hi Experts, How do we split a cell in excel in to two where one part of text is vertical aligned and other is being horizontal aligned. Pls help

Re: $$Excel-Macros$$ IF / Nested IF Formula Help **URGENT**.

Hi Yogesh , You can use this formula, =IF((INT(MID(U3,1,FIND(-,U3,1)-1)/7)+1)10,Week 10,WeekINT(MID(U3,1,FIND(-,U3,1)-1)/7)+1) On Tue, May 28, 2013 at 9:51 AM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear Yogesh, use below formula =WEEKNUM() On Tue, May 28, 2013 at 8:27 AM, David

Re: $$Excel-Macros$$ Auto filter criteria

use criteria like this head head DOC TYPE 0 3 AF On Sat, May 25, 2013 at 11:57 AM, excel learner knowledgeforex...@gmail.com wrote: hi Experts, Once again am back with another query on Autofilter i could able to manage Advance filter criteria function perfectly in case of one

Re: FW: $$Excel-Macros$$ Dynamic KM Difference Formula

Hi Amit sir, Please use this formula,if it helps =ABS(IF(IF(AND(H2=yes,G3=no),AND(H2=yes,G4=yes))=TRUE,D2-D4,0)-IF(AND(H2=yes,G3=yes),D2-D3,0)) On Sat, May 25, 2013 at 3:24 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Can someone please look at my query help me? ** ** *From:*

Re: $$Excel-Macros$$ Help Please - Data sub validation

HI Chaya, PFA see if it helps, On Tue, May 21, 2013 at 9:42 AM, Chaya chayamon...@gmail.com wrote: Dear Experts, Please help in doing data sub validation. Please see the attached sample. What ever I select in the Category No column, the same corresponding item should be drop down in H

Re: $$Excel-Macros$$ Help Please - Data sub validation

HI chaya, I hope this is what you're asking ... On Tue, May 21, 2013 at 2:59 PM, Chaya chayamon...@gmail.com wrote: Dear Priti, As always you did the great logical solution. Infact i really don't understand the formula used for data validation in Level2 (very huge long), but i have got

Re: $$Excel-Macros$$ split address one bye one based on , comma

...@gmail.comwrote: wow.. really u have big sound in formula... ur formula is confusing to understanding.. but u done it...really great.. :) On 14 May 2013 18:45, priti verma pritiverma1...@gmail.com wrote: If u want you do this with excel formula you can use this one. See the attachment

Re: $$Excel-Macros$$ Excel Validation

Hi DHAMODHARAN, *i have a solution ,**May I restrict to enter that entry that is not a PAN number in that column.* *The benefit of this will be there will be no possibilities to enter a wrong PAN number.* *let me know if u want this kind of solution.* *Regards* On Thu, May 16, 2013 at 2:07 AM,

Re: $$Excel-Macros$$ Paste Vertically

Hi Chaya , PFA, without vba If it helps On Tue, May 14, 2013 at 4:11 PM, Chaya chayamon...@gmail.com wrote: Dear experts, I have set of data which need to be copy and paste in vertical way. I have more than thousand columns, So very taugh to copy and paste one by one. I have

Re: $$Excel-Macros$$ Paste Vertically

of learning. Hope you don't mind Priti. Regards, Abhishek On Tue, May 14, 2013 at 5:34 PM, priti verma pritiverma1...@gmail.comwrote: Hi Chaya , PFA, without vba If it helps On Tue, May 14, 2013 at 4:11 PM, Chaya chayamon...@gmail.com wrote: Dear experts, I have set of data which

Re: $$Excel-Macros$$ Conditional formatting ( After 2 criteria match)

Hi Amar, you can use this formula in conditional formatingnew rule. =C31=INDEX($C$31:$J$38,MATCH($F$5,$C$31:$C$38,0),MATCH($C$4,$C$31:$J$31,0)) please let me know if this will not fulfill your requirement . Regards Priti verma On Sat, May 11, 2013 at 1:17 PM, amar takale amartak...@gmail.com

Re: $$Excel-Macros$$ Split with formula

Hi Chaya, Pfa On Thu, May 9, 2013 at 6:30 PM, Chaya chayamon...@gmail.com wrote: Thanks Waheed, Thanks for that, but i dont want to split by text to coloumns, i want with formulas in one cell. hope you got my point of query. Regards, Chaya On Thu, May 9, 2013 at 6:26 PM, Shaik

Re: $$Excel-Macros$$ Split with formula

without array formula in your attached sheet solved. ** ** ** ** Many many thanks to all. ** ** ** ** ** ** ** ** ** ** ** ** Regards, ** ** Chaya ** ** On Thu, May 9, 2013 at 7:08 PM, priti verma pritiverma1...@gmail.com wrote: Hi Chaya

Re: $$Excel-Macros$$ Highting number

On Wed, May 8, 2013 at 11:33 AM, Chaya chayamon...@gmail.com wrote: Dear Experts, Please help me in highting number which is greater than 2 by excel vba in red colour. from B2: F12 range. Thanks Regards, Chaya -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

Re: $$Excel-Macros$$ Highting number

= vbRed End If Next rngCell End Sub On Wed, May 8, 2013 at 12:11 PM, priti verma pritiverma1...@gmail.comwrote: On Wed, May 8, 2013 at 11:33 AM, Chaya chayamon...@gmail.com wrote: Dear Experts, Please help me in highting number which is greater than 2 by excel vba in red colour

Re: $$Excel-Macros$$ Need City in Blanck Coloume.

will provide top best solution not a temporary solution I totally agree with sunny... On Wed, May 8, 2013 at 11:26 AM, priti verma pritiverma1...@gmail.comwrote: Hi Sunnny , sometime its better to think very simple , we can use Index match as an array formula but if you have a large data you can

Re: $$Excel-Macros$$ Need City in Blanck Coloume.

:11 PM, priti verma pritiverma1...@gmail.comwrote: Thanks for your suggestion, i know what i need to do .. On Wed, May 8, 2013 at 5:05 PM, Sant Ram santram...@gmail.com wrote: Exactly Priti you are right but your formula is not working ... as i observe that you are just want increase your

Re: $$Excel-Macros$$ Need City in Blanck Coloume.

and one more thing best solutions with no acknowledgement whatsoever On Wed, May 8, 2013 at 5:46 PM, priti verma pritiverma1...@gmail.comwrote: Dear Sant Ram, You may note that in the original query there was nothing related to the sorting and I tried to apply a different and simple

Re: $$Excel-Macros$$ Change to numbers

You can use this one also =VALUE(SUBSTITUTE(E2,,,)) On Tue, May 7, 2013 at 1:25 PM, danial mansoor danial_...@hotmail.comwrote: dear Experts: Kindly look at my file,there are some numbers kindly convert this into numbers it is in text format. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

  1   2   >