Hello,
I'm trying to create a macro which would pick up data from same cells of different sheets - all sheets contain same kind of data for different products. Products have different names and sheets are named based on product's name and I have summary sheet containing names of all products in workbook in one column (count of products in that column could be any number between 1 and 25). My idea was to pick up data from each product's sheet and paste it into new sheet so it can be stacked.
My question is: what would be the script which would select sheets by product names found in column B (from B2 to B25)? I presume a loop would do the job (B column, rows from 2 to 25) but I'm not sure how would I stack Row B and Loop value together to work.
Many thanks in advance.
I'm trying to create a macro which would pick up data from same cells of different sheets - all sheets contain same kind of data for different products. Products have different names and sheets are named based on product's name and I have summary sheet containing names of all products in workbook in one column (count of products in that column could be any number between 1 and 25). My idea was to pick up data from each product's sheet and paste it into new sheet so it can be stacked.
My question is: what would be the script which would select sheets by product names found in column B (from B2 to B25)? I presume a loop would do the job (B column, rows from 2 to 25) but I'm not sure how would I stack Row B and Loop value together to work.
Many thanks in advance.