Hi everyone
Is there a way to use VBA to
1. Find a specific Column headers
2. Use IF statement for the whole columns with those specific headers instead of using IF/IFs function
3. Autofill result in a specific Column
I have 3 particular columns in a table that I use. I want to find Columns with Sales and Spend, set a number of conditions ( if Sales is equal to 0 and Spend is equal to 0 is just one of the conditions) and the result of the condition (i.e. 0 Sales, 0 Spend) will be in the 3rd Column Profit Loss.
The table we are using is a downloaded one and the template changes every few months so it affects the formulas. I was wondering if VBA can counter that problem?
Is there a way to use VBA to
1. Find a specific Column headers
2. Use IF statement for the whole columns with those specific headers instead of using IF/IFs function
3. Autofill result in a specific Column
I have 3 particular columns in a table that I use. I want to find Columns with Sales and Spend, set a number of conditions ( if Sales is equal to 0 and Spend is equal to 0 is just one of the conditions) and the result of the condition (i.e. 0 Sales, 0 Spend) will be in the 3rd Column Profit Loss.
The table we are using is a downloaded one and the template changes every few months so it affects the formulas. I was wondering if VBA can counter that problem?