make a button that will sort and send data to another sheet

[gjjnc]

Hi all,
This question is also posted in reddit
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.
Attachment 659850
Attachment 659851
Attachment 659852

[Pepe Le Mokko]

Administrative note

Welcome to the forum

missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[gjjnc]

Hi,
Thanks for that. I did try to post the workbook I started. it is 14MB compressed but the site said it was to large to process. it only has about 10 rows of data and some macros for the other buttons i want to use. Any suggestions on how to get it uploaded would be great. thanks.

[AliGW]

Strip out anything that is irrelevant to this specific query.

[gjjnc]

Hi, please find attached the smaller version.