info on 400 pageson to 1 report page
 

I am trying to get info from block A2 and F40 from each of 400 pages onto 1
report page in 2 columns. A2 is a part # and F40 is our current inventory.
Can anyone give me the formula to do this?

Thanks,
--
Kelly

info on 400 pageson to 1 report page
 

Maybe this macro is a option for you
http://www.rondebruin.nl/summary.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Kelly" wrote in message
...
I am trying to get info from block A2 and F40 from each of 400 pages onto 1
report page in 2 columns. A2 is a part # and F40 is our current
inventory.
Can anyone give me the formula to do this?

Thanks,
--
Kelly

info on 400 pageson to 1 report page
 

See your earlier post for a reply.

No need to post more than once on same subject.


Gord Dibben MS Excel MVP

On Wed, 21 Oct 2009 08:41:01 -0700, Kelly
wrote:

I am trying to get info from block A2 and F40 from each of 400 pages onto 1
report page in 2 columns. A2 is a part # and F40 is our current inventory.
Can anyone give me the formula to do this?

Thanks,