Recent content by odartey

Hello all, the script below as been of great help to me. the flexibility of having to double click and type your first two letters and the required text popping up for you. Thanks to CONTEXTURES. Now my challenge is when the sheet is protected , the double clicking becomes inactive, ie you don't...

Hi all I have a lengthy list of which I want to just type the first two letters and a suggestion will pop up so I pick from. Data validation does not allow for that, since you will have to scroll through till you find want you looking for. Can I get any help? Thank you

Hello all, I trust you are all doing very well. I have built an Excel database using macros and Vb and also saved the file in the binary format. As we all know Excel just gives us a single source of data input. My database has four data input points,but participants to the file must do entries...

Awww......... I am sooooo happy and grateful to you guys. Thanks eibi and bosco_yip

Hello All, Trust you are all doing great. Very grateful for the help i received for the Matrix table. I am now working on a data set of which i require a function which will help me repeat the relevant NUMBER as and when i drag the formula down. With the data i have attached, the unique numbers...

Thanks Khalid, very grateful

Thanks Ninja for the revised formula Very much appreciated

Thanks so much eibi very grateful

Hello all, Trust you all doing well. Can i please get help with the table i have uploaded In the Table, i have Row and Column labels, of which i have figures in them. i want summarize the table by the unique labels. Thanks for the anticipated help

Thanks Like M.I will look up the links you have provided. Once again thanks

Hello all, I am back pleading for help on my question submitted. Waiting patiently, please help thanks O.

Hello all, Trust you are all doing very well. I have a central workbook which i will call Master. I have other workbooks which i will call,A & B In workbook A, a sheet named Cashbook will also be found in the "Master Workbook" And a sheet named Summary in Workbook A will also be found in...

:awesome::awesome::awesome::awesome::awesome::awesome::awesome::awesome::awesome::awesome::awesome::awesome::awesome::awesome::awesome::awesome::awesome::awesome: Thanks Nebu Works just as i wanted it. you have eliminated my crude way of generating the bills thanks once again, very much...

Hello, this is it 1.the setup sheet holds the ID's and names as when a pupil is admitted 2.the PRINTLIST sheet will pick the first 50 which is linked to the BILL sheet to be populated for printing 50 because i have just created 50 bill sheets to be printed at any given time when the PRINTLIST is...

Thanks Nebu, Its working good but i am having a challenge tweaking it to print the reports the way i want, so i am uploading a sample data file so that you cross check the VB for me the flow in the sample file is 1. first 50 to be copied to PRINTLIST, 2. then that 50 list feeds into BILL 3...