I am trying to create a table using lookup(the lookup table has 20 columns and in excess of 4000 rows)
I have a lot of zero's or blanks being returned to me which creates a table just as big as the lookup table. Have tryed a pivot table then a lookup but there are too many columns for it to cope with.
Help - am no good at macro's!!
I have a lot of zero's or blanks being returned to me which creates a table just as big as the lookup table. Have tryed a pivot table then a lookup but there are too many columns for it to cope with.
Help - am no good at macro's!!