code changes

Hi, I've been trying to get this done to analyze the data. However, I am unable to un-pivot this table. Could someone please guide me here? Input table- <tbody> A A A A A B B B B B WEEK MON TUE WED THURS FRI MON TUE WED THURS FRI 1 100 100 100 100 100 100 100 100 100 100 2 150 150 150...

I am using an Excel file to store primarily demographic data. I have two pieces of code imbedded in this workbook that allows me to use a Combobox to select demographic data and change to an abbreviation. For example Green -> GR, Purple ->PUR. The code has affected my ability to double click...

Hi all I am currently running the code below. However the bottom part runs before I am able to complete filling in the relevant cells so it prints the sheet to quickly. How can I stop this. Private Sub Worksheet_Change(ByVal Target As Range) If Range("C12").Value = "Yes" Then MsgBox...

Hello! I'm new to VBA and first would like to thank everyone posting codes that anyone can use!! I've found this very useful code to alphabetically sort words within cell separated by a comma. I'm wondering if i can tweak this to reverse sort? (Z-A instead of A-Z) Function StrSort(ByVal sInp...

I wrote a code to pull a table from a website. The website has a calendar feature and part of the web address can be edited to pull the correct table based on the preferred date. I tried to create a macro that deletes the current table, copies a cell for a new date, opens the code and pastes the...

The following code provides the srot of thing i am looking for However, this is comparing cell by cell, and where certain items are removed/added on the newer list it knocks everything out. Sub RunCompare() Call compareSheets("A", "B") End Sub Sub compareSheets(shtBefore As String, shtAfter...

I have been noticing over the past several days that changes in my code are not taking effect when implemented. When I try to put breakpoints in to find out why, those breakpoints are not being hit either. There is no chance that I am mistaken and something else in the program is causing this...