Need help with many things :D

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

Originally Posted by VBA Noob

Hi,

This should help with your numbering. Enter in A1 and drag down

=IF(B1="","",COUNTA($B$1:B1))

Take a look at data validation to control entries in cells

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

Try Data > Data Validation > Change allow to Number and entry your range

VBA Noob

Hey!

I tried entering your formula, but it didn't work. It says that the formula contains an error ... then I click OK to get assistance and I get this: IF(logical_test; [value_if_true];[value_if_false])

Now what ... I am an excel noob so ... HELP PLEASE! :D

VBA Noob

This works fine ... but just one more problem. This sheet that I am making will be used by other users and I don't know how many entries there will be. You specified the formula for 19 rows ... what if there will be 20 rows or maybe 50?

OK .. will do that. But could you just explain how? I am having problems with that, because I am a noob.

Nevermind! I already did it. One more thing. Counting should be in this form: 1. 2. 3. ... how to add . at the end?

Hmm ... this puts . everywhere not only in the lines with counting.

So if I set the formula for 500 cells .. there will be 500 cells with .

Thanks, you are the greatest!

Is there any online documentation or anything where I could get to know more about programming in Excel?

The books in our library don't have anything about this ...

I am back!

I've been editing my sheet for some time now ... just a few more things and I'll be done. But there is just one thing bothering me. This stupid line appeared on first column and I can't delete it. I've tried to delete it in borders but it won't work.

Check the attachment to see what I am talking about.

Anyone?