called

Hi all I am using Access 2016 and an ODBC link to an SQL Database. I have a form called "Search" which returns values into two sub forms ServiceUsersSearchList for current clients and TerminatedSericUsersSearch for former clients. The results show ClientID, Address1, Address2, Postcode from...

IF I know my workbook has a worksheet called Apples, I can refer to it as follows: With wb.Worksheets("Apples") ' Do something End With but I DON'T know for certain there's a worksheet called Apples because the user might change it. Instead I DO know there's a worksheet with a...

Hi, I have a workbook which contains 2 worksheets: 1 called MIPA and another called Dashboard Data. I am using Index Match formulas on several columns on the MIPA worksheet which refers to a named range on the Dashboard Data worksheet called Data (the data) and another named range called...

Hello Guys i have a big question. I need some help for VBA-Code. I have got a workbook with nine worksheets. All worksheets have the same structure. I would like to categorize these worksheets by adding the sheets. Those Worksheets called: Worksheet 1 = called T1 Worksheet 2 = called T2...

Let's say that I have to two subs: Sub subA()If (some condition)<some condition=""> is True Then</some> Call subB Else ' Some code End If End Sub Sub subB()'Some code End Sub Is it somehow possible to disconnect subB from subA once called? So that once subA calls subB, subA is ended while...

Hi Folks I need some highlighted cells to be deleted. The background to the problem is as follows. Excel needs to compare two ranges (teachers, abbreviated) called Total_Range and Educators_Invig) and highlights (or somehow identify) the cells (teachers) in the dynamic range called Total_Range...

Is it possible to create a formula which tells you the total number of working days (Monday to Friday) in between 2 dates? For example, I would like to have 3 columns with the first column called "Start Date", the second column called "Finish Date", the third column called "Working Days". In...

Hello All I'm trying get a piece of VAB code which when a "button" is pressed will jump to a specific worksheet based on the value in a cell on a different sheets. The button will be on worksheet called "Balances" the cell value will be in cell G1 on a worksheet called "Summary" and will...

VB code to go to the end of the column: In a Sheet called “Student data”, I have a column called “DOB” which is populated with a variable range of dates of birth of students. I’m unable to predict the number of populated cells in this column as the number of students in the capture will vary...

Hi Guys, I have 5 worksheets named as per below: Brecon Chepstow Chippenham Bath two Merthry one In each worksheet there is a column called 'Name'. I essentially want to filter by each name in that column and copy them all to one worksheet. For example, filter by Bethan in all of the 5...

Hello, I'm trying to find a formula that will help me find the intersection of a row and a column. I know that you can use Vlookup, or Index/match, or Sumproduct. In one sheet called SUMMARY I'm trying to find the intersection (the value) of a row called SALES and a column called Current...

Hi to all the members I have 7 sheets in my excel work book. Sheet 1 is called Cash Sheet 2 is called Cheques Sheet 3 is called Transfers Sheet 4 is called Online Payments Sheet 5 is called Bank Sheet 6 is called Data Sheet 7 is called Summary. In this sheet I have running down the columns...

I am working on a worksheet called "Index" and I want to take C8:H8 and copy and paste the content onto worksheet called "Warning." I want to go to the sheet called "Warning" and find the next empty row and paste. For some reason I am struggling to figure out how to find he next empty row...

Hello, I have a strange behaviour on my sheet. I start with bouton "Planifier" on second tab called "Feuille2" Then I enter user name Samia, select "Maladie" Type and add dates from 03.12.2018 to 05.12.2018 and press bouton "Ajouter" This action well add a record after the last line into...

Hi, I have an Access db, containing 1 column which has date information in it. The field is called Added. I also have a field called "Account No". I am wanting to create a query against the Added field to either: - Count all the Account No's where the Added date was Friday to Sunday, if...

Hi guys I have an Excel workbook that is saved in a folder. What I would like to do is have a VBA routine that loops through all the worksheets that are called 'Payment 1' 'Payment 2' to 'Payment z', export to PDF and save the individual sheets/ PDFs in the same folder as the Excel workbooks...

Hi All, I desperatly need help with powerbi. I am new to powerbi and I have 1 table with unqiue ids called headcount data and another table called survey data which has multiple ids. I have a relationship 1 to many from the headcount tble to the survey tble. I then have 3 filters:-...

Hi. Got a question. Is there a way to create a VBA code, that constantly checks a specific folder, if a new workbook is created? For it to be easy to understand, lets pretende workbook1 is called 1.xlsm (which im using), then if i create a book called 2.xlsm inside that same folder, i want to...

Morning, Not sure if this is possible but i would like to ask. Sheet1 cell P7 I would like the value to only be able to enter this cell from my combobox1 in N7 I do not want it possible to allow the use to type a value into this cell. Example Say you select from the combobo1 the selection...

Hello all, I have a question when using calculated fields in pivot tables. I have a set of surveys, where each number means either negative, null, or positive. What I want the calculated field to do is the following formula: (count of all positives - count of all...