Just wanted to say hello to the forum. I've never posted before, but I have read several forums in the past as I work on spreadsheets quite often.
I wanted to see if anyone knew of an efficient way to split a worksheet into multiple worksheets based upon column content. I've searched the web and I haven't been able to find any content that helps me directly.
I would basically have unique accounting codes in "Column A" and all the content under that accounting code would then go into a new worksheet ideally. I have over fourteen thousand lines of data so doing it by hand would be time consuming.
This spreadsheet would just contain raw data. It wouldn't have spaces anywhere and it isn't formatted in any way. I didn't attach the spreadsheet because it's pretty basic. I can certainly do that if it is necessary.
Any suggestions out there?
Thanks in advance!