I have a workbook that contains several different sheets. I am trying to
wite a looping macro that will take values and labels in two different
columns, copy them to an area on another spreadsheet clear the source data
and got to the next blank on on the destination sheet. Entry into proper
place is dependant on a category #.

Any help is appreciated