I i need two alteration in below code.
2:-formula should be copied in cell (a4) instead of (a1)
Dim s1 As Worksheet, s2 As Worksheet
Set s1 = Sheets("csales")
Set s2 = Sheets("statement")...
Hi All, I have an excel file setup with multiple teams of people. I have 1 tab with 1 dropdown list with the complete population of people. There are however 9 different teams. I'm trying to make a loop that will change the data validation list for each specific team, save the statement as a...