Hello again
What I 'm wondering is if there is a way to count the
number of records that are added to a list on one sheet.
Ex. I want the Data Form from the Data Menu to open up.
If a user enters data on that particular sheet I want a
count done on the entries or deletion of entries,and then
due to those changes I would like to have a summary sheet
insert/delete a number of rows that coincides with the
number of entries or deletions on the original sheet.
Also is there a way to specify which cell on the summary
sheet the rows will be inserted at. The Text that is in
the cell that I would click on manually to insert the rows
at, is "Jan-04 Average" which is also always in the same
column but its row location will change as records are
added. I'm sure there is a way to search the
Summary/destination worksheet for that particular cell
value and then insert rows above that cell.
If there was a way to view the Data Forms code I'm sure I
could figure out a way to do this, but otherwise I've got
no clue where to start. Thank you everyone.