software

I am trying to aggregate info from many worksheets into a snapshot view. I
need to copy various cells that have text in them so they display on the
snapshot. I can not get a formula function to do that. Help!

If you are trying to join text from varous cells into one, one way would be:

=A1 amp; A2 amp; A3

For spaces:
=A1 amp; quot; quot; amp; A2 amp; quot; quot; amp; A3

Not sure if that's what you were looking for.
Paul

quot;TRquot; gt; wrote in message
...
gt;I am trying to aggregate info from many worksheets into a snapshot view. I
gt; need to copy various cells that have text in them so they display on the
gt; snapshot. I can not get a formula function to do that. Help!
=a1
=sheet5!a1

--
Don Guillett
SalesAid Software

quot;TRquot; gt; wrote in message
...
gt;I am trying to aggregate info from many worksheets into a snapshot view. I
gt; need to copy various cells that have text in them so they display on the
gt; snapshot. I can not get a formula function to do that. Help!