Add multple types of data sequentially

The modification made to the first row will take care of your problems 1 and 2.
About your 3rd problem, it would help a lot if you could attach a sample workbook to yourpost.

Please Login or Register  to view this content.

Regards

Posting a picture is not that helpful, since we can't work directly with it, but I'll take a guess based on the picture.

If you only have a header row when you run the code below, then what is happening is the part before the equal sign is ending up in the cell below Sr. No. and attempting to place the value from the
right side of the equal sign. The problem is the right side of the equal sign is trying to add 1 to the text header "Sr. No."

Please Login or Register  to view this content.

Because you then stopped using the first line of code your second line of code is going back up to the header row and offsetting one column into col B and putting the value from your form in col B of the header row your next like of code is going into the next column of the header row etc. etc.

Thanks a lot Pierre, it solves problem 1 & 2. I have attached a sample sheet to get the help on date problem. Thanks!

Try this:

I changed the name of the calendar to dtCalendar, if you want to just use this code you need to do the same, or the file I attached has it already set up.

Please Login or Register  to view this content.

Thanks for the reply. I will check and update you on this.