Hi all,
Thanks in advance. I have the below spreadsheets. I enter data into the input sheet and it moves to the data sheet and then clears the input sheet ready for the next data (that part works fine). What I would like to do from there is sort the data into the report sheet by standard category and then also into substandard category going vertically down the sheet. The standard category only need one entry say "standard 3" but there may be many sub standards like "3a, 3b, 3b, 3b, 3c etc. So each sub standard category would need to move in size (number of rows) as to not overwrite the next standard category. I hope this makes sense as is something that excel can handle. I have done a lot of research with no success.
Thanks in advance. I have the below spreadsheets. I enter data into the input sheet and it moves to the data sheet and then clears the input sheet ready for the next data (that part works fine). What I would like to do from there is sort the data into the report sheet by standard category and then also into substandard category going vertically down the sheet. The standard category only need one entry say "standard 3" but there may be many sub standards like "3a, 3b, 3b, 3b, 3c etc. So each sub standard category would need to move in size (number of rows) as to not overwrite the next standard category. I hope this makes sense as is something that excel can handle. I have done a lot of research with no success.