Query related to VBA with formula

Excel If you know anything about VBA already, then you are going to have to declare 5 array variable(s). For example, when you declare your DIM statement, here are the variables that I would declare:

Dim varDept as String()

Dim varEmpID as String()

Dim varFName as String()

Dim varLName as String()

Dim varPayRate as Currency()

Then, later, you will have to use the ReDim statement to walk through the columns on your Data spreadsheet and then read the values into each of the above declared array variables. You will require a loop variable to walk through each row.

After you have read the data into these array variables and have them stored in memory, you can then choose to output them to your other worksheet.

Thanks