vba code correction

In the midst of trying to automate a report and the final step is to take the 2 workbooks and copy all the data (excluding the header) from WB1 to the first empty row of WB2. The issue I'm having is that it when it copies from WB1 it will paste about 173 rows below the last row of WB2... not...

I have searched the internet tirelessly for an answer to this question that I desperately need more understanding on. What I am trying to do is create a macro that will take raw data on one sheet and put it into a pivot table on a new sheet - pretty standard procedure right? The issue is that I...

Hey all, Ive found some code on a forum elsewhere and tried to retrofit it solve a problem im facing with formatting. I need to insert a certain amount of blank rows based on a value. I.E: If the value is 3, i need to insert 3 blank rows below this cell. The code ive found works nicely, but...

My code referring to the colour of the trendline has stopped working. It was previously working fine, but now threndline is white. Sub AddDeals() ' ' AddDeals Macro Dim Wkb As Excel.Workbook Dim ws As Sheets Set Wkb = ThisWorkbook Set ws = ThisWorkbook.Worksheets ws_count =...

Greetings there, I have been trying to write code for a problem. Problem is: I need to insert some rows at 4 places in a worksheet at a time but at different ranges in same number. Like, I need to insert 4 rows at Range 12, 24, 30, 45. Every time, I will add rows at 4 places for sure but...

I was able to get this code for creating another pivot table. but this gives the error as " Application defined or Object defined error.. please check the VBA code as below Public w1 As Workbook Public w2 As Workbook Public w3 As Workbook Private Sub CommandButton21_Click()...

Hi there, I have a spreadsheet where there are three drop down lists at cells A13, A15 and C18. Based on the choices, certain rows will be hidden or not. What I am trying to do is if any of the three cells change, the VBA code will run. What I am finding is once a choice is made, if I make...

Hello, Thank You for giving me your precious time. I have following code to open new files through dialog box and add all sheets from them into current workbook. It is working fine as a macro but when I save it as Add-In and select multiple workbooks to open, it opens only sheets from one...

Hello all, <tbody> Schedule Details Impact Verification validation a 1 @ one y b 2 # two y c 3 $ three n d 4 % four n </tbody> The problem with the code below is it excutes the output for all the cells without validating the condition in column E. Any...