I have one spreadsheet with a lot of data. I call this sheet "INPUT'', and every month or so I can copy and paste new data into that sheet (data comes from bloomberg so the same info will be shown in the same row again). Now I have row F in my INPUT sheet, and this row shows the names of all the different products that I have (for example all different kinds of assets), which are approximately 600 products (this can change every time I insert new data in the INPUT sheet). In row A,B,C,D etc there is more information about these products, such as price, transaction date etc. I would like to make a VBA module that makes it possible for me to make a sheet for all the different products that are shown in row F in the INPUT sheet, and that gives these sheets the same name as that product. To make it even more difficult, I would like each product name (which should be given to the corresponding sheet) to be shown in cel ''B3'' in every sheet as well.
