I am trying to combine a couple of simple VBA Change codes but am unable to get both working at the same time. The one coded first works, the second doesn't.
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A:A,F:F")) Is...
I was wondering if anyone can help me.
I have below VBA ( that I got from another website) that goes through files in a folder and copy a range from all the first sheets and paste them one after the other in one master sheet. This is working, I just want the code to do this to all the...
I'm trying to automate a micro to collapse/expand certain cells in a spreadsheet as data is put in (i.e. if Cell A>0, then Cells B-F will expand, if Cell A<0, then Cells B-F will collapse). Currently, the code WILL do that but only AFTER clicking the A column. Below is the code I use, any...
I have 2 named tables of data, QtrDATA and YTDDATA. I have multiple pivot tables that depict summaries of both data sets. Instead of using 2 seperate for the mutlipe Pivot tables which grows the size of the workbook, I want a macro that will allow me to switch between the various data sources...
Having problems with VBA Code to do the following:
1. Check for Data Field "Report"
2. If Data Field "Report" Exist - Do nothing
3. Check for Data Field "Month"
4. If Data Field "Month" Exist - Remove
It may be simplier to remove all data fields and add the ones needed per DBA.