I have a workbook with about 30 pages. I'd like to extract two cells from each of the 30 pages without manually typing (or clicking) each cell on each page. When I select all the sheets and click one of the cells, then try to 'paste special", it gives me an error.
Is there an easy way to convert a 3-d range to a 2-d range?
Is there an easy way to convert a 3-d range to a 2-d range?