lang

Hello, I need help consolidating data from a workbook with 31 tabs (individual staff members). The tab reports seat times online for teachers. Below is a sample tab. The sheet columns are shown in blue. The rows beneath the headers can vary wildly by teacher. I run some code and get a number...

Need help with sending multiple pdfs via outlook with VBA. I am using a workbook with multiple sheets. when I click on my macro in either sheet it will convert the excel file to a PDF. it will then prompt if I would like to send in email. if I click no it simply saves the pdf in the appropriate...

When a number is typed on a form I want to immediately check whether it already exists in the database. Can this be done through code? Also when my code is lang I want to display "Please wait..." and when my code finishes it should vanish. How to do it?

Please, I made a simple template to take grades of my pupils. In the templates, some subjects on a continuum are compulsory (H - K) while the remaining (L- P) are optional, but 2 of them (best 2 with good grades ) to be added to H-K to give the aggregate in Q as indicated in the table below...

Hi, I am currently working on a code in order to scrape data from a Company page in order to make a list of Projects available in Excel (as our programmers are too busy to implement this function directly). I combined several bits and pieces i found on the web, and it works like a charm, apart...