Re: $$Excel-Macros$$

2015-05-14 Thread Rakesh
​help plz​ RAKESH SHARMA NPI –Team Ericsson India Pvt. Ltd. 4th Floor, Gupta Towers, Commercial Block, Rail Head Jammu & Kashmir, INDIA Phone 01912477440/ 01912477473/441 Fax 01912477442 Mobile +91 9906115140 rakesh.kumar.d.sha...@ericsson.com www.ericsson.com “If You fall, fall like a seed to g

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$$ Re: Copy PDF data to Excel macro require

2015-05-14 Thread Pankaj Sharma
Hi MV, Firstly, I want to say thanks for sharing this valuable Macro. People already had given up hope but you have done a great work here. In this macro, getting runtime error in below line:- Invalid procedure call or argument. AppActivate "Adobe Reader And also, if any PD

Re: $$Excel-Macros$$ Count if in an active status

2015-05-14 Thread Heather Battle
that's correct On Thursday, May 14, 2015 at 1:13:52 PM UTC-4, ashish wrote: > > just wanted to check even if the some one is active just for a day in a > month like start date is 1 jan 2014 and end date is 2 jan 2014 will that > be counted as active in jan month > > > On Thu, May 14, 2015 at 1

Re: $$Excel-Macros$$ Count if in an active status

2015-05-14 Thread ashish koul
just wanted to check even if the some one is active just for a day in a month like start date is 1 jan 2014 and end date is 2 jan 2014 will that be counted as active in jan month On Thu, May 14, 2015 at 10:37 PM, Heather Battle wrote: > I have a spreadsheet where i have participants that enro

$$Excel-Macros$$ Count if in an active status

2015-05-14 Thread Heather Battle
I have a spreadsheet where i have participants that enrollment start and end dates. i would like to know if there is a formula to determine if they were in active status for a particular month and since there is a group of them, to count a number people who were also active given the start and e

Re: $$Excel-Macros$$ Conditional Formating Problem

2015-05-14 Thread Ganesh N
HI abbas, Use the conditional formatting with "Use a formula to determine which cells to format' Regards, Ganesh N On Thu, May 14, 2015 at 3:24 PM, Ali Abbas wrote: > Dear All. Hope u r all well. > > I have two column with numbers. My requirement is if one column values is > greater than other

Re: $$Excel-Macros$$ Re: Do while loop question

2015-05-14 Thread liron glam
Ok thanks! I got what you mean thanks alot!!! 2015-05-14 14:07 GMT+03:00 liron glam : > hi, > Thanks! > but to change this: > > =IFERROR(ROUND((E6/G6*100),0)/100,0) > instead of what formula? > > 2015-05-14 12:52 GMT+03:00 Nasir Saikh : > >> Hi, >> >> You need to change formula with below... >> >

Re: $$Excel-Macros$$ Re: Do while loop question

2015-05-14 Thread liron glam
hi, Thanks! but to change this: =IFERROR(ROUND((E6/G6*100),0)/100,0) instead of what formula? 2015-05-14 12:52 GMT+03:00 Nasir Saikh : > Hi, > > You need to change formula with below... > > =IFERROR(ROUND((E6/G6*100),0)/100,0) > > > On Monday, January 12, 2015 at 7:45:03 PM UTC+5:30, liron glam

$$Excel-Macros$$ Re: Conditional Formating Problem

2015-05-14 Thread Nasir Saikh
PLEASE SHARE SAMPLE FILE On Thursday, May 14, 2015 at 3:24:47 PM UTC+5:30, ali abbas wrote: > Dear All. Hope u r all well. > > I have two column with numbers. My requirement is if one column values is > greater than other then greater values color should be red and its smaller > values color is

$$Excel-Macros$$ Conditional Formating Problem

2015-05-14 Thread Ali Abbas
Dear All. Hope u r all well. I have two column with numbers. My requirement is if one column values is greater than other then greater values color should be red and its smaller values color is green. How can I compare two columns by using of conditional. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)

$$Excel-Macros$$ Re: Do while loop question

2015-05-14 Thread Nasir Saikh
Hi, You need to change formula with below... =IFERROR(ROUND((E6/G6*100),0)/100,0) On Monday, January 12, 2015 at 7:45:03 PM UTC+5:30, liron glam wrote: > > > I have big data file on excel, the file has 6930 rows and 8 columns, the 8 > column has percents (0%, 4%, 16%, 18%, 19% and etc..) >

Re: $$Excel-Macros$$ Do while loop question

2015-05-14 Thread liron glam
Hello I have another problem with this macro code, whenever it's "#DIV/0!" its an error and the loop stops, what can i do to make it go further with the loop without coloring the error rows? Thanks in advance 2015-01-13 13:09 GMT+02:00 Ashish Kumar : > Nice Solution Vaibhav Sir. > > > Regards >

$$Excel-Macros$$ MULTIPLE EMIAL TO BE SENT FOR OUTSTANDING

2015-05-14 Thread khagesh khera
Dear Sir, We need to send multiple email to client for outstanding on starting of every month. The client database is quite huge we required your help on the same. We required all the emails to be saved in Outlook drafts & after checking it goes to client. We need to sent the email on email bo