Hello all,

I have developed many Access applictions but am now in a situation where my
client wants to work only in Excel (Office 2003) where I haven't done much
programming.

I have an application where I need users to enter data into a table located
in a data entry tab. This table is also a dynamic range and is the source of
a pivot table. On a separate tab (the report tab) I am using GETPIVOTDATA
functions to display the data from the pivot table. I have a simple macro
that refreshes the pivot table after the users enter data (run by a command
button).

Here is what I'd like to do: I'd like the users to be able to enter their
data from a form they can access from the report tab (click an "Add New
Record" button to pop the form). When they complete an entry I'd like to add
that record to the next row of the data entry table then refresh the pivot
table. This way the users can work in only one tab and not have to even be
aware of the data entry tab.

Does anyone have anything similar running or a link to a source that could
quickly get me up and running on how to do this?

Thanks in advance for any direction you can provide.

--
Scott S

hi
excel has a built in form to do this. in xl03 it's dataforms
in xl07, you have to got through options to add a icon. not really sure.
but if you want to add a custom form with command button then you could put
code like this behide the command button.
Private Sub CommandButton1_Click()
Range("H1").End(xlDown).Offset(1, 0).Value = TextBox1.Value
Range("I1").End(xlDown).Offset(1, 0).Value = TextBox2.Value
Unload Me
end sub
i'm sure you would have more than 2 text boxes so add what you need.
you can also check this site for some general knowlege about xl forms. it's
a lot like access.
http://support.microsoft.com/default...b;en-us;829070

regards
FSt1

"ScottS" wrote:

Hello all,

I have developed many Access applictions but am now in a situation where my
client wants to work only in Excel (Office 2003) where I haven't done much
programming.

I have an application where I need users to enter data into a table located
in a data entry tab. This table is also a dynamic range and is the source of
a pivot table. On a separate tab (the report tab) I am using GETPIVOTDATA
functions to display the data from the pivot table. I have a simple macro
that refreshes the pivot table after the users enter data (run by a command
button).

Here is what I'd like to do: I'd like the users to be able to enter their
data from a form they can access from the report tab (click an "Add New
Record" button to pop the form). When they complete an entry I'd like to add
that record to the next row of the data entry table then refresh the pivot
table. This way the users can work in only one tab and not have to even be
aware of the data entry tab.

Does anyone have anything similar running or a link to a source that could
quickly get me up and running on how to do this?

Thanks in advance for any direction you can provide.

--
Scott S

Thanks for the quick response. I'll check this out.
--
Scott S


"FSt1" wrote:

hi
excel has a built in form to do this. in xl03 it's dataforms
in xl07, you have to got through options to add a icon. not really sure.
but if you want to add a custom form with command button then you could put
code like this behide the command button.
Private Sub CommandButton1_Click()
Range("H1").End(xlDown).Offset(1, 0).Value = TextBox1.Value
Range("I1").End(xlDown).Offset(1, 0).Value = TextBox2.Value
Unload Me
end sub
i'm sure you would have more than 2 text boxes so add what you need.
you can also check this site for some general knowlege about xl forms. it's
a lot like access.
http://support.microsoft.com/default...b;en-us;829070

regards
FSt1

"ScottS" wrote:

Hello all,

I have developed many Access applictions but am now in a situation where my
client wants to work only in Excel (Office 2003) where I haven't done much
programming.

I have an application where I need users to enter data into a table located
in a data entry tab. This table is also a dynamic range and is the source of
a pivot table. On a separate tab (the report tab) I am using GETPIVOTDATA
functions to display the data from the pivot table. I have a simple macro
that refreshes the pivot table after the users enter data (run by a command
button).

Here is what I'd like to do: I'd like the users to be able to enter their
data from a form they can access from the report tab (click an "Add New
Record" button to pop the form). When they complete an entry I'd like to add
that record to the next row of the data entry table then refresh the pivot
table. This way the users can work in only one tab and not have to even be
aware of the data entry tab.

Does anyone have anything similar running or a link to a source that could
quickly get me up and running on how to do this?

Thanks in advance for any direction you can provide.

--
Scott S