[Rollin_Again]

I assume when you say box you mean cell borders?? Are you saying that you want the cell border to grow as new rows are added??

Regards,
Rollin

[napsterz]

exactly....and as i mentioned before, that iam zero with excel, i am not able to explain it in the right way.

So.........Sorry For That

[Rollin_Again]

Updated workbook attached.

Regards,
Rollin

[napsterz]

You Are The One...

And as i asked you before,Can me and my colleague use it at the same time. will there is any issues and worakround for that

[Rollin_Again]

Excel allows sharing of workbooks with the ability for multiple users to make changes at the same time. I've never had the need to do this before so I can't really advise on how well or effective it will work in this situation. You may want to create a new thread to see if others can offer advice on how to handle this.

Regards,
Rollin

[napsterz]

Sure Rollin, I Will Definitely Do That.......However i need to do some more things telated to this main form and final reports. I wonder whether i can continue with this topic or need to open a new one ?

[Rollin_Again]

If it's related to the main form and final report I would say just continue this thread. I'll help out any way possible.

Regards,
Rollin

[napsterz]

Hi Rollin,
I Was In The Phase Of Testing The Form And I Noticed That, Once The Record Exceeds More Than 300, It Takes A Long Time To Update When You Click On Save Data. So I Would Like To Know, Instead Of Saving Data To An Another File(Final Report.xls), Can You Make It To Save The Data's To The Last Sheet Of The Final Form Itself.

I've Altered Some Fields To The Main Form. So Iam Attaching The Updated Form

[Rollin_Again]

What is the name of the last sheet that the data will be saved to? Can you also include an updated copy of the MainForm sheet in addition to the FinalReport sheet?

Regards,
Rollin

[napsterz]

oops...It's My Fault That I've Attached The Wrong Excel File. Sorry For That. I've Attached The Correct File Now