You can simply find the last row of your data as follows:
lrow = Sheets("Input").Range("A1").End(xlDown)
then you could write something like this
for i = 1 to lrow
Sheets("Output").cells(7+i,4) = Sheets("Input").cells(i,1)
next i
So, with this way, you...
Can you be more specific? For exaple how many diferrent value do you have for NAICS? After you group the average og employ by including NAICS you would like to continue grouping ALL the other variables? Do you mind your data to be arranged differently or it must be exactly like you have it? That...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.