$$Excel-Macros$$ Relay run automation

Hi All, I am a newbie to excel macro. Having little knowledge in vbscript. We are planning to arrange a relay run in our office. Ten different teams, each team will have 4 members. I want it to be automated by clicking some buttons instead of manual entry. Three functionalities involved in thi

$$Excel-Macros$$ Re: Only Excel formuala

=SUBSTITUTE(D9,"|","") Regards Prince On Tuesday, 26 August 2014 00:16:19 UTC+5:30, kamal ganeshan wrote: > > Hi Friends, > > Can anyone help me with the excel formula for the attached list of > question > > Regards, > Ganeshan > -- Are you

$$Excel-Macros$$ Re: How to Drag & get C,D,E,F post A,B...

Hi Amit, this is because there is not custome list exist in your excel application, if it is not their you can add same in you excel by just clicking on sort button in in order list box select custom list option and then add the list. Regards Prince On Friday, 9 May 2014 12:21:31 UTC+5:30

Re: $$Excel-Macros$$ Doubt in Duplicates

I think Ganesh reply is correct if you just want to show the duplicates. On Wednesday, 30 April 2014 11:33:55 UTC+5:30, Ganesh N wrote: > > HI Kannan, > > There is In-build option in excel to show the duplicates. Please find the > below steps. > > Home->conditional formatting->highlight cells rul

$$Excel-Macros$$ Re: Doubt in Duplicates

so do you want to remove duplicates ? On Wednesday, 30 April 2014 11:27:23 UTC+5:30, pappu wrote: > > Dear Friends, > > Please find the attached file of excel, I have a doubt in that excel. > > I checked the excel there is no formula and VBA coding but it is showing > duplicates. > > How to do

$$Excel-Macros$$ Re: Need an address split up formula.....

=MID($A4,1,SEARCH("Act",$A4,1)) in to C1 On Wednesday, 12 March 2014 16:45:55 UTC+5:30, Bullet wrote: > > Hi Experts, > > Is there any way out to split up an address as per the attached file > format! > > If so then please provide me the formula or vba code (anything). > > Thanks in advance. > >

$$Excel-Macros$$ Re: Need an address split up formula.....

Hi, Please Paste These formula =MID($A4,SEARCH("Act",$A4,1),3) in D1 And =MID($A4,SEARCH("Act",$A4,1)+4,4) in E1 Regards Prince On Wednesday, 12 March 2014 16:45:55 UTC+5:30, Bullet wrote: > > Hi Experts, > > Is there any way out to split up an address as

$$Excel-Macros$$ Re: Footer not required in last page

tr=20 then .CenterFooter = "Concluded" else .CenterFooter = "Continued" end if .RightFooter = "&P" End With next End Sub Regards Prince On Wednesday, 22 January 2014 07:34:45 UTC+5:30, Naresh Kumar Kolluru wrote: >

RE: $$Excel-Macros$$ Data from one column to another without blanks butstill in order?

Instead of sharing original share ur wprkbook with some dummy data -Original Message- From: "Tom Yaxley" Sent: 08-01-2014 06:48 PM To: "excel-macros@googlegroups.com" Subject: $$Excel-Macros$$ Data from one column to another without blanks butstill in order? Hi All Experts, I am l

$$Excel-Macros$$ Re: Delete File Contents

Pankaj i dont think it is possible without macro. You have to use macro to do this task. Regards Prince On Monday, 26 August 2013 09:30:57 UTC+5:30, Pankaj wrote: > > Dear Gurus, > > I want to create a excel file with Date limit. > > Like in a file there are some contents(Grap

$$Excel-Macros$$ Re: listbox issue

Hi Pawel, Pls shere your workbook. Regards Prince On Sunday, 25 August 2013 16:34:00 UTC+5:30, lupinskip wrote: > > Hi All, > > I have quite serious problem with the list box (ActiveX). when I use it on > the sheet where is placed is fine, but when I run any macro that

Re: $$Excel-Macros$$ Is there a way to insert images into a specific cell?

No Chaya i dont think there is any way to do this with hyperlinks. On Wednesday, August 21, 2013 12:33:39 PM UTC+5:30, Chaya Cooper wrote: > > Eugene, > > I need to display the images inline. Is there a way to do that with > hyperlinks? > > > On Wed, Aug 21, 2013 at 12:18 AM, Eugene Bernard > >

Re: $$Excel-Macros$$ payback Period Formula / Macro

et it back to it's default), eg iInt=0 2. Use the End statement in any Procedure. 3. Close the Workbook. regards Prince On Monday, July 8, 2013 12:45:36 PM UTC+5:30, Dominic Rassool wrote: > > Hi David, > > Im just getting to grips with VB; could you please let me know what Dim

$$Excel-Macros$$ Re: Finding text within data

Share some more data with an example. Regards Prince On Tuesday, July 9, 2013 12:13:08 AM UTC+5:30, ha...@mst.edu wrote: > > Hi All, > Basically, I want to find a text from specific category and return the > text/number to a specific cell. > For example, > API NUMBER: (ret

$$Excel-Macros$$ Re: Is it possible to hide the name manager menu?

Do you want to hide formulas in the cells ? if yes then just lock the cells and protact the sheet. Please Correct if i m wrong. regards Prince On Sunday, July 7, 2013 5:50:24 PM UTC+5:30, Aashish Watve wrote: > > Hi, > > I am working on a excel dashboard, where I have hidden man

$$Excel-Macros$$ Re: Need Access help

another way select t.name sum(t.count) From ( Write your first qry1 union Write your second qry2 ) as t *Group By t.name* Regards Prince On Friday, July 5, 2013 12:26:48 PM UTC+5:30, Prince wrote: > > > select t.name sum(t.count) > > From > ( > > Select * from q

$$Excel-Macros$$ Re: Need Access help

select t.name sum(t.count) From ( Select * from qry1 union select * from qry2 ) as t *Group By t.name* Regards Prince On Friday, July 5, 2013 12:25:30 PM UTC+5:30, Prince wrote: > > Just do this > > > select t.name sum(t.count) > > From > ( > > Select *

$$Excel-Macros$$ Re: Need Access help

Just do this select t.name sum(t.count) From ( Select * from qry1 union select * from qry2 ) as t Regards Prince On Friday, July 5, 2013 12:02:00 PM UTC+5:30, rk sharma wrote: > > Dear Experts > > > i have two queries in acess 2010 screen shot attached which have data

$$Excel-Macros$$ Re: Query in For Each Next

No , It Is not refering each cell in the * Range("A1:D5") *.For getting each cell you have to change the code like *Sub Upper_()* *For Each x In Range("A1:D5").cells* *x.Value = UCase(x.Value)* *Next* * * *Regards* *Prince* On Wednesday, 3 July 2013 10:41:21 UTC+

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

Hi Sandeep welcom on group. Regards Prince On Thursday, 27 June 2013 10:57:28 UTC+5:30, sandeep shivpujan singh wrote: > > Hi Everyone, > > I am Sandeep S Singh from India > Hyderabad. I am a Software Engineer > working with Cognizant. I have just now joined this group &

$$Excel-Macros$$ Re: Help Needed

But what u want to do with this data ? prince On Wednesday, June 5, 2013 6:50:19 PM UTC+5:30, Patil M G wrote: > > HI Team Excel Experts > > I am learning Excel and new to Macro coding. I want to create attached > INPUT FILE Format into Output Format...always INPUT FILE ha

$$Excel-Macros$$ Re: Want to add every third row or coloumn!

=SUMPRODUCT((IF(MOD(ROW($A$1:$A$11),*2*)=0,1,0)),($A$1:$A$11)) with CSE Just replace the bold number (2) with 3 or 4 and enjoy Regards Prince On Tuesday, June 4, 2013 9:51:49 AM UTC+5:30, sandeep chhajer wrote: > > Dear expert, > Many time I have to add every third or every forth

$$Excel-Macros$$ Re: Formula require

may be it can help you. =SUMPRODUCT(--(I9:I17="Black"),--(H9:H17="Cars"),(J9:J17)) Regards Prince On Tuesday, June 4, 2013 4:49:56 PM UTC+5:30, Prabhakar S H wrote: > > Hi Team, > > i want to get formula to find Total value of cars with black color only. >

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

we can do the same in another way with a simple approch just Insert a columns at A1 then Concatenate Column(Abcde) and apply this formula =INDEX($A$1:$AF$83,MATCH($Z$8&$AA$8&AD10&$AE$8,$A$1:$A$83,0),MATCH($AB$8,$A$1:$F$1,0)) Regards Prince On Thursday, May 30, 2013 1:03:11 PM UTC

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

Hi Deepak, Without using array formula you can try this one also. =SUMPRODUCT(--($F$4:$F$13=A4)*($G$4:$G$13<>"")) Just Paste the above formula in B4 Cell And Drag the Same. Regards Prince On Friday, May 31, 2013 12:59:10 PM UTC+5:30, Deepak Rawat wrote: > > Hi, > &g

$$Excel-Macros$$ Re: Filter based on coulmns

Share the sample file with datat On Monday, April 22, 2013 6:14:48 PM UTC+5:30, Amit Desai (MERU) wrote: > > Dear Friends, > > > > In general we filter data based on the contents in rows. I would like to > know if we have any options to filter data columns. > > > > Could you please help. >

$$Excel-Macros$$ Re: Same macro for multiple sheets

.Unprotect End If End With Next End Sub regards prince On Thursday, April 18, 2013 11:50:27 AM UTC+5:30, Pravin Gunjal wrote: > > Hello, > > How can I use the following macro for multiple sheets (this is placed in > Module) :- > > Public g_blnUpdate

$$Excel-Macros$$ Re: Turn paste into a paste special

No, Just use this ActiveCell.Copy Sheet1.Range("B1").PasteSpecial* xlPasteValues* * * *will paste only values* * * *regards* *prince* On Friday, April 12, 2013 6:02:35 PM UTC+5:30, alanth...@gmail.com wrote: > > I want a user to be able to paste text into a cell but not chan

$$Excel-Macros$$ Re: Help needed

=IF(LEFT(A1,1)="B",LEFT(A1,6),"") On Thursday, April 11, 2013 10:16:28 PM UTC+5:30, Kaushik wrote: > > Hi Team, > > I need a formula to find anything starting from 5 in a cell and to take 6 > digit right of the cell starting from 5 as below. > > Eg. > > DataDesired Result

$$Excel-Macros$$ Re: Identify occurances unique to after a date and not before

paste any date on which you want your data. then in F6, I wrote this formula. enter this formula with *ctrl+shift+enter* =TRANSPOSE(INDEX($A$1:$B$7,SMALL(IF($B$1:$B$7>=$G$2,(ROW($B$1:$B$7)-MIN(ROW($B$1:$B$7))+1),""),ROW(A1)),1)) regards Prince On Friday, April 12, 2013 5:25:1

$$Excel-Macros$$ Re: Sum on the basis of colour formula

Hi Modi, We cant recognize colours in formula so only solution for the same is macro regards Prince On Thursday, April 11, 2013 3:20:36 PM UTC+5:30, L.K.Modi wrote: > > Dear All > > > In the given sheet i want sum on the basis of colour , is there any > formula t

$$Excel-Macros$$ Re: UDF to pull data from Remote Server

Application.Calculate=xlCalculationManual *'Your code* Application.Calculate=xlCalculationAutomatic regards Prince On Monday, April 8, 2013 6:45:31 PM UTC+5:30, Divaker Pandey wrote: > > Hi Expert, > > > I made a UDF function that pull data form server on the basis given >

Re: $$Excel-Macros$$ Re: Extracting word and numbers

Hi Chaya, Just Replace This Line * varResData(intCtr, 2) = Replace(strNum, "", " ", 1, , vbTextCompare)* With *varResData(intCtr, 2) = Replace(strNum, "", "", 1, , vbTextCompare)* * * *Enjoy. * * * *Regards * Prince On Monday, April 8, 201

$$Excel-Macros$$ Re: Extracting word and numbers

quot; ", 1, , vbTextCompare) strString = vbNullString strNum = vbNullString Next .Range(strRange).Resize(UBound(varResData, 1), 2) = varResData End With End Sub Regards Prince On Monday, April 8, 2013 10:20:35 AM UTC+5:30, chaya moni wrote:

$$Excel-Macros$$ Re: Countif Formula Logic

No Diffrence Regards Prince On Saturday, April 6, 2013 1:46:33 PM UTC+5:30, amar takale wrote: > > Dear Experts > > what is Different between two formulas bcos from this formula I got same > answer.So what is logic of "="& > > =COUNTIF($F$3:$F$74

Re: $$Excel-Macros$$ Data type

Hi Manjunath You may refer this Link to get more clarity about this. http://www.rentron.com/datatypes.htm Regards Prince On Thursday, April 4, 2013 2:46:36 PM UTC+5:30, Manjunath Narayanappa wrote: > > Dear Expert, > > > > Am not able to understand when & where to

$$Excel-Macros$$ Re: How does the Mod operator work with dates

corresponding number and then only its result is evluated. *And in your case you can see the corresponding number of the date April 7 2003 is 37718 you nac see this just format the cell B3 as number.* Hope it will provide you more clear view about the Date. Regards Prince On Wednesday, April 3,

$$Excel-Macros$$ Re: Find out 6 digit Number

Hi Satheesh you can use Len function to know if the abc is a 6 digit Number. For Example: *len(Cstr(abc))* Regards Prince On Monday, April 1, 2013 5:12:36 PM UTC+5:30, Satheeshkumar Yadav wrote: > > Hi VBA Expert, > > Quiz Questions? can anyone answer this through VBA functions

$$Excel-Macros$$ Re: saving function to use in all workbooks

Hi Drik, By creating addins of that function u can use that function in your all workbook. Regards Prince On Thursday, March 28, 2013 3:53:51 PM UTC+5:30, Dirk Lahaye wrote: > > > > Hi, > How can i use a self created function in all my workbooks ? > Thanks for your ideas >

$$Excel-Macros$$ Re: IGNORE_BLANK_CELLS_AND_COMBINE_WITH_UNIQUE

Hi Friend, As i saw your data contain 0 in place of blank cell so i have modified my formula according that. So See the Attached. Regards Prince On Thursday, March 28, 2013 9:50:53 AM UTC+5:30, Sundarvelan wrote: > > Dear Freinds, > > Please help me to combine ignoring the

Re: $$Excel-Macros$$ Re: Sumproduct Formula -Min-Function-Error

sry for mistake PFA. On Thursday, March 28, 2013 9:20:47 PM UTC+5:30, Prince wrote: > > PFA > regards > Prince > > > On Thursday, March 28, 2013 11:18:17 AM UTC+5:30, prafull jadhav wrote: >> >> Dear Prince, >> >> find the same. >> >> Re

Re: $$Excel-Macros$$ Re: Sumproduct Formula -Min-Function-Error

PFA regards Prince On Thursday, March 28, 2013 11:18:17 AM UTC+5:30, prafull jadhav wrote: > > Dear Prince, > > find the same. > > Regards, > Prafull Jadhav. > > On Thu, Mar 28, 2013 at 9:19 AM, Prince > > wrote: > >> Share your workbook. >> &

$$Excel-Macros$$ Re: Wish you all a very happy holi

happy holi to all On Wednesday, March 27, 2013 9:30:38 AM UTC+5:30, ashish wrote: > > > > > > *Regards* > *Ashish Koul* > *Excel VBA > Tips

$$Excel-Macros$$ Re: use cell address in offset

PLEASE SHARE YOUR WORKBOOK On Wednesday, March 27, 2013 2:03:30 PM UTC+5:30, Sundarvelan wrote: > > > Dear Friends, > > Please help me in using the cell address in offset. > > > =IF((IF('TNCMCHIS_CALC-2'!$R8=1,'TNCMCHIS_CALC-2'!$A8,OFFSET('TNCMCHIS_CALC-2'!$R8,0,-17,1,1)))=$A6,OFFSET( > 'TNC

$$Excel-Macros$$ Re: Sumproduct Formula -Min-Function-Error

Share your workbook. Regards Prince On Wednesday, March 27, 2013 6:05:37 PM UTC+5:30, prafull jadhav wrote: > > Dear All, > > Sumproduct function return the Max function output but Not a Min fuction > Output . > > for example > > I got output when i use max fun

$$Excel-Macros$$ Re: Alternative formula

Hi Hilary, Can we do it through VBA as i tried to make this formula work fast but did not get success. So i think VBA would be the best option in case. regards prince On Wednesday, March 27, 2013 7:11:56 PM UTC+5:30, hilary lomotey wrote: > > Hello Experts, > > i am working with a

$$Excel-Macros$$ Re: Index / Match formula - Ignoring blank cells

please share your workbook or provide us some sample data. for ur reference please see the attached. On Wednesday, March 27, 2013 8:42:01 PM UTC+5:30, srsev6 wrote: > > I have the following formula that would be working perfectly if it ignored > blank cells. > > The formula I am using is:

$$Excel-Macros$$ Re: Need help using Modules in Excel 2007

Just try to replace your function with following. public Function Sigmoid(t) as double Sigmoid=1/(1+exp(-t)) End Function regards prince On Thursday, March 28, 2013 4:37:23 AM UTC+5:30, gka...@gkading.com wrote: > > > On Wednesday, March 27, 2013 9:30:05 AM UTC-6, gka...@gkading.

$$Excel-Macros$$ Re: Small Help Friends....

Hi Anil, Just paste the following formula in Cell J8 and Drag it out. =INDEX(C6:$F$20,MATCH(SMALL(F6:$F$20,(ROW($F$6:$F$20)-MIN(ROW($F$6:$F$20))+1)),$F$6:$F$20,0),3) with CSE Regards Prince On Tuesday, March 26, 2013 4:27:59 PM UTC+5:30, अनिल नारायण गवली wrote: > > Dear F

$$Excel-Macros$$ Re: Source Link updation error

Hi Pravin, Just Click on Edit Link spot the start up option and then select the first option dont display and update the link. Enjoy. regards Prince On Tuesday, March 26, 2013 10:34:50 AM UTC+5:30, Pravin Gunjal wrote: > > Hi, > > I am getting the following error message, whil

$$Excel-Macros$$ Re: Replace a character to equal sign - VBA

Just Create a macro and passed your range, each cells with loop where i have used ActiveCell.value Replace(ActiveCell.Value,"#","=",1,,vbTextCompare) Regards Prince On Friday, March 15, 2013 12:49:03 AM UTC+5:30, André D'Avila wrote: > > Guys, please hel

$$Excel-Macros$$ Re: Find Distance and Time between two cities using Google Map In excel

Alt+F11 regards PRINCE On Thursday, March 14, 2013 4:18:32 PM UTC+5:30, sagaraher wrote: > > Can you pl tel me how to run it, as I cant see option available in view-> > Macro > > On Saturday, February 25, 2012 6:31:12 PM UTC+5:30, ashish wrote: >> >> Hi Group &

$$Excel-Macros$$ Re: Required Macro for unique no

Hi Shiva Why dont you use remove Duplicate option of excel itself. regards prince On Thursday, March 14, 2013 4:47:13 PM UTC+5:30, shivapr...@gmail.com wrote: > > > Dear champs, > > please find the attchement of test sheet any one provide macro for unique > no.

$$Excel-Macros$$ Re: Auto-populate a single cell by merging common values from cells within a range.

hi Friend, just use this formula in C7 =SUMIFS(C1:C5,$A$1:$A$5,A6,$B$1:$B$5,B6) make sure that your A7 and B7 must have values used in critreria. Regards Prince On Wednesday, March 13, 2013 7:07:02 PM UTC+5:30, cca...@gmail.com wrote: > > > I'm trying to create an employee exp

$$Excel-Macros$$ Re: Data Validation to force users to enter a particular date format

Hi Hilary. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$B$3" Then MsgBox "Please Enter date In dd-mmm-yy Format" End If End Sub Just Paste the following Code and modify the same according to your Requirment. Regard

$$Excel-Macros$$ Re: If Fucntion

Just Press ctrl+~ "~" this is a tiled sign right below to Esc Key Regards Prince On Wednesday, March 13, 2013 3:27:03 PM UTC+5:30, Prabhakar S H wrote: > > Dear team, > > pls help me to fix formula in attached file. > > Rgds, > Prabhakar > -- Are yo

Re: $$Excel-Macros$$ Excel VBA to retrieve from MSAccess or Sharepoint

Hi Paul, I think the solutions given by Sam and Me are correct for your question and fulfil your requirments. So please reply wat is wrong with our solution for not use. Regards Prince On Thursday, March 7, 2013 6:09:14 PM UTC+5:30, Paul Schreiner wrote: > > Thanks David, > >

$$Excel-Macros$$ Re: Scope of variables

explaination you can go through the following link this link will guid you how can you access the public variable. http://support.microsoft.com/kb/141693 Regards Prince On Friday, March 8, 2013 5:07:19 AM UTC+5:30, David Grugeon wrote: > > Hi all > > I am using excel 14 (Part o

$$Excel-Macros$$ Re: Most helpful member award stopped.

Hi Ayush. I think it is a good initiative that will help us to recognize the person who put their quality of time in delivering the answer with the quality. Regards Prince On Thursday, March 7, 2013 9:24:58 PM UTC+5:30, Ayush Jain wrote: > > Dear members, > > Thanks for

Re: $$Excel-Macros$$ Disable saveas option

Hi Manjunath, We can not disable the save option of any excel file without using VBA, But in case of VBA Just Write the below metioned Code Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Cancel = True End Sub Regards Prince On Tuesday, March 5, 2013 11:53

$$Excel-Macros$$ Re: Need to Subtract Two Date/Time Cells - Formula Issue

Just Trim the date value in Column H Regards Prince On Tuesday, March 5, 2013 10:24:03 PM UTC+5:30, JohnA wrote: > > I have a download into Excel with start and stop cells which contain the > date/time. I need help making my formula work please to get the NET > minutes. >

Re: $$Excel-Macros$$ shuffle cell value in excel

Yes it can be done but by using VBA Only. regards prince On Tuesday, March 5, 2013 10:45:03 PM UTC+5:30, XLS S wrote: > > yes.. > > . > > Enjoy > Team XLS > > > > On Tue, Mar 5, 2013 at 10:42 PM, rajan verma > > > w

$$Excel-Macros$$ Re: CLEAR CONTENTS of cells with value 0

By using VBA : Sheet1.range("$A1$AZ1048576").clearcontents. regards prince On Tuesday, March 5, 2013 9:48:11 PM UTC+5:30, Somnath Khadilkar wrote: > > Dear Sir, >I have ANY excel sheet ,some cells have value ZERO [ numeric 0 ]. I > would like to BLANK or DELETE

Re: $$Excel-Macros$$ Re: Formula need !

=IF(IF(ISERROR(C2/A2),"",(C2/A2))>=1,"100%","") Regards Prince On Tuesday, 5 March 2013 16:31:37 UTC+5:30, Shaikh Iqbal wrote: > > Prince > > If Column *C* Prod (On+Off Rte) > CallPlan then output in column D only > 100% not goes to 126% >

Re: $$Excel-Macros$$Extract information

So how calculation on sheet2 has done please explain. With an example. Regards Prince On Tuesday, 5 March 2013 16:25:15 UTC+5:30, Manjunath Narayanappa wrote: > > Hi Prince, > > > > We update on daily basis on sheet1, for Monday to Friday of each > individuals > &

$$Excel-Macros$$ Re: doubt in connecting to the other workbook sheet through the userform

Share your workbook and some sample data. Regards Prince On Tuesday, 5 March 2013 15:53:51 UTC+5:30, Bheema Shankar wrote: > > Dear friends > > I placed my data in worksheet1 of workbook1 pertaining to the employees > of an organisation by giving a unique ID no.in Column A.

$$Excel-Macros$$ Re: Formula need !

if i m right you may be expecting this : =IF(IF(ISERROR(ROUND(C2/A2%,2)),0,(ROUND(C2/A2%,2)))=100%,IF(ISERROR(ROUND(C2/A2%,2)),0,(ROUND(C2/A2%,2))),"") in D2 and drag regards prince On Tuesday, 5 March 2013 16:01:30 UTC+5:30, Shaikh Iqbal wrote: > > Dear Export, > > P

Re: $$Excel-Macros$$Extract information

Hi Manjunath, Do you want to get the same information to be pasted on the sheet2 with same information as it is on sheet1 or somthing else is required. Please explain bit more. Regards Prince On Tuesday, 5 March 2013 14:19:02 UTC+5:30, Manjunath Narayanappa wrote: > > Dear E

$$Excel-Macros$$ Re: Excel VBA to retrieve from MSAccess or Sharepoint

Str = vbNullString Exit Sub ErrHandle: MsgBox "Check if the Database and Table is existing or not in the Path---" & Chr(10) & " " & strDbPath End Sub your access Data base name Could like this: db1.mdb Regards Prince On Monday, March 4, 2013 11:50:

Re: $$Excel-Macros$$ Data Validation

one more point i want to add in Rajan's Explaination is that data validation Keep your data consistent so that it can hold its actual meaning. Lets suppose age of person Can not be a text value it should always be in Numeric value so that we can perform any calculation on it. Regards P

$$Excel-Macros$$ Re: Need minium date

=MIN(A2:A5) and change the format of cell as --- d/m/ as you required Regards Prince On Monday, March 4, 2013 5:20:16 PM UTC+5:30, Manoj Kumar wrote: > > Dear Expert. > > > Please help to find minium date in attached file.. > > A1 has date and B2 has name but I need

$$Excel-Macros$$ Re: Macro Help

ol & .Cells(1, intCol).Address & ":" & Left(.Cells(1, intCol).Address, Len(.Cells(1, intCol).Address) - 1) & intRow strCol = strCol & "," End If Next strCol = Left(strCol, Len(strCol) - 1) .Range(strCol).

$$Excel-Macros$$ Re: Extract Data from single cell

TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=True, _ Semicolon:=True, Comma:=True, Space:=True, Other:=True, OtherChar:="""" End With End Sub Note : But make sure that it would work only on one columns data as it is a text to columns functionality

$$Excel-Macros$$ Re: Rats can establish Brain-to-Brain interface connections

Why all these stuff are here. I think this is not the best place to spread these information. This place is only for VBA and Excel. So Plz Follow the Forum Rules else Go away. On Sunday, March 3, 2013 1:35:11 AM UTC+5:30, Zee Wow wrote: > > Rats Invasion confirmed, The world's first Brain-to-B

Re: $$Excel-Macros$$ xlfn

Unfortunately in VBA the True/False results are not coerced into values like they are on a worksheet, and a type mismatch occurs. regards Prince On Sun, Mar 3, 2013 at 9:31 PM, Airen wrote: > Hello Everyone, > > I Received one excel file, in which I am seeing formulas starting with

$$Excel-Macros$$ Re: Assignment

rn = "(\d+)" End With Set REMatches = objRge.Execute(strData) GetNumberS = REMatches(0) End Function Regards Prince On Saturday, February 23, 2013 11:44:01 AM UTC+5:30, Harkesh Kumar wrote: > > > > > Please solve this Problem > > >

$$Excel-Macros$$ Re: max if and min if

Please provide sum sample data and the condition that you want to impose on that. Regards Prince On Friday, March 1, 2013 1:11:23 AM UTC+5:30, santosh wrote: > > Hello Group, > > Need a small help on how to calculate the max with two or more conditions. > > -- > Regards &g

$$Excel-Macros$$ Re: Need formula for sum

HI, May be It Can help You. =SUMIF(D2:AB2,AC2,D3:AB3) regards Prince On Wednesday, February 27, 2013 5:27:38 PM UTC+5:30, Deepak Rawat wrote: > > Hi, > > need formula for sum in attach > > Regards, > Deepak > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y

$$Excel-Macros$$ Re: Need formula for sum

Hi On which column you want sum ? Regards Prince On Wednesday, February 27, 2013 5:27:38 PM UTC+5:30, Deepak Rawat wrote: > > Hi, > > need formula for sum in attach > > Regards, > Deepak > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?

Re: $$Excel-Macros$$ VBA or Formula Solution ( tough work)

Cool Solution Rajan Regards Prince On Monday, February 18, 2013 1:15:48 PM UTC+5:30, Rajan_Verma wrote: > > *Hi Deepak* > > *See the attached Example,* > > * * > > *There are 4 set of data , I give name them like data 1 , data2 ,data3 > and data4 , then I insert

$$Excel-Macros$$ Re: formula required

Hi Ganesh, PFA. Regards Prince On Sunday, February 10, 2013 8:50:17 AM UTC+5:30, GANESH wrote: > > Hi I want the J8 show me the total of rim of which I highilighted in > Green color all the user in Column E > Column B has user Name Column c has the total of amount >

$$Excel-Macros$$ Re: VBA Code for Home tab

Hi Amar PFA. Note: Just remove all hyper links from the shapes and assign the name to all shapes as i have provided on sheet2. Use same names to other shapes on other sheets too. And assign the same macro to all the shapes on other sheet. Regards Prince On Saturday, February 9, 2013 1:00

$$Excel-Macros$$ Re: coaching instutes for MS access 2007 in Gurgaon,Haryana

Hi Santosh, instead of trying for institutes i think u should try to get IGNOU's BCA programs Data Base Management System book this will provide every think with practical example of Access what ever you want to learn in Access Regards Prince On Saturday, February 9, 2013 3:30:30 AM UTC

$$Excel-Macros$$ Re: Prince Kumar - Most Helpful Member Jan'13

Thanks to every one for their wishes. (: Regards Prince On Saturday, February 2, 2013 11:49:07 AM UTC+5:30, Ayush Jain wrote: > > > Dear members, > > Prince Kumar has been selected as 'Most Helpful Member' for the month of > Jan'13. He has posted 103 posts la

$$Excel-Macros$$ Re: Unhide some sheets starting from a specific sheet number

Hi Hilary, Please See the attachment. Regards prince On Sunday, February 3, 2013 3:28:11 PM UTC+5:30, hilary lomotey wrote: > > Hello experts > > Assuimg I have 10 sheets in a workbook. And I want to unhide the 7th sheet > up to the last sheet Kindly help with vba code

Re: $$Excel-Macros$$ How to order data in rows into distinct column sets

Hi Aplesh PFA Regards Prince On Thursday, January 31, 2013 6:50:02 PM UTC+5:30, pesh wrote: > > Dear Anil, > > Thank you for your response. However, I have not received the file you > refer to. Only I see the sample file I had submitted originally. > Could you please res

$$Excel-Macros$$ Re: How to order data in rows into distinct column sets

paste the data. 3: Here i m considering Data strat from range A1 so you also needs to change this from the cell where your data starts. Regards Prince On Thursday, January 31, 2013 3:12:28 AM UTC+5:30, pesh wrote: > > Dear Excel Masters, > > I have raw data that is in the follo

$$Excel-Macros$$ Re: Macro require

Hi Amir, hope this can be help full for you. Sub test() Dim wks As Worksheet Dim introw As Integer introw = 1 For Each wks In ThisWorkbook.Worksheets Sheet1.Cells(introw, 1).Value = wks.Name introw = introw + 1 Next End Sub regards Prince On Wednesday

$$Excel-Macros$$ Re: .Net - Dot Net

Join some best forums for this On Wednesday, January 30, 2013 1:22:47 PM UTC+5:30, prashant shinde wrote: > > Hi friends, > > i dont know ANYTHING about .net. and now want to learn it does anybody > know how shud i start with it. > Any site or ebook for beginners. > > i am sorry this is off the

$$Excel-Macros$$ Re: Create Links to All sheet Starting from a particular sheet

"'" & .Sheets(intCtr).Name & "'" & "!A1", TextToDisplay:=Sheets(intCtr).Name i = i + 1 Next End With End Sub Regards Prince On Tuesday, January 29, 2013 6:44:16 PM UTC+5:30, hilary lomotey wrote: > > Sub Crea

$$Excel-Macros$$ Re: Two-to-multi column sorting

Hi Chirs, I dont think it is possible to from excel only we need to have a macro for this regards prince On Friday, January 25, 2013 12:56:26 AM UTC+5:30, Chris wrote: > > Hey there - > > a very simple problem that I'm trying to solve without any code if at all > poss

Re: $$Excel-Macros$$ Macro to send data from one master sheet to multiple sheets

Hi Vignesh Have you seen the solution i have given to you. regards prince On Friday, January 25, 2013 6:28:53 PM UTC+5:30, Vignesh S R wrote: > > Any updates friends??? > > > On Sat, Jan 12, 2013 at 11:24 PM, Vignesh S R > > > wrote: > >>

$$Excel-Macros$$ Re: Cell Referencing

Hi Khalid, This will alwsy gives you absolute address as i placed this formula In H24 and I got $H$23 which is an absolute address Regards Prince On Friday, January 25, 2013 5:26:13 PM UTC+5:30, Sadia Khalid wrote: > > SALAM > Hi Every one Hope that all of you are fine. > >

$$Excel-Macros$$ Re: Save excel with date

Hi Suresh, Just Contaenate the Format(Now,"dd-mmm-yy") in the save as statment for Example : wbk.SaveAs ThisWorkbook.Path & "\ Prince" & Format(DateTime.Now, "dd-mmm-yy") & ".xlsx", 51 Regards Prince On Friday, January 25, 2013 5:44:59

$$Excel-Macros$$ Re: Formula to Replace 2nd List with Master List

Hi Dear just use this =VLOOKUP(A3,MASTER!$A$3:$B$9,2,0) regards prince On Thursday, January 24, 2013 5:30:51 PM UTC+5:30, hilary lomotey wrote: > > Hello Experts, > > In the file attached, i have a master list with names and codes(master > sheet), and then another list (list sh

$$Excel-Macros$$ Re: VBA Code -Slide Show

Hi Hilary, Do you want whatever pictures are there on your excel sheet must be converted into PPT for slid show or anything else please help me to understand the problem. Regards Prince On Wednesday, January 23, 2013 7:54:42 PM UTC+5:30, hilary lomotey wrote: > > Hello Experts, >

Re: $$Excel-Macros$$ Fwd: Excel Spellcheck Help.

will contain all the data which do not exists in excel dictionary. Hope it will help you Regards Prince On Tuesday, January 22, 2013 5:42:28 PM UTC+5:30, saravanan R wrote: > > Hi Frnds, > > Any Idea for the given below Reuqest? > > > *Thanks & Regards,* > &g

Re: FW: $$Excel-Macros$$ need formula Highlight

Hi Manjunath, Please see this if this can help you. http://www.free-training-tutorial.com/conditional-formatting.html Regards Prince Manjunath On Tuesday, January 22, 2013 4:54:11 PM UTC+5:30, Manjunath Narayanappa wrote: > > Thank you very much. I was not knowing abt condi

$$Excel-Macros$$ Re: Dúvida Tabela Dinâmica

Hi Tanato C, Yes. It can be done just select your pivot table right click on it and refresh the same. Regards Prince On Monday, January 21, 2013 6:38:26 PM UTC+5:30, Tanato C. wrote: > > Good Morning > > In a PivotTable it is possible that the update of the "Data Label"?

$$Excel-Macros$$ Re: VBA Solution Requried

Hi Amar, Share your workbook with an example. regards prince On Monday, January 21, 2013 7:00:58 PM UTC+5:30, amar takale wrote: > > Hi All Experts, > All of you request of my solution,Can we sort data > Alphabetically,sector wise,price wise.IF I have 100 companies then I >

  1   2   3   4   5   >