Re: $$Excel-Macros$$ EXCELLENT MIND READING

Excellent Regards, Lalit Mohan On Sat, Sep 1, 2012 at 7:22 PM, Kuldeep Singh wrote: > > Woh!! > > Regards, > Kuldeep Singh > > > On Sat, Sep 1, 2012 at 10:48 PM, Rajan_Verma wrote: > >> * * >> >> *Ok* >> >> * I was choosing wrong color **J*** >> >> * * >> >> * * >> >> *Regards* >> >> *Rajan ver

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

Congrats Mr. expert Regards, Lalit Mohan On Sun, Sep 2, 2012 at 7:58 AM, vijayajith VA wrote: > Congrats noorain Brother.. > > > On Sun, Sep 2, 2012 at 11:22 AM, rao wrote: > >> Congrats, u are the live wire of this group.please do continue the same. >> >> Cheers, >> Prabhakar

Re: $$Excel-Macros$$ Need update on the attached Macro

Just use this line of code before calling sendmail procedure If Target.Column <> Range("N1").Column Then Exit Sub Hope it helps you Regards, Lalit Mohan On Fri, Aug 31, 2012 at 5:50 PM, Selva wrote: > Hi All, > > ** ** > > Need an update on the attached macro file. Based on this file, w

Re: $$Excel-Macros$$ Hook Chart

Nice one Regards, Lalit Mohan On Thu, Aug 23, 2012 at 7:29 PM, Mangesh Vimay wrote: > Nice !!! > > > On Thu, Aug 23, 2012 at 10:12 AM, अनिल नारायण गवली < > gawlianil8...@gmail.com> wrote: > >> Gr8 work rajan .:) >> >> Regards, >> Gawli Anil >> >> On Wed, Aug 22, 2012 at 9:34 PM, Hilary Lomo

Re: $$Excel-Macros$$ All the sheet names in one sheet

Dear Santosh, I think it is not possible to get all the sheets name by using only formula. Regards, Lalit Mohan On Mon, Jul 16, 2012 at 3:21 PM, NOORAIN ANSARI wrote: > Dear Santosh, > > Please create a name range with below formula.. > > =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),""

Re: $$Excel-Macros$$ Vlookup Problem

Hi Mangesh, If you want to learn how vlookup works may be below links helps you.. http://www.free-training-tutorial.com/function-vlookup.html http://spreadsheets.about.com/od/excelfunctions/ss/90320vlookup.htm Regards, Lalit Mohan On Mon, Jul 16, 2012 at 5:27 PM, Mangesh Vimay wrote: > Its r

Re: $$Excel-Macros$$ VBA to copy the entire data without the button in the sheet

Hi Give this also a try. sheet2.resize(sheet1.usedrange.rows.count, sheet1.usedrange.columns.count).value = sheet1.usedrange.value Regards, Lalit Mohan On Sat, Jul 14, 2012 at 1:12 AM, dguillett1 wrote: > and then > activesheet.shapes.cut > > Don Guillett > Microsoft Excel Developer > SalesAi

Re: $$Excel-Macros$$ Re: Error Cleaning

Hi, Please attach file with sample data to make it more clear. Regards, Lalit Mohan On Sat, Jul 14, 2012 at 3:11 AM, bpascal123 wrote: > Hi, > > You say: > > I need your help again.We extract the data from database & each user got >> some errors on different projects.I need to clean the error

Re: $$Excel-Macros$$ Error--Cant Exit Design Mode

Hi, Can u provide the file to make it more clear. Regards, Lalit Mohan On Sat, Jul 14, 2012 at 1:36 AM, hanumant shinde wrote: > Hi friends. > > there is huge macro file which throws an error as "Cant exit design Mode" > for few users at few occasions. > we don't know when and why this error c

Re: $$Excel-Macros$$ File opens read only on same excel instance

Hello, There could be 1 of 3 things affecting this: 1. Is another application using that excel document? If so you will not be able to edit it until the other application stops using it. 2. Is the file currently in a location that you do not have write permissions? eg. another users shared docum

Re: $$Excel-Macros$$ Query- Global Variable

Dear If you want a variabler such that it will works for all the procedure in a module use below. dim sh as worksheet dim rng as range Private sub abc() set sh = Thisworkbook.Sheets("Sheet1") set rng = sh.range("a1:c"&sh.range("c"&rows.count).end(xlup).row) End sub or else If you want it ac

Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June​'12)

Congrats Rajan this is the third time continuously. congratulation once again Regards, Lalit Mohan On Thu, Jul 5, 2012 at 6:18 PM, Rajan_Verma wrote: > Thank you all.. J > > > > > > Regards > > Rajan verma > > +91 7838100659 [IM-Gtalk] > > > > From: excel-macros@googlegroups.com [mailto:excel-m

Re: $$Excel-Macros$$ Macro timings should be multiple based on date changing

Hi Lokesh, Please find the attached hope it meets your specification Regards, Lalit Mohan On Sat, Jun 30, 2012 at 7:32 AM, Lokesh Loki wrote: > Hi Lalit, > > Thanks for replying to my query. > > Actually i needed when i am changing the dates the macro timings i.e. > 4:00:00 should be multiplie

Re: $$Excel-Macros$$ IN TROUBLE

Hi Azhar, Try this revised version... Sub InsertColumnWithFormula() Const lngNoOfColAs Long = 2 Dim varSheets() As Variant Dim lngLoop As Long Const strStartRange As String = "R1" varSheets = Array("Sheet1", "Sh

Re: $$Excel-Macros$$ merge 3 cell values 1 cell

Hi, Try this also =A1&" "&B1&" "&C1 Regards, Lalit Mohan On Fri, Jun 29, 2012 at 11:29 PM, NOORAIN ANSARI wrote: > Dear Moti Lal, > > You can use below UDF for dynamically > > Function combine_cells(rng As Excel.Range) As String > Dim cell As Excel.Range > For Each cell In rng.Cells > combine

Re: $$Excel-Macros$$ Help in Access

Hi Manoj, Try this select [store id] from [Acer All Data] group by [store id] select [store id] from [Apr'12] group by [store id] select [store id] from [Mar'12] group by [store id] select [store id] from [May'12] group by [store id] Regards, Lalit Mohan On Fri, Jun 29, 2012 at 3:14 PM, Manoj

Re: $$Excel-Macros$$ Re: Delete Blank Cells.xlsx

Hi Prince, Sorry for asking but could you please explain the deference in both of your solution. Regards, Lalit Mohan On Wed, Jun 27, 2012 at 8:32 AM, Prince Dubey wrote: > Hi Vishwa, > > > Try This > > > > Public Sub DeleteWeekends() >     Dim rng As Range >     Dim rngData As Ran

Re: $$Excel-Macros$$ Label record sheet

HI, Can you please explain it more actually the requirement is not clear. Regards, Lalit Mohan On Wed, Jun 27, 2012 at 1:33 PM, wrote: > Dear all experts > > > > I’ve some questions about functions on the sheet, I made the sheet, So it > use for record the label for production > > > > I tried

Re: $$Excel-Macros$$ VBA editor auto-deletes spaces at the ends of lines

t; lines > > Hi Rajan, > > I also want to learn how to build and use VSTO so if u found something   > related to this please let me know. > > Regards, > Lalit Mohan > > > On Tue, Jun 26, 2012 at 8:29 PM, ╰» ℓαℓιт мσαнη > wrote: >> Hi Rajan, >> &

Re: $$Excel-Macros$$ VBA editor auto-deletes spaces at the ends of lines

Hi Rajan, I also want to learn how to build and use VSTO so if u found something related to this please let me know. Regards, Lalit Mohan On Tue, Jun 26, 2012 at 8:29 PM, ╰» ℓαℓιт мσαнη wrote: > Hi Rajan, > > Actually i faced this issue while doing vba programming. These are > j

Re: $$Excel-Macros$$ VBA editor auto-deletes spaces at the ends of lines

Hi Rajan, Actually i faced this issue while doing vba programming. These are just steps to resolve the same. Regards, Lalit Mohan On Tue, Jun 26, 2012 at 8:24 PM, Rajan_Verma wrote: > Lalit Can you give the example .? I have vsto on my system, > > > > > > Regards > > Rajan verma > > +91 783810

Re: $$Excel-Macros$$ MY NEW EXCEL DASHBOARD PROJECTS

Nice work Hilary.. Regards, Lalit Mohan On Tue, Jun 26, 2012 at 7:17 PM, Rajan_Verma wrote: > Hi deba.. > > Actually the "BLPLinkReset" is a macro which was called at the time of > Recording this macro. > > > > Hi Hilary.. > > > > You can put the  code of "BLPLinkReset" in your dashboard. So tha

Re: $$Excel-Macros$$ Problem with excel

Hi Divaker, You query is not cleary mentioned can u please share a file with the full description so that we can help u as soon as possible Regards, Lalit Mohan On Tue, Jun 26, 2012 at 6:35 PM, Divaker Pandey wrote: > Hi Experts, > > Still waiting for your response. > > Divaker > > > On Tue, J

Re: $$Excel-Macros$$ Re: delete blank columns

You can try this also on error resume next activesheet.specialcells(xlcelltypeblank).usedrange.entirecolumn.delete on error goto 0: on error goto -1: err.clear Regards, Lalit Mohan On Tue, Jun 26, 2012 at 7:09 PM, Rajan_Verma wrote: > Try this > > Sub delete_blankcolumn() > Dim col a range >

Re: $$Excel-Macros$$ Join Sql statement in VB using ADODB

Try this Sub Get_Vessel_Schedule() Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim strSql As String Set cn = New ADODB.Connection Set rs = New ADODB.Recordset cn.Open ( _ "User ID=User" & _ ";Password=Pass" & _ ";Data Source=My DB" & _

Re: $$Excel-Macros$$ Dynamic List range for Data validation

Give a try to this link.. http://www.excelfox.com/forum/f12/dependent-data-validation-using-only-formulas-111/ Regards, Lalit Mohan https://www.facebook.com/buzinesstransformation On Thu, May 17, 2012 at 11:07 AM, Seraj Alam wrote: > Hi, > > U can use this formula in data validation for dynami

Re: $$Excel-Macros$$ Re: Charts

Give a try to this link http://www.mrexcel.com/archive/Chart/index.html Regards, Lalit Mohan https://www.facebook.com/buzinesstransformation On Wed, May 16, 2012 at 6:28 PM, dguillett1 wrote: > http://office.microsoft.com/en-us/excel-help/add-data-labels-to-a-chart-HP005198471.aspx#BMposition

Re: $$Excel-Macros$$ Time Difference

Dear Mangesh PFA Regards, Lalit Mohan https://www.facebook.com/buzinesstransformation On Wed, May 16, 2012 at 6:48 PM, Mangesh Dayne wrote: > Hi, > > Thanks for your great help. > In vba code, > Range("C11").Value = Range("C10") + 0.2916667 > why did you have taken  0.2916667 

Re: $$Excel-Macros$$ IF Function

Dear Smitha, You can try this accordingly If condition1 = true and condition2 = true and condition3 = true then 'Your code here else 'Your code here end if Regards, Lalit Mohan https://www.facebook.com/buzinesstransformation On Wed, May 16, 2012 at 4:44 PM, Nare

Re: $$Excel-Macros$$ Re: help required for creating a formula

Dear Ashish PFA Regards, Lalit Mohan https://www.facebook.com/buzinesstransformation On Wed, May 16, 2012 at 3:27 PM, CoRe wrote: > Hello, > > PFA! > > > > On Wednesday, May 16, 2012 12:48:35 PM UTC+3, ashish damor wrote: >> >> Dear All, >> >> I have a list of industry in one column and in cor

Re: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

Dear Indrajit range("A1").value = WorksheetFunction.VlOOKUP(lookup_value, table_array, col_index_num, [range_lookup) Regards, Lalit Mohan https://www.facebook.com/buzinesstransformation On Mon, May 14, 2012 at 7:54 PM, ╰» ℓαℓιт мσαнη wrote: > Dear  Indrajit > >

Re: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

Dear Indrajit range("A1").value = WorksheetFunction.=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup) same for the other formula Regards, Lalit Mohan https://www.facebook.com/buzinesstransformation On Mon, May 14, 2012 at 7:15 PM, Indrajit $nai wrote: > Thanks for the sugge

Re: $$Excel-Macros$$ amend in macro

Dear Aamir You can use this also.. Sub Sheet1Multiplecopy() Dim noOfSheet As Long Dim strTEmp As String Dim lngLoop As Long On Error Resume Next strTEmp = InputBox("Enter no of Sheets:-", "Sheet Number") On Error GoTo 0:

Re: $$Excel-Macros$$ Attendance tracking

haiah wrote: > Hi Lalit > > There is some bug in resigned sheet where employee code doesn't match some > times in tracker sheet, > > can u pls check and resolve > > > -- Forwarded message -- > From: ╰» ℓαℓιт мσαнη > Date: Sun, May 6, 20

Re: $$Excel-Macros$$ query

Hi Aamir, You can use SUBTOTAL formula accordingly. for ex.: Sum of visible cells :- =SUBTOTAL("A1:A100",109) Regards, Lalit Mohan https://www.facebook.com/buzinesstransformation On Sat, May 12, 2012 at 8:39 PM, Aamir Shahzad wrote: > Dear Group, > > > > How to pick the values by formula

Re: $$Excel-Macros$$ Running text in excel

Hi PFA Regards, Lalit Mohan https://www.facebook.com/buzinesstransformation On Sat, May 12, 2012 at 6:57 PM, Lokesh Loki wrote: > Hi Experts. > > I am waiting for your reply. > > Regards > Lokesh > > > On Fri, May 11, 2012 at 9:28 PM, Lokesh Loki > wrote: >> >> Hi Rajan, >> >> Yes you have se

Re: $$Excel-Macros$$ Name Manager

Hi, By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names. Regards, Lalit Mohan ht

Re: $$Excel-Macros$$ match 2 columns

Dear Sara, PFA *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation* On Sun, May 6, 2012 at 11:35 PM, Sara Lee wrote: > hi > i would like to have wgt column in sheet 1 updated based on whenever > there is a match on ozip

Re: $$Excel-Macros$$ Need macro website

Dear karthik you can also learn VBA by your self and for this you just need to record macro for anything you do. *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation* On Sun, May 6, 2012 at 7:07 PM, Prajakt Pande wrote: >

Re: $$Excel-Macros$$ Re: Help me to generate Report

Hi Ankit, Please attach file for the reference. *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation* On Fri, May 4, 2012 at 4:10 PM, CoRe wrote: > More infos , less gibberish please. > > On Friday, May 4, 2012 11:30:18 A

Re: $$Excel-Macros$$ Help Required to update off days in a tracker

i have made some changes in Noorain's code :) [?] PFA *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation* On Fri, May 4, 2012 at 11:16 PM, Seema wrote: > hi, > > thank you for the effort. but the sheet is not getting upd

Re: $$Excel-Macros$$ Chart-Secondary Axis option

Try these link also www.nios.ac.in/basiccomp/l12.pdf http://mac2.microsoft.com/help/office/14/en-us/excel/item/301ec775-d4b3-452d-85af-55df53ff6db8 *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation* On Fri, May 4, 2012 a

Re: $$Excel-Macros$$ Rounding value of six digit

Or you can use this =INT(ROUND(A1/1000,3))*1000 *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation*<https://www.facebook.com/buzinesstransformation> On Fri, May 4, 2012 at 10:11 PM, ╰» ℓαℓιт мσαнη wrote: > Hi > > please explain because the rounding of a

Re: $$Excel-Macros$$ Rounding value of six digit

Hi please explain because the rounding of a number is based on some rules. *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation* On Fri, May 4, 2012 at 8:48 PM, Shekhar Sharma wrote: > Hi Experts, > > Kindly help me with

Re: $$Excel-Macros$$ Chart-Secondary Axis option

Hi, Another solution Try these links http://office.microsoft.com/en-us/excel-help/add-or-remove-a-secondary-axis-in-a-chart-HP001234165.aspx http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation*

Re: $$Excel-Macros$$ Require VBA examples and notes on VBA 2007

Hi, You can also try these links http://www.excel-vba-easy.com/ http://www.youtube.com/watch?v=wH03Xnr3Pug http://www.vbtutor.net/vb.html *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation* On Fri, May 4, 2012 at 8:52

Re: $$Excel-Macros$$ Need macro to verify part numbers between 2 sheets

Hi PFA *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation* On Fri, May 4, 2012 at 12:52 AM, Tony Wu wrote: > Hello, > > I have 2 sheets in one file, one sheet "A" has less part numbers than the > other sheet "B", would

Re: $$Excel-Macros$$ VB.net notes and examples programs, source code required

Try these links http://www.homeandlearn.co.uk/net/vbnet.html http://www.vbnettutorial.com/ http://howtostartprogramming.com/vb-net/ *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation* On Thu, May 3, 2012 at 11:43 PM, Ar

Re: $$Excel-Macros$$ Update cells based on combo box selection

Please attach file with sample data for understanding. *Regards,* *Lalit Mohan* On Thu, May 3, 2012 at 7:45 PM, Seema wrote: > > hi, > > I want to have an application which enables the employee to select the day > to mark as off. i have started with and excel sheet with Names in a column > a

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

Congratulation bhai *Regards,* *Lalit Mohan* On Thu, May 3, 2012 at 6:21 PM, Rajan_Verma wrote: > Thank you all. J > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.c

Re: $$Excel-Macros$$ working with array

Try This Sub lmTest() Dim test(50) As String With ActiveSheet test(0) = .Cells(1, 2) ' cells(1,2)= "LT12" test(15) = .Cells(1, 3) ' cells(1,3) "121" .Cells(1, 10) = CDbl(test(0)) + CDbl(test(15)) End With End Sub *Regards,* *Lalit Mohan* On Th

Re: $$Excel-Macros$$ lotus notes mails

Dear Prabhat Try this Sub sendEmail(EmailSubject As String, EMailSendTo As String, EMailBody As String, MailServer as String) Dim objNotesSession As Object Dim objNotesMailFile As Object Dim objNotesDocument As Object Dim objNotesField As Object Dim sendmail As Boolean

Re: $$Excel-Macros$$ Rising lagna-astrology

Dear Nemi can u please explain step wise your issue. *Regards,* *Lalit Mohan* On Thu, May 3, 2012 at 7:04 PM, Rajan_Verma wrote: > ** ** > > Hi, > > As I remember ,I have seen this file before 3-4 months on group, can you > please explain it more .. what you want to do ? > > ** ** >

Re: $$Excel-Macros$$ Spelling problem

Try this link http://office.microsoft.com/en-us/word-help/turn-on-or-off-autocorrect-options-HP005189430.aspx *Regards,* *Lalit Mohan* On Thu, May 3, 2012 at 6:25 PM, Rajan_Verma wrote: > *You can Check the office autocorrect option * > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91

Re: $$Excel-Macros$$ Automatic insert of row at each change in particular data

Dear Vaibhav Please attach sample for reference. *Regards,* *Lalit Mohan* On Thu, May 3, 2012 at 12:17 PM, NOORAIN ANSARI wrote: > Dear Vaibhav, > > Please select required range and run this code.. > > Sub InsertRows_Vaibhav() > Dim InsQuan As Integer > On Error Resume Next > InsQuan = InputB

Re: $$Excel-Macros$$ Need Your Help

*Hi karthik* * * *PFA* * * *Regards,* *Lalit Mohan* On Sun, Apr 29, 2012 at 10:56 PM, ╰» ℓαℓιт мσαнη wrote: > *Hi karthik* > * > * > *PFA* > > *Regards,* > *Lalit Mohan* > > > > On Sun, Apr 29, 2012 at 1:38 PM, karthik N wrote: > >> Hi friends, >&g

Re: $$Excel-Macros$$ Need Your Help

*Hi karthik* * * *PFA* *Regards,* *Lalit Mohan* On Sun, Apr 29, 2012 at 1:38 PM, karthik N wrote: > Hi friends, > > Find the attachment of company address,how to spreat'up the colomn wise > data > > Sample data is attached. > > > Regards > karthik.N > > -- > FORUM RULES (986+ members already

Re: $$Excel-Macros$$ data needed in this format

*Hi Sara * * * *PFA* *Regards,* *Lalit Mohan* On Sun, Apr 29, 2012 at 12:38 PM, Sara Lee wrote: > Attached is the file with 2 sheets - input and output. > output i require is based on input tab--- i need every reference value to > be listed as columns and then list down the load nos in which

Re: $$Excel-Macros$$ FORMULA FOR DATE AND TIME

*Try this also:* * * *Formula in A1 is =NOW()* * * *Formula in A2 is* * * *=IF(WEEKDAY(IF(WEEKDAY(A1,2)=6,A1+2+TIME(0,5,0),IF(WEEKDAY(A1,2)=7,A1+1+TIME(0,5,0),A1+TIME(0,5,0))),2) = 6, IF(WEEKDAY(A1,2)=6,A1+2+TIME(0,5,0),IF(WEEKDAY(A1,2)=7,A1+1+TIME(0,5,0),A1+TIME(0,5,0)))+2,IF(WEEKDAY(IF(WEEKDAY(A1

Re: $$Excel-Macros$$ Attendance tracking

Please find the attached file with solution *Regards,* *Lalit Mohan* On Wed, Apr 25, 2012 at 9:22 PM, yogananda muthaiah < yogananda.mutha...@gmail.com> wrote: > Hi Experts > > I would require your help in making it simple > > For Example > > Employee No 111 has taken a leave from 02/04/2012