|We would need to know a little bit about the layout of your sheet before we could offer any suggestions.|
For example, what do you mean by "...have it populate to the next record"?I
Is this a one time thing or something you need to do on a regular basis? If it's a one time thing you could simply sort by your companies, use the Move or Copy feature to replicate the sheet and then delete the companies you don't want from each sheet.
If you are going to post any example data, please click on the following line and read the instructions found via that link. Thanks!
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.