Re: $$Excel-Macros$$ Re: How to create this file? Explain anyone

Thanks very much Rajan for Excellent explanation Now I got my mistek & repair also Regards Amar On Sat, Sep 15, 2012 at 10:33 AM, Rajan_Verma wrote: > *Steps:* > > * * > > ***1) Goto Home.. Find and Select – Selection Pane* > > ***2) Visible your all pics (if not visible)* > > *

Re: $$Excel-Macros$$ EXCEL ADD-IN for reconciling two Data Tables

Its very nice Addon, excellent job. On Fri, Sep 14, 2012 at 7:35 PM, Rajan_Verma wrote: > *Its Wow **J*** > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Aju

RE: $$Excel-Macros$$ Re: How to create this file? Explain anyone

Steps: 1) Goto Home.. Find and Select - Selection Pane 2) Visible your all pics (if not visible) 3) Align them at a place same height width 4) Try again to run the code Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:exc

Re: $$Excel-Macros$$ Re: How to create this file? Explain anyone

Dear Rajan Thanks for Quick Reply In sheet if I click photo name then Photo show anywhere I want to show photo in fixed cell.And also If I click Ram Then show error why?Which I had attached First sheet (Lookup Sheet) in that VBA code work properly But when I create same with same activity then why

Re: $$Excel-Macros$$ Copy Two sheet of one Workbook to other Workbooks

Dear Experts, If any one can solve this problem I will be verymuch thankful . This will reduce my work . Regards Shrinivas On Fri, Sep 14, 2012 at 12:23 PM, SAGAR KASANGOTTUWAR < sagarkasangottu...@gmail.com> wrote: > Dear Paul, > How can we create a list of the 15 report files in a sheet? > >

Re: $$Excel-Macros$$ lookup or vLookup

Dear Simon, Pl share us a sample workbook. Regards Gawli Anil On Sat, Sep 15, 2012 at 10:12 AM, ashish koul wrote: > try this > VLOOKUP(A2,B:C,2,0) > remove extra spaces from the columns > > Regards > Ashish > > > > On Sat, Sep 15, 2012 at 12:51 AM, SimonCoder wrote: > >> I have a formula I'

Re: $$Excel-Macros$$ lookup or vLookup

try this VLOOKUP(A2,B:C,2,0) remove extra spaces from the columns Regards Ashish On Sat, Sep 15, 2012 at 12:51 AM, SimonCoder wrote: > I have a formula I'm trying to figure out and I can't seem to find any > good explainations of how to use Lookup or vLookup. > > Here is what I'm trying to d

Re: $$Excel-Macros$$ Small Query

Dear Rajan I dont have a word to express myself I dont want to say thanks again and again. Just salute to you Regards Shrinivas On Sat, Sep 15, 2012 at 9:11 AM, Rajan_Verma wrote: > *Hi shrinivas,* > > * * > > *I have learned it from Microsoft page , link in mentioned below * > > * * > > > http

Re: $$Excel-Macros$$ Best way to generate lists from employee bio worksheets ?

Thanks for your reply Rajan. To be honest, I really don't know what a compiler is. If you think it would give me the results I'm looking for, I'd certainly try it. Thanks again. On Fri, Sep 14, 2012 at 11:59 PM, Rajan_Verma wrote: > *Do you want a compiler . which can generate a Flat File da

Re: $$Excel-Macros$$ Re: How to create this file? Explain anyone

Dear Rajan,Below code not work,If possible put this code in sheet & send me Pls I will wait On Fri, Sep 14, 2012 at 7:55 PM, Rajan_Verma wrote: > *Paste this on Sheet1 worksheet Module* > > * * > > *Private Sub Worksheet_Change(ByVal Target As Range)* > > *If Target Is Range("A2") Then* > > *

RE: $$Excel-Macros$$ Best way to generate lists from employee bio worksheets ?

Do you want a compiler . which can generate a Flat File database from all template ? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Gern Sent: 15 September 2012 9:24 To: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ Basic and advanced VBA

Visit here J http://home.pacbell.net/beban http://excel.tips.net http://www.andrewsexceltips.net/ http://www.andypope.info/ http://akoul.blogspot.com http://www.ashishmathur.com http://www.discussexcel.com http://members.aol.com/Machero http://www.exceluser.com/ http://www.cpearson

$$Excel-Macros$$ Best way to generate lists from employee bio worksheets ?

Hi: I'm very pleased to join this group, as it seems there are a lot of members who have vastly more experience and talent using excel than I do. Hopefully, someone can offer some advise. I'm designing a spread sheet for work, which is going to capture basic biographical and training informati

$$Excel-Macros$$ Basic and advanced VBA

Dear All, How can I Learn Basic and advanced VBA. Is any material available with the group members.Are there any websites for videos tutorials available.Please provide details and materials as they would be immensely helpful to me. Thanks for all the help and support in answering everyone's excel

RE: $$Excel-Macros$$ Small Query

Hi shrinivas, I have learned it from Microsoft page , link in mentioned below http://office.microsoft.com/en-us/excel-help/create-a-custom-number-format-H P010342372.aspx Another useful information you can find on chandoo.org http://chandoo.org/wp/2008/02/25/custom-cell-formatting-

Re: $$Excel-Macros$$ Small Query

Dear Rajan Really thanks for reply and as said by Ayush nice explanation. Is there any article or material to read on custom format if yes please let me know. Regards Shrinivas On Fri, Sep 14, 2012 at 10:37 PM, Ayush Jain wrote: > Good explaination Rajan > cheers > > On Fri, Sep 14, 2012 at 7:

$$Excel-Macros$$ MIS REPORT FOR HR

Hi friends, i need mis report format for hr purpose. kly help me urgent base. regards kannan v -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor th

Re: $$Excel-Macros$$ lookup or vLookup

So, your Column B and C is a list of unique item/description combinations? Not sure why you would end up with that, but the formula in D2 would be: =VLOOKUP(A2,B:C,2,FALSE)   Paul - “Do all the good you can, By all the means you can, In all the ways you ca

$$Excel-Macros$$ lookup or vLookup

I have a formula I'm trying to figure out and I can't seem to find any good explainations of how to use Lookup or vLookup. Here is what I'm trying to do: A | B | C | D - 50 | 50 | 50desc | ??? 52 | 51 | 51desc | ??? 50 | 52 | 52desc |

Re: $$Excel-Macros$$ Small Query

Good explaination Rajan cheers On Fri, Sep 14, 2012 at 7:43 PM, Rajan_Verma wrote: > *Sure,* > > * * > > *The Custom Format is divided into 4 segment ,delimited by a Semicolon > (;) , that 4 segments are :-* > > * * > > *Positive ; Negative ; Zero ; Text* > > * *

RE: $$Excel-Macros$$ find the latest date

Use lookup formula =vlookup(G2,A$2$:E$8$,5,0) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sundarvelan N Sent: 14 September 2012 15:20 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ find the latest date Dear Friends, Please h

RE: $$Excel-Macros$$ FREE EXCEL ADD-IN for comparing/reconciling/tallying two excel worksheets

Good .. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ajuvcha...@gmail.com Sent: 14 September 2012 12:11 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ FREE EXCEL ADD-IN for comparing/reconciling/tallying two excel

RE: $$Excel-Macros$$ How to put sum formula automatically - seems easy but not so

Would it be helpful for you?? Sub MTest() Dim rngRange As Range Dim rngCell As Range Dim rngFrom As Range Dim rngToAs Range Set rngRange = Range("I:I") For Each rngCell In rngRange If rngCell.Value = "Charge £" Then Set rngFrom = rngCell.Offset

$$Excel-Macros$$ Re: How to put sum formula automatically - seems easy but not so

hi Is it resolved? Kindly acknowledge all contributors. Rgds Vabz On Friday, September 14, 2012 11:17:13 AM UTC+5:30, Jai wrote: > Hi group, > > > > > > I need some help in putting sum formula and hope u all will provide a good > help as always….. > > > > > > I am attaching a sheet

Re: $$Excel-Macros$$ Calculate next working day

Hey.. Rilli great logic.. Cherz.. Vabz On Friday, September 14, 2012 8:20:48 PM UTC+5:30, Rajan_Verma wrote: > *I1:I3 is holiday list* > > * * > > * > =IF(WEEKDAY(A1,2)=5,IF(COUNTIF(I:I,A1+1)=0,A1+1,WORKDAY(A1,1,$I$1:$I$3)),WORKDAY(A1,1,$I$1:$I$3)) > * > > * * > > * * > > *Regards* > > *Raja

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

Rajan's code is much better than my code... On Sep 14, 2012 7:48 PM, "Rajan_Verma" wrote: > * * > > *Where is your ComboBox?* > > * * > > *If on userform use this* > > *Userform1.ComboBox1.List=RstRecord.GetRows* > > *If on Worksheet Use this* > > *Sheet1.DropDowns

Re: $$Excel-Macros$$ Calculate next working day

Can you check to see if it has the Workday.INTL function? (I don't remember if it was new with 2010, or 2007)   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all th

Re: $$Excel-Macros$$ find the latest date

Hi Sundarvelan, Use this CSE formula =MAX(IF(G2=A:A,E:E)) -- *Regards,* * * *Excel Beginner* On Fri, Sep 14, 2012 at 4:49 PM, Sundarvelan N wrote: > Dear Friends, > > Please help me to find the latest date of a student. > Thanks > N.Sundarvelan > 9600160150 > > -- Join

RE: $$Excel-Macros$$ Spreadsheet within Spreadsheet

Read this You will be able to do this with yourself http://blogs.office.com/b/microsoft-excel/archive/2006/07/17/office-web-comp onents-roadmap.aspx Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf

RE: $$Excel-Macros$$ Locking Only Selected Cell

Select Cells and Run This Sub LockSelected() With Sheet1 .Unprotect .Cells.Locked = 1 Selection.Locked = 0 .Protect End With End Sub Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros

RE: $$Excel-Macros$$ Calculate Starting Date Based on Week Number in a year

Do you want the first Day date of that Week From a year? =DATE(YEAR(TODAY()),1,1)+(7*C2)-(WEEKDAY(DATE(YEAR(TODAY()),1,1)+(7*C2))-(WE EKDAY(DATE(YEAR(TODAY()),1,1)+(7*C2))-1))+2 Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@g

RE: $$Excel-Macros$$ Calculate next working day

I1:I3 is holiday list =IF(WEEKDAY(A1,2)=5,IF(COUNTIF(I:I,A1+1)=0,A1+1,WORKDAY(A1,1,$I$1:$I$3)),WOR KDAY(A1,1,$I$1:$I$3)) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of santosh subudhi Sent: 14 Se

RE: $$Excel-Macros$$ Re: How to create this file? Explain anyone

Paste this on Sheet1 worksheet Module Private Sub Worksheet_Change(ByVal Target As Range) If Target Is Range("A2") Then With Me .Pictures.Visible = False .Pictures(Range("rngPhotName").Value).Visible = True End With End If End Sub Reg

RE: $$Excel-Macros$$ How to put sum formula automatically - seems easy but not so

Am I not getting the problem correctly or is it very simple ? Use this: Sub PutSum() Range("rngSum").Formula = "=Sum(I2:I" & Range("rngSum").Offset(-1).Row & ")" End Sub Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros

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

Where is your ComboBox? If on userform use this Userform1.ComboBox1.List=RstRecord.GetRows If on Worksheet Use this Sheet1.DropDowns("ComboBox1").List= rstRecord.GetRows Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@google

RE: $$Excel-Macros$$ Small Query

Sure, The Custom Format is divided into 4 segment ,delimited by a Semicolon (;) , that 4 segments are :- Positive ; Negative ; Zero ; Text So the corresponding values with the segment will display as format defined , here in this example I use :

RE: $$Excel-Macros$$ EXCEL ADD-IN for reconciling two Data Tables

Its Wow J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aju Chacko Sent: 13 September 2012 11:59 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ EXCEL ADD-IN for reconciling two Data Tab

Re: $$Excel-Macros$$ Calculate next working day

Dear Santosh, You use this formula with ctrl+shift+enter, it will work fine. If it doesn't meet your expectation, send a sample file. On Fri, Sep 14, 2012 at 4:11 PM, santosh subudhi < santoshkumar.subu...@gmail.com> wrote: > Hi Noorain, > > Thanks for your early response. > > I am unable to inc

$$Excel-Macros$$ Spreadsheet within Spreadsheet

Hey guys, trying to take Excel to the next level here for a budget template design that I have in mind. Is it possible to have a spreadsheet within a spreadsheet? Let me clarfiy: I'd like to insert for a certain portion of the screen, another spreadsheet within my original spreadsheet. That "

$$Excel-Macros$$ Congratulations Noorain

Congratulations from Canada to Noorain on your achievement. You deserve it! David -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate

Re: $$Excel-Macros$$ Locking Only Selected Cell

Hi, Select sheet(Ctrl+A)--Goto Format cells--untick*Locked*--Ctrl+Click desire cell--Goto Format cells--tick*Locked*--ok--click*protect sheet*. Now desire cell only lock. Thanks karthik On 14 September 2012 17:07, sharad jain wrote: > Dear Experts, > > Can someone please let me know how to loc

Re: $$Excel-Macros$$ Locking Only Selected Cell

Unlock ALL cells and use a worksheet_selectionchange event to lock it>then protect sheet Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: sharad jain Sent: Friday, September 14, 2012 6:37 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Locking

Re: $$Excel-Macros$$ find the latest date

=SUMPRODUCT(MAX((A2:A10=g2)*(E2:E10))) Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Sundarvelan N Sent: Friday, September 14, 2012 6:19 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ find the latest date Dear Friends, Please help me to f

RE: $$Excel-Macros$$ Calculate next working day

Hi Paul, I am using the excel 2007 version. -- Regards Santosh santoshkumar.subu...@gmail.com -- Date: Fri, 14 Sep 2012 04:21:30 -0700 From: schreiner_p...@att.net Subject: Re: $$Excel-Macros$$ Calculate next working day To: excel-macros@googlegroups.com What version

$$Excel-Macros$$ Calculate Starting Date Based on Week Number in a year

Hi Friends, Help me in find the Starting Date Based on Week Number in a year. Thanks N.Sundarvelan 9600160150 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. P

$$Excel-Macros$$ Re: Calculate next working day

Hi Santosh, Hope this UDF function can help you Public Function getNextWorkingDate(startDate As String, Days As Integer, ParamArray fld() As Variant) As String Dim strStartDate As String Dim strEndDate As String Dim intCtr As Integer Dim intCtr1 As

$$Excel-Macros$$ Locking Only Selected Cell

Dear Experts, Can someone please let me know how to lock only selected cell? Thanks, Sharad -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles

Re: $$Excel-Macros$$ find the latest date

Hi Sundarvelan, Try this. =MAX(E2:E8) Regards, Kuldeep Singh On Fri, Sep 14, 2012 at 5:00 PM, Paul Schreiner wrote: > If you sort the data by Date, in Descending order, > a VLookup will return the first match, which will be the "latest" date. > > > *Paul* > > -

Re: Fwd: FW: $$Excel-Macros$$ Send PDF Email from Excel - Mail Merge

Hi Everyone,, I am trying to use chrome instead using Internet explorer. Here is the code I have (the code the works for Internet Explorer and the modified code for Chrome): Dim IEapp As Object Dim CHromeapp As Object 'Open Internet Explorer and Display the Route Set IEapp = CreateObject(

Re: $$Excel-Macros$$ find the latest date

If you sort the data by Date, in Descending order, a VLookup will return the first match, which will be the "latest" date.   Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you ca

Re: $$Excel-Macros$$ Calculate next working day

What version of Excel are you using? In Excel 2010, there is a variation of the WorkDay function called Workday.INTL WORKDAY.INTL(start_date, days, [weekend], [holidays]) Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters. Weekend

$$Excel-Macros$$ find the latest date

Dear Friends, Please help me to find the latest date of a student. Thanks N.Sundarvelan 9600160150 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread

Re: $$Excel-Macros$$ Calculate next working day

Dear Santosh, Please try it.. *=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(I52&":"&J52)),2)<6))* Hope it will meet your expectation. -- With Regards, Noorain Ansari http:// noorainansari.com http://

$$Excel-Macros$$ Re: Excel sheet wise restrictions required for end users

Hello, To solve this issue you should use protection of "Workbook Structure", something like that: ActiveWorkbook.Unprotect Password:="123" ActiveWorkbook.Protect Structure:=True, Windows:=False, Password:="123" Regards, Anton. Пʼятниця, 14 вересня 2012 р. 12:03:23 UTC+3 користувач P

$$Excel-Macros$$ Calculate next working day

Hi Group, I want to calculate the next working day where Monday to Saturday are the working days and it should also consider the holidays. For example, 1-Sept (Saturday) is the 1st working day and 3-Sept(Monday) is a holiday,so next working day is 4-Sept (tuesday) I cannot use working day functi