I have exported a csv list with start tine and end time. After that I have created a new column with the duration differences. How can I make the cell red for &
Since today, excel interprets the data of my xlsx file to add additional quote in the csv file. It's anonying since I want only one quote for some columns and n
I'm working on user-proofing a VBA app in Excel and I realized I'm constantly rewriting a lot of the same code to create specific error messages that are fed st
i created an office add in for excel (office.js / 365). The add in creates a sheet with a form. The user put values in the sheet, clicks on the button in the ta
I have an Excel sheet, where data is entered in this format: {"id":"03CD2B3C22558D83","imp":6667, floor:7777} How can I in python read and extract a certain va
this is my first question here and i can't find a solution that works for me. I have a set of data. i need to compare the date displayed in cell 2,2 (until 2,10
Currently using the following forumlas to count the number of records in all of column Z that does not have #N/A but it does not work. All the rows in Column Z
So I have made a macro to export a chart and then import it into a userform as picture. Import/export is working fince, byt the chart is not updating when the d
I am trying to upload a range of data in excel (same structure as target SQL table) to a table in SQL server using VBA. I do not want to loop row by row but tra
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