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?
:confused:


--
maebeeso
------------------------------------------------------------------------
maebeeso's Profile: http://www.excelforum.com/member.php...o&userid=25306
View this thread: http://www.excelforum.com/showthread...hreadid=387920

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?
:confused:


--
maebeeso
------------------------------------------------------------------------
maebeeso's Profile: http://www.excelforum.com/member.php...o&userid=25306
View this thread: http://www.excelforum.com/showthread...hreadid=387920