I Want to customise automatically in Excel a Reference number according to the content of the line it is representing. I have a table for test procedure that lo
I have a PowerBi report with several data sources, SQL query and Excel connector. The SQL data data on our Products whereas the Excel is living data on salesper
trying to separate overtime and regular time into 3 cells. morning overtime, regular time, and after hours overtime in Excel. I go from site to site, and each w
In our organisation a problem occurs when saving Excel files. Whenever we close a file there is a 50/50 chance that it saves in the location it was already in,
I want to detect if text/values are being deleted from a number of cells that are not located adjacent to each other so I can execute a routine. As an example I
I have a SAP GUI script running every day in VBA. In the script I am exporting some data from SAP to several different Excel files, and these are saved to a net
My vba code connected to a button is crashing on runtime. It is stating sub or function not defined. I am new to vba code so I dont know how to solve this. It a
The following code populates ComboBox on a userform in vba with unique values. I use the same code to populate two other ComboBoxes. It doesn't work when the da
Using Office 365 Excel On a regular basis I download a csv file from a remote application, the file contains a column of unique numbers. There could be 50 rows
I'm trying to get the file list of a folder in VBA The DIR command acts as if the * wildcard is messing up the whole mask that I input. Here is my file list: No
I am trying to use Application.Match however it is returning a type mismatch error:13 error. Why? Dim mySrs as Series Dim ws as Worksheet set ws Activesheet Fo
Got a bit of a pickle. Trying to find the most used delivery company for orders in a specific month. Say the company was in Column A, and order date was in Colu
I have a subscriber list with emails and phone numbers. The row with the phone numbers are plain numbers (like 98734543). With format > custom > "+0;-0;0"
import numpy K = 1 Rmv = 26 SigS = 111.7 M = 2.050 N = 2 SigD = (-249.4) def Mittelspannung(): result = [] Y = [] SigM = [] for i in rang
I have this code and i find myself creating 12 times and modules since I have 12 different colleges, each with a unique names. I would like to make a bit more d
import pandas as pd data = pd.read_excel (r'C:\Users\royli\Downloads\Product List.xlsx',sheet_name='Sheet1' ) df = pd.DataFrame(data, columns= ['Product']) pr
For example, take input string _TXT from col A in file 1 and search in file 2 col X. If any row contains _TXT, then for that specific row compare col B value to
I have a table in a tab with columns: street_id, street_name, street_corner_1 and street_corner_2 (a street corner is the name of the street that intersects it
I'm trying to run a basic code I've found numerous places on here and elsewhere which should open SAP, input a command, and execute. I've gone as far as SAP ope
Hi all i hope you can help me with this issue since i just started learning VBA :) I need to autofilter a column of an excel sheet with the values coming from a