Can anyone please help me in choosing the suitable drug the case: patient A is suffering from hypertension & Kidney disease Drugs: Classified according the
We have an Excel 2016 quoting tool that uses VBA code to compare the product codes entered against an Access database and then update another sheet with the det
I have some code in VBscript that creates an excel object and adds a workbook to it Dim oExcel, oWB Set oExcel = CreateObject("excel.application") Set oWB =
I was just wondering: It is possible to create a click button in VBA Excel that opens the VBA editor when the button is clicked? UPDATE: The p
I am trying to simultaneously read from one sheet and print to another sheet, with additional format. I think my issue has to do with improperly referencing the
I am looking to send meeting invitations for each row in a worksheet. I am able to create an item that when displayed shows as an appointment, not a meeting re
I am new to macros and am having trouble creating a macro that will copy a range of cells and then paste just the values back into the same cells. Basically I
I have an exported xlsx file from c# (through angular).The Properties name which I want to be the columns header change in excel!( the first letters are changed
I have a dataset in Excel which I have imported in SQL Server. Is there a way in which when I make any change in the Excel data set like add/remove/edit rows or
I need to replace or substitute the first instance of a single text character in an excel row. current: B01 TEST TEST TEST A W B 0 A expected result where first
In this example, I have two columns of data: Date and Quantity. Example: (See Screenshot Link) What I'd like to be able to do, with an excel formula (if possibl
I have now twice had this error, where I email a spreadsheet with macros to another person. It is working when I send it using share via email. When they get
I have a workbook - lets call it Book1 Book1 contains 5 worksheets; Sheet1, Sheet1A, Sheet2, Sheet2A, Summary Within the Summary worksheet there is a table whic
I'm trying count number of values from another sheet into column O which has same system name as column B and more than Zero. Could you please let me know the b
Microsoft has web pages showing the local prices for Windows in over 200 countries. For each country, there are separate web pages for Windows Pro, Windows Home
I have a workbook that is about 8mb with about 20 different API calls (via formula in cells) using a 3rd party service. Everytime I try to close the workbook,
I have a spreadsheet that many people need to access (on sharepoint), for a few reasons, we need to do this locally (synced). however, there are constantly prob
I am trying to embed Python into an an XLL to allow Python functions to be called within Excel. An XLL is a DLL that also includes at a minimum 2 functions that
I want to use COUNTIF function to evaluate how many items out of 2,0,0,5 are greater than 2? In Countif function, first argument is range and second is criteria
I currently have the following code, which was made by a lovely member here Sub YearsNumberReduction() Dim LastCol As Long Dim DelCnt As Integer DelCnt = Sheet