I have just finished constructing a database to keep track of three
different products - one sheet for each product, filled in by a
different person. Each product's info is captured on one row, about 40
cells from left to right. On each sheet the 1st product is located on
row 16. Each sheet has a maximum of 5,000 products (or rows). Each
products column headers are Identical. What VBA can I use to take the
data from each sheet and show it on a 4th sheet in its orgigonal form?
Any help with this greatly appreciated. Have torn out all my hair.