I'm writing a macro that takes a master file, takes a list of sales people, and for each sales person (RSL) creates individual copies of the master file and edi
I need to find consecutive days from the data frame but I am having some trouble trying to find them. I tried R, Excel, and Python but still couldn't find the s
I had build rapidpro flow manually till now , now i want to automate it . What i want to do is convert a excel sheet (provided to me by my organization ) to jso
The following are 3 tables I have in my excel file. Gender Participants (n = 200) % Female 160 80 Male 40 20 Area Participants (n = 200) % Rural 80 40 Urban 1
I was not looking at VBA for a while, and I would really appreciate your help. Private Sub EvaluateButton_Click() Dim r As Long Dim x As Long Worksheets("tests
With some of the success of other automations, I am looking to see if it is possible to move rows of data from my excel workbook into a new one based upon the v
Im working on a excel script, that will import a CSV file, analyse the result and create a report based on the analyse. The CSV file contain up to 12 measuremen
What does the statement Selection.QueryTable.Refresh BackgroundQuery:=False do in excel macro? Does it disable background refresh for the selected table?
I have some conditional formatting together with a module, that for some reason prevents my macros from running all the way through. =NOT(TestColor(E8)) is my c
i know this question has been asked many times , i have read through the answers of previously asked question however im still not getting how to open the file
I am using the below code to: Delete the similar rows, keeping only one and combine cells values in the range "N", separated by vbLf it works ,but with big rang
I would like to preprocess (lower case, remove stopwords, lemmatization, remove punctuation ecc...) the text contained in the cells of a column of an excel file
I'm trying to mimic Lighthouse performance calculator but I don't know the formula for it. Say the weighted percentage from their website is: FCP : 10% SI : 10%
I am after a way to pull a consistent group of rows with an equal spacing between each. Example: My data range is in A3:A250. I'd like to pull A3:A10,A15:A22,A2
I am currently working on a Word-document I want to use as a template. This template provides a "structure" including many bookmakrs. The template is filled usi
I am using code on Outlook to hide the mouse cursor on Outlook before opening the attached workbook: Private Declare Function ShowCursor Lib "USER32" (ByVal fSh
I used xlwings to open excel workbook. It worked fine up to last month. But today, when I run the same code, it opened my worksheet but convert my worksheet nam
I use a MS Form to collect Data and use an xlsm.file where I copy the new data and then further work with the data. In order to update the data, I have to Open
Please help me with the code to insert a column in excel using vba. Here is what I am doing - Sheet1.Range("A:A").EntireColumn.insert
When running automatically via Workbook_Open, it throws a 91 error. However, running the same code manually does not. It's machine specific. No problems on a
elasticsearch-watcher