excel

Single sheet in .xlsm file into CSV

I have created an excel sheet which has already a macro-enabled to copy the data from sheet1 to sheet2.
I want to save only the sheet2 in a CSV format.
I tried this code
Sub saveAsCSV()
Application.DisplayAlerts = False
ThisWorkbook.Sheets…

VBA loop to populate Array

I’m looking at populating an array based off columns in an original Excel table.
I’m attempting to loop through to iteratively obtain each combination of fields, in order to populate into second Excel table subsequently.
Thus far i have po…

How to use Index + Match on excel VBA

I am trying to use the excel commands, Index and Match to perform a task, but when using it, I keep getting an error returned. I have stated both of my arrays in my code, but I can’t really seem to find out what the problem is here.

How to use Index + Match on excel VBA

I am trying to use the excel commands, Index and Match to perform a task, but when using it, I keep getting an error returned. I have stated both of my arrays in my code, but I can’t really seem to find out what the problem is here.