Hi Toppers,
I mean if i entered 2 row values for "Entered" & "Entered By" and leave
empty for "Part", "Location" , "Qty", "Price", "Total" in [sheet PartsData]

then inside sheet [Input], i entered all fields right, the data capture
inside sheet [PartsData] will fall on row number 3 instead of 1.

Thanks.. hope u understand.

"Toppers" wrote:

You obviously want this work in a different way: can you post your w/book to
me as it is impossible to advise you without understanding clearly what you
are doing different?

In the original example, the whole of Input form has to be filled, so you
cannot only fill columns A & B. Are you saying you only want to enter the
"Entry Date" & "Person" once?

toppers <at johntopley.fsnet.co.uk

"kyoshirou" wrote:

http://www.contextures.com/xlUserForm01.html

i have realised that the sample above have some limit.
for example, if inside PartsData sheet, A2 and B2 has been filled,
and i go to Input sheet to insert new data, the newly data will be inserted
at A3 and B3.
Why is it so? How can i modify it?