I have a code that searches Sheet1 ("Location") for certain criteria and populates Sheet2 ("Supply Usage Form") with that data. This works fine, after looping through all the rows on Sheet1, I need the code to loop through all the newly added data in Sheet2 for duplicates, combine the rows and...
Hello - I'm attempting to convert column data to row data. I currently have 16 columns and I would like to shrink this down to 6 columns. I have about 20 hours experience working with VBA and I'm stuck. Any guidance would be most appreciated.
The current headers and layout is as follows...
*Edit* sorry the title should have been:
Create as many levels of a loop as there are dimensions of an array
Sorry for the confusion!
This is somewhat difficult to explain, but please look at the following UDF:
Public Function ConcSep_Array(InArray() As Variant, Optional Sep As...