creating lists

I need some direction in creating a worksheet. I have a form (which I have created beautifully) which has information in it that also needs to go into another sheet. For example Contact Name, Phone Number etc. I want to be able to add info to the form then for that information to automatically update another sheet which will just be a list of the selected cells that can be printed all on one page. Make sense?

Go to second page, select the cell, hit the equal sign, click on the other
worksheet and select the cell to be copied and hit enter.

Once you have the first cell you can do the whole column or row. Go to the
second sheet, reselect that cell you just made. Highlight down or right the
number of cells to copy over, hit control d for copying down, hit control r
for copying to the right.

"maebeeso" wrote:

>
> I need some direction in creating a worksheet. I have a form (which I
> have created beautifully) which has information in it that also needs
> to go into another sheet. For example Contact Name, Phone Number etc.
> I want to be able to add info to the form then for that information to
> automatically update another sheet which will just be a list of the
> selected cells that can be printed all on one page. Make sense?
>
>
>
> --
> maebeeso
> ------------------------------------------------------------------------
> maebeeso's Profile: http://www.excelforum.com/member.php...o&userid=25306
> View this thread: http://www.excelforum.com/showthread...hreadid=387920
>
>