Hello, I need to search my excel spreadsheet for a char value, then when this value is found I have to concatenate the 5 columns after this char, Once i have all this data I want to put it in another sheet in a specific spot.
ex take a1-a5 in sheet one and put it in to a5-a10 in sheet 2
MY problem is that different characters have different amounts of following columns
for instance if i search for A i need a1-a5
if i search for B i need a10-a20