Excel form writing filled data to another Excel file or sheet

Hello G.Bregvadze,

Short answer - yes, it is easily done, but you need to post the workbook.

Regards,

David

Hi David,

I will post it today and with a sample data. thank you

So as was written the idea is to send the filled in data on "INFO" sheet, and when Submit button is hit the data must be
send to "BASE" sheet and written to appropriate column.

The column titles on BASE sheet and cell titles on INFO sheet match.

Please contact for any details needed.


Sample file:

Excel Form.xlsx

GB Submit Form.xlsm

Hello GB,

I have attached the following macro to your button!

Please Login or Register  to view this content.

It looks through rows 9 to 12, and any row with something in it (other than the number in column A) causes a row to be written to the Base sheet. It then clears the data from your form.

I hope this is what you're after.

Regards,

David


When you reply please make it clear WHO you are responding to by mentioning their name.

If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Hi david,

This is what I needed, thank you for your help and support.

But i have one quesiton, Can we add a validation code, which will check the Private Information row, whether if one of the cells is not filled, retunr error and not send the data to base sheet.

Hi GB,

I've added a few lines of code to the macro - shown in red. Should solve the problem!

Please Login or Register  to view this content.

Regards,

David


If this has been of assistance, please advise. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Thank you very much again, you helped me a lot the code works perfectly. Thank you.