Hi KwithanE,

You could use a data form to do what you are asking.

Click Cell A1, assuming that is your header row, then in the windows
menu click Data/Forms. Should give you a box to input your data.

If you are wanting to creat a command button to prompt a data form to
appear on the same or different page you can click on
View/Toolbars/Control Toolbox.

Click on the command button icon and place it on the worksheet you want
the button located on, Right click that button and select view code and
insert this.


Code:
--------------------

Sheets("Sheet1").ShowDataForm

--------------------


Change sheet1 to the name of the sheet you have the data on.

If the new page is just for viewing, you can just reference the cells
you want to see. =sheet2!a1, =sheet2!c1, =sheet2!d1, etc....... skip
the columns you do not want to view.

Another option would be to create your own userform.

Tools/Macro/Visual Basic Editor

This you will need to know code for.

Larry


--
keithl816
------------------------------------------------------------------------
keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287
View this thread: http://www.excelforum.com/showthread...hreadid=498360