Search results

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...

Thanks Nebu. Its working fine, too fine.....:awesome::awesome: If i decide to change the print area to another sheet, i believe the PrintOut code will read like this; Sheet3.Range("A1:A" & c).PrintOut the reason for this is because i have set out invoices to be printed from that sheet with a...

Ok, Deepak I have uploaded a sample file thanks

Actually what i want to do is to pick the first 50 into the summary sheet and then print, after printing go in for the next 50 to the summary and print.... this is what i want to achieve Luke M

Hello all i hope you are all doing great. i have a challenge and i need you help. thanks My Challenge; i have a list of data starting from B2:b1500,holding the names of students.In another Sheet i have created a summary of which will pick the first 50 names from B2:B1500 and paste themin this...

Hi All, Please i need help to share a workbook to get my other colleagues do entries as i also do. Any help will be very much appreciated Thanks

Dear All, I am creating a list using a data validation. so far it suffices what i am doing. I now want to step it up such that i need not drop down the list, but when say the letter "A" is typed it will drop down all list that start with "A" or type "AD" and it also populates the list with just...

Brilliant,its working Deepak,i missed some steps. but it is working good. Thanks

still having problems,no data it runs to the and of the row

Thanks So much Deepak. It served my purpose Thanks once again

Hi All I am using this simple macro to pick the next empty cell,the challenge is that when there's no data in the cell the macro runs to the end of the row. I need help please... This is what i have. Need help Thanks in anticipation for a response Sub Inputss() ' ' Inputss Macro ' '...