Hello!

This is my first post on this forum and I hope I'll find here all the help needed! This is VERY important for me. My boss is expecting me to finish this week. I am not really an expert in Excell but I have to do some pretty complicated things. At least they are complicated for me.

OK ... here we go!

I have a worksheet with 8 columns or topics.

1.) the first column is supposed to count from 1. to xx ... depending on how many entries there will be. It should automatically create a new line (with borders) after you finnish with previous line. For example when you start writting data in the next line it should automatically write a following number ... if you finnish in 8. then the next should be 9.

2.) In column 2 should be numbers from 1 to 1.000.000 and if anyone enters a different number there should be some kind of a warning. This column is also obligatory so you can't enter any other data in any other column. First you have to enter data in column 2

That's all so far ... but I am sure I will have some more questions about this one.

I hope you all understand what I am trying to do and that this is all possible. I would really appreciate if someone could help me out with this one.

Thank you all!

E