I have a number in cell L1 (copied from a different sheet as I can't get vba to reference a cell on a different sheet) and my data is in a table from F to BE, starting at row 4 with headers in row 3.
Everytime the worksheet activates, I need it to clear F4 to the last row of data to whatever column header matches the number in L1.
I've been trying for ages but I cannot get my head around VBA's. Can someone help?
Everytime the worksheet activates, I need it to clear F4 to the last row of data to whatever column header matches the number in L1.
I've been trying for ages but I cannot get my head around VBA's. Can someone help?