How can I insert a new sheet & have it populate the informat

October 24, 2013 at 08:32:23
Specs: Windows 7
On the first sheet I have the list of companies and their information. Now I would like for this information to populate to aseperate sheet in the same workbook. I would like to have a sheet for each company. How do I insert a new worksheet and have it populate to the next record

See More: How can I insert a new sheet & have it populate the informat

Report •


#1
October 26, 2013 at 06:55:03
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.


Report •
Related Solutions


Ask Question