I have a sheet with data per item on lines like this
fruit color number
apple green 2
banana yellow 3
I want to copy each line on that sheet to columns on their own sheets
fruit apple
color green
number 2
its not simply all lines straight to columns, sometimes there are blank lines in between or it goes to a different column.
I have code that will search a column on the data sheet for, for example number 3, and put everything on that line in the right place in a template. User can print it and search for another item. But I would like them to be able to either put all lines to separate templates (using a column with unique numbers) and create new subsheets for each item. Or to just click on next and automatically the next line will appear in the template.
is there anyway to accomplish this?
(btw I also have code that will make a sheet for each unique item. For example if I have different colored apples it wil create a sheet apples with the different lines on it.)