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

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

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

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

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

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

Hello All, I got this code which is working very very well. But i want to edit the code such that it works from the worksheet instead of This workbook where the locking applies to all active sheets. What i want the code to achieve is to apply it to just two of the worksheets in the workbook...

Hello all, I am developing a data entry system and i want it such that when the user types a complete record,that record gets locked and can be changed by only passing an adjustment in the next available row. I have taken care of the adjustment and i want help with the locking of the record...

Hi all, I will want help with summing a dynamic range after i have used advanced filtering to query from a database to another worksheet in the same workbook. This is what i mean, when we query a database, depending on what you are looking for, the data could be more or less.Now weather it is...

Hi all? ope u all good. I need help with Validation autocomplete. i have tried the examples from contextures but to no avail.can anyone help. Thanks

Hi all, I will want to record a macro such that it allows me to use the custom autofilter to set up my criteria. i have gone thr the procedure to no avail. Can anyone help............. Thanks

Hi all, Last week i brought a pblm up for which Luke M sorted me out big time,it was under Title Offset, Index and match. the pblm was to bring out a list of contract nos when the destination was pkd. now my pblm is i have a third criteria to be met b4 the contract nos drop out. eg Column...

I have data which as contract numbers, destinations and quantity. I want to lookup a destination so as it returns all contract numbers that matches it. eg,if i look up london from the table and it has two or more contract nos,it should drop them out for me. I have used the combination of the...