$$Excel-Macros$$ copy data from one workboor to another

2021-04-26 Thread Ayoub Kakande
Dear all I need some help building a macro I would want to copy data from one work book (bookA) another work book (workb)without opening it The data in work book A is in 2 worksheets all to be copied onto one worksheet in second workbook (workb) any help will be much appreciated -- **In sun set

Re: $$Excel-Macros$$

2017-12-05 Thread Ayoub Kakande
> > > > > > > > *“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 the people > you can,As long as ever you can.” - John Wesley* > - > >

Re: $$Excel-Macros$$

2017-12-05 Thread Ayoub Kakande
n,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Tuesday, December 5, 2017 4:52 AM, Ayoub Kakande > wrote: > > > Dear All, > I have column A t

$$Excel-Macros$$

2017-12-05 Thread Ayoub Kakande
Dear All, I have column A that contains random numbers, I want column B to pick from A fill one number 10 times, thn pick the second fill it 10 times etc, Any help will be much appreciated -- **In sun set years education is not associated with standard of living and medical care access; it is the

$$Excel-Macros$$ auto populate on condition

2017-03-08 Thread Ayoub Kakande
Hi all, I have an excel sheet that I will be using to put in Id's of a study in columns I have column A, B, C, D , E, F, G H, I , J ,K I am enrolling patients in a case:control study of 1:3 ratio - the cases are categorized into different types into column A, B, C to K every time I enroll a case

$$Excel-Macros$$

2011-11-29 Thread Ayoub Kakande
i have a simple formula like =(a2+b2)/2 it returns zero for empty cells yet I want it to leave empty cells blank please help -- *If u wanna dream dream BIG *You`ve got to do your own growing, no matter how tall your grandfather was Kayoub K 0772656158 / 0703516660 PMTCT Data Manager Mujhu Resea

Re: $$Excel-Macros$$ Re: sum of least 8 subjects

2011-06-01 Thread ayoub Kakande
m. > See the attached file and feel free to revert in case of any queries.  Thanks. > > Best Regards, > DILIPandey > > On 6/1/11, ayoub Kakande wrote: >> Hello have attached the file >> Need to find the sum of least 8 from >> (f2,l2,r2,x2,ad2,aj2,ap2,av2,bb2,bh2,bn2

$$Excel-Macros$$ sum of least 8 subjects

2011-05-31 Thread ayoub Kakande
should not compute for him the total. These subjects are not in consecutive columns Thanx -- Ayoub Kakande 0772656158 / 0703516660 Data - Mujhu Mulago Hosp -- -- Some important links for excel users: 1. Follow us on

Re: $$Excel-Macros$$ Urgent Help needed

2010-11-02 Thread ayoub Kakande
egards, >> Andy >> >> On Tue, Nov 2, 2010 at 3:20 PM, ayoub Kakande wrote: >> >>> Good afternoon >>> I need some help on a project that is buzzing ma head >>> atta

Re: $$Excel-Macros$$ Urgent Help needed

2010-11-02 Thread ayoub Kakande
On 2 November 2010 15:06, Aindril De wrote: > Hi Ayoub, > > Can you please explain this: > > Of these columns some lack data if less than 8 of the above columns lack > data word "missed" should appear > > Regards, > Andy > > On Tue, Nov 2, 2010 at 3:20 PM

Re: $$Excel-Macros$$ how to use kill function in macros

2010-10-22 Thread ayoub Kakande
subjects. attached is the excell file -- Ayoub Kakande 0772656158 / 0703516660 Data - Mujhu Mulago Hosp -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com