Hi,

I have put together a xlsm that takes input from four tables (containing 1 column and 8 rows) on the input page and copies the data into separate sheets (in the same workbook) to keep a track of the data. It knows to copy the data to the next free row in the "data collecting" sheets and to then clear the forms on the frontpage/input page.

What I am trying to do is to get the input page to be on the web, is this possible?

I am an amateur when it comes to anything linked to VBA (it took a few hours to get the sheet to copy the data to the worksheets and hit the next clear row, just as an example). I know that an Access type solution would do the trick but that is beyond my capabilities.

This is a form that 4 people will submit data to/complete so I am looking for a solution that will ideally just let me convert the xlsm to html or similar.

Can someone help please?

Thanks,

Pete