Data entry form

[blainepenn]

The data entry form adds the line of data to the bottom of the database
worksheet. What I'm wondering is if the data entry form can add it to
the top, so that the first record entry is at the bottom, and the most
recent listed at the top.

Since my intuition is that the data entry form cannot do this, I'm
wondering if I can have a data entry worksheet and program a macro or
some other method to have the database reversed on a different
worksheet. The boss wants to view the most recently added record at
the top of the worksheet, but someone else is entering the data, so if
I can at least get Excel to display a worksheet opposite of how the
data is entered, that would satisfy his needs.

Any ideas?

Thanks!

BTW, using Excel 2003 SP1.

 

[Crowbar via OfficeKB.com]

You are going to have to learn a little about VB first but this is what you
need to do

Access the VB editor ALT & F11

Create a userform and then add the required field for your data, do this by
creating a number of textboxs onto your userfom and stick a command button
onit.

Insert a code like this within the userform, to access where to enter code
double click the userform

Sub commandbutton1_click

Rows("1:1").Select
Selection.Insert Shift:=xlDown
range("A1).value = textbox1.value

end sub

I know its not much but it will give you a start

If you have any problems contact me at (e-mail address removed)




Within Excel create