I am trying to extract data from different sheets in a summary sheet. The referencing does not work. Sub Summary_LPI() Dim wkSht As Worksheet, wsC As Workshe
I want to replace a repeating year of dates in a column. I started with a nested for loop in a single module, then I changed the code to be used for each sheet
I have an Excel spreadsheet that contains information to be put into a Word invoice template. I am able to populate header details, such as client name, address
Trying to add a border color to all tables in Powerpoint and failing. I'm not very good at this. Sub SetTableBorder() Dim oShp As Shape Dim oTbl As Table Dim oS
So I am trying to write a VBA Macro in Excel that will loop through all 400+ .pdf files I have in a folder, extract pertinent data from them, and store that dat
I have this data table that updates everyday with new data and the pivot table and slicer refresh automatically through a macro. Now, I wanted to write a macro
In a worksheet I would like to copy and paste columns with a button. It should copy two columns and insert them in the first free column that it can find. For e
I want the user's name and the date to be entered into a specified column when any change is made. I also have a snippet of code that forces any data that is pa
I'm trying to trim any combination of a webname to just web.co. Example 1.htt:pubhorn.co 2.www.pubhorn.co 3.htt://pubhorn.co 4.pubhorn.co/awawa I want to outpu
I have a raw data sheet and am trying to process nps scores from the emergency department (ANE) versus all others. I am counting the values and transferring the
How do I put default values on my dropdown? I tried view code but I'm not sure how to or what codes should I put in there. I tried DropDown7.List = Array("Link
I have a simple macro that returns the date of the last save of the current document: Function LastSavedTimeStamp() As Date LastSavedTimeStamp = INT(ActiveWor
I'm trying to go through a list with two columns and replace some of the text in the second column. I want to search for values using wildcards in combination w
I am trying to find and replace the column name. I want to loop in the first row only but my code loops the entire sheet. Dim sht As Worksheet Dim fndList As V
I am trying to copy and paste data from horizontal to vertical from sheet1 to sheet3 in a lots of 200. Say I have a list of 600 tickers. The code will copy the
I have two items in ComboBox1, one is Cardio Only and second is Gym Only. I want to auto populate Renew Date in TextBox8 based on Combobox1 selection. e.g. If I
I have this awesome vba macro that takes a template xlsm file saved on a shared drive and automatically uploads the file saved as with tomorrows date in the tit
I'm trying to send data from excel spreadsheet to sql server. The code runs properly but the change of status is not done. Before those steps, I already added d
I have to migrate a web automation program from IE controlled by Excel VBA to Chrome using selenium basic in Excel VBA. The website itself is not public so I ca
My code runs a model in R directly from Excel. I want to simplify installation so instead of: path = """C:\Program Files\R\R-4.1.1\bin\Rscript.exe"" C:\Users\di