Re: $$Excel-Macros$$ Re: Row to repeat at the bottom of each page

2013-06-17 Thread VBA VABZ
Hi Sub MyFooter() Dim StrFtr As String, Rng As Range, Sh As Worksheet, c As Range Set Sh = Worksheets("Sheet1") Set Rng = Sh.Range("A51:G51") For Each c In Rng StrFtr = StrFtr & c & " " Next c ActiveSheet.PageSetup.LeftFooter = StrFtr End Sub HTH On Mon, Jun 17, 2013 at 4:26 PM, Ira wrote:

$$Excel-Macros$$ Re: Row to repeat at the bottom of each page

2013-06-17 Thread Ira
Hi All, I need to me to know. Pls help. Thanks, Ira. On Thursday, May 17, 2012 11:17:26 AM UTC+5:30, Siraj Momin (BTG) wrote: > > Dear Excel Group Friends > > > > Is there any way that certain rows of a sheet is repeated at the bottom of > each page…… > > > > > > > > Siraj > > > -- A

$$Excel-Macros$$ Fwd: Urgent job opening with Atos for VBA_Gurgaon

2013-06-17 Thread KAUSHIK SAVLA
Fyi -- Forwarded message -- From: "Abyss & Horizon Consulting Pvt. Ltd." Date: Jun 17, 2013 2:19 PM Subject: Urgent job opening with Atos for VBA_Gurgaon To: To respond back directly to the Employer, please click on Reply button, or send an email to anus...@ahcindia.com (Pleas

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

2013-06-17 Thread priti verma
You can also use this one =IFERROR(IF(ISERROR(INDEX(Sheet1!$B$1:$AI$41,MATCH(RESULT!$B4,Sheet1!$B$1:$B$41,0),MATCH(RESULT!C$3,Sheet1!$B$1:$AI$1,0))),INDEX(Sheet2!$A$1:$AH$31,MATCH(RESULT!$B4,Sheet2!$A$1:$A$31,0),MATCH(RESULT!C$3,Sheet2!$A$1:$AH$1,0)),INDEX(Sheet1!$B$1:$AI$41,MATCH(RESULT!$B4,Sheet1

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

2013-06-17 Thread Sundarvelan N
Dear Friends, Please help me capturing the attendance from multiple sheet. Thanks N.Sundarvelan 9600160150 -- 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

Re: $$Excel-Macros$$ Attendance Tracker

2013-06-17 Thread Abhishek Verma
Option "P" is not coming in drag down option. On Mon, Jun 17, 2013 at 1:21 PM, xlstime wrote: > Hi Vikas, > > Please find attach attendance or leave Planner > > . > > Enjoy > Team XLS > > > > On Mon, Jun 17, 2013 at 12:59 PM, vikas khen wrote: > >> Hi, >> >> Any anybody

$$Excel-Macros$$ Attendance Tracker

2013-06-17 Thread vikas khen
Hi, Any anybody Have Attendance Tracker excel sheet? I need this for my Organization purpose. Waiting for Positive Reply. Regards -- 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.facebo