Forum

Difficult to know for sure without seeing an example file, but give this a try.   Option Explicit Sub UpdateTables() Dim monthNames A...

Try this.It will clear all data from the tables and add rows with A, B, C etc. It assumes there is only one table on each of the monthly sheets. S...

Or this to get rid of the "Exitsub" element of it. BSB Private Sub Worksheet_Change(ByVal Target As Range) Dim Oldvalue As String Dim Ne...

I'm not sure why you say the columns you want affected are E & F, yet your code is affecting A & D, however, if the below does what you need y...