Re: $$Excel-Macros$$ Help required in excel

2017-07-16 Thread 'Karleen Biggs' via MS EXCEL AND VBA MACROS
On Sun, 7/16/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Help required in excel To: excel-macros@googlegroups.com Date: Sunday, July 16, 2017, 1:32 PM --

Re: $$Excel-Macros$$ Help required in excel

2017-07-16 Thread 'Kenyatta Freed' via MS EXCEL AND VBA MACROS
On Sat, 7/15/17, Manoj Garg wrote: Subject: Re: $$Excel-Macros$$ Help required in excel To: excel-macros@googlegroups.com, srinu88...@gmail.com Date: Saturday, July 15, 2017, 7:19 PM You can use Exact(text1, text2) On Sat, Jul 15, 2017 at

Re: $$Excel-Macros$$ Help required in excel

2017-07-15 Thread Manoj Garg
You can use Exact(text1, text2) On Sat, Jul 15, 2017 at 8:01 PM, Srinivas G wrote: > Hi Friends, > > I want to help in Excel > > ramu Ramu False > Raju Raju True > mohan Mohan False > Venu VenuTrue > SAISai False > > I first cell and se

$$Excel-Macros$$ Help required in excel

2017-07-15 Thread Srinivas G
Hi Friends, I want to help in Excel ramu Ramu False Raju Raju True mohan Mohan False Venu VenuTrue SAISai False I first cell and second cell there will be data, please bring me a formulae that says the True and False data based on the s

Re: $$Excel-Macros$$ Help required in excel

2015-05-14 Thread Jitender kumar
Dear Sir, My company has two shifts say Ist shift working =6:00 to 14:00 ans second shift 14:00 to 22:00 i have large data of employees (rotating shifts) and want to calculate which employee worked in which shift Excel is on that format EmployeeCode Shift

Re: $$Excel-Macros$$ Help required in excel

2011-02-21 Thread Vikas Chouhan
Hi Jitender, it's done without using vba coding just change CODE On Mon, Feb 21, 2011 at 8:50 PM, Jitender kumar wrote: > > > On 21 February 2011 10:25, anil panchal wrote: > >> please send sample file. >> >> >> On Sun, Feb 20, 2011 at 10:05 PM, jaibeersingh panwar < >> panwar.jaibeersi...@gma

Re: $$Excel-Macros$$ Help required in excel

2011-02-21 Thread Jitender kumar
On 21 February 2011 10:25, anil panchal wrote: > please send sample file. > > > On Sun, Feb 20, 2011 at 10:05 PM, jaibeersingh panwar < > panwar.jaibeersi...@gmail.com> wrote: > >> Hi Jitendra, >> >> If you have that excel sheet forward it to us.. empty one will do.. >> Regards, >> Jaibeer >> >>

Re: $$Excel-Macros$$ Help required in excel

2011-02-20 Thread anil panchal
please send sample file. On Sun, Feb 20, 2011 at 10:05 PM, jaibeersingh panwar < panwar.jaibeersi...@gmail.com> wrote: > Hi Jitendra, > > If you have that excel sheet forward it to us.. empty one will do.. > Regards, > Jaibeer > > > On Sun, Feb 20, 2011 at 4:38 PM, Jitender kumar > wrote: > >>

Re: $$Excel-Macros$$ Help required in excel

2011-02-20 Thread jaibeersingh panwar
Hi Jitendra, If you have that excel sheet forward it to us.. empty one will do.. Regards, Jaibeer On Sun, Feb 20, 2011 at 4:38 PM, Jitender kumar wrote: > Dear Excel Guru, > > 1. I have address book in Excel in following format. How to print 15 > address label in A4 paper Sticker using excel.Pl

Re: $$Excel-Macros$$ Help required in excel

2011-02-20 Thread Jitender kumar
DEAR TEAM /EXCEL EXPERTS PLZ HELP ME REGARDS JITENDER On 20 February 2011 16:38, Jitender kumar wrote: > Dear Excel Guru, > > 1. I have address book in Excel in following format. How to print 15 > address label in A4 paper Sticker using excel.Pl attach a sample sheet(if > uses VBA or else) >

Re: $$Excel-Macros$$ Help required in excel

2011-02-20 Thread Jitender kumar
DEAR TEAM PLZ HELP ME THANKS JITENDER On 20 February 2011 16:38, Jitender kumar wrote: > Dear Excel Guru, > > 1. I have address book in Excel in following format. How to print 15 > address label in A4 paper Sticker using excel.Pl attach a sample sheet(if > uses VBA or else) > > S.no

$$Excel-Macros$$ Help required in excel

2011-02-20 Thread Jitender kumar
Dear Excel Guru, 1. I have address book in Excel in following format. How to print 15 address label in A4 paper Sticker using excel.Pl attach a sample sheet(if uses VBA or else) S.noEmpcode Name FName Address1, Address 2, City, State, PIncode, Mobile It should be printed like this Na

Re: $$Excel-Macros$$ Help Required in Excel Roster

2009-12-17 Thread Norman May
Hems, Basically there are hidden helper columns and rows that do some of the calculations. One of the hidden rows counts how many changes from Sunday to Monday. Then the OFFSET function was used to access this calculation that dictate the correct offset. A formula with several IF functions were us

Re: $$Excel-Macros$$ Help Required in Excel Roster

2009-12-17 Thread Hems
Norman, Dude its too gud Keep it up ... i wud lik learn all this ...how did u manage this?? Cheers! Hems On Thu, Dec 17, 2009 at 10:25 PM, Norman May wrote: > Hems, > > Attached is another version of your Roster. > > Norman > > On Tue, Dec 15, 2009 at 12:56 PM, Hems wrote: > >> Hello A

Re: $$Excel-Macros$$ Help Required in Excel Roster

2009-12-17 Thread Hems
Hey Norman, Amazing work... yup this is what i wanted ...appreciate if cud explain the logic ..in short.. Thanks a lot bro Cheers! Hems On Thu, Dec 17, 2009 at 6:26 AM, Norman May wrote: > Hopefully this is what you wanted. > > Norman > On Tue, Dec 15, 2009 at 12:56 PM, Hems wrote: > >>

$$Excel-Macros$$ Help Required in Excel Roster

2009-12-15 Thread Hems
Hello All, I have created excel roster but i am stuck with formula. I have mentioned all the information in the excel file. Appreciate if you'll help me to create automated roster for every month after inserting the shift for day 1 of the month. Attached file for further information. Thanks in