Excel 2003 - Combining info from several pages to one page
I have a 400 page spreadsheet and I just want the info from box A2 and F40
from each page to appear in two columns on a seperate page. A2 on each page
is a Part # and F40 is our current inventory. Does anyone know the equation
and how to set up this 'all' inventory page?
Thanks,
--
Kelly
|