Forum Discussion
inserting new lines
Hi Sergei,
Thanks for your reply. However you have to go slow with me :). I´m not an expert on excel.
For example, the picture that you have sent to me where can I find those settings? On the File Tab? And what you men by structured references? Sorry if I´m bothering you with my questions.
Attached is a sample of a table about what I'm looking for. If I give the table with just one line asking a user to fill it (the yellow lines) as soon is starts to fill it, a new line will be created by carrying the formulas (grey cells) to the new line being created. Grey cell will be protected.
Thank you again.
Hi Jose,
If you are on Excel 2007 or any later you may create the table, here is how
http://www.excel-easy.com/data-analysis/tables.html
Within the table you may use refrence on column name instaed of refrence on cell address, here is how it works
In your case the table could look like
and the formulas within it will be
=NETWORKDAYS([@Start],[@End]) =[@End]-[@Start]-[@[Work day]]+1 =[@[Work day]]+[@[Non-Work day]] =[@[0800-2000]]
Mentioned setting shall work by default, you may find them at
File->Options->Proofing->AutoCorrect Options->AutoFormat As You Type
As soon as you enter any value into the cell under last row of the table the table row with formulas if any will be added automatically.
In the attached file is the sample in next to your sheet
Sergei,
Once again thank you very very much.
One more help please.
I haven't yet understood what is the "mechanism" to trigger the creation of the new line. On the new sample I'm sending you the cells "Event" should be the one trigering the new line. However, the content/value of that cell (text) is not used for any formula.
Again the grey cells will be locked for edit from end users.
Thanks
Jose, i missed the protection. Yes, to unprotect for new column you need the macro. But in any case better to use Tables.
I'll update your sample in a while.
- Thanks