Hi, I don't know if this is possible... just wondered if there's something like like this i can do.
I have a data entry form in Excel which then enters data into a database (see below)
I then have a form in which this data will be inputted.
What is the best way of automating this process?
I know you can create a mail merge (i've done this). Is it possible to create a button on excel in which automatically opens this form and enters the desired data?
I have a data entry form in Excel which then enters data into a database (see below)
I then have a form in which this data will be inputted.
What is the best way of automating this process?
I know you can create a mail merge (i've done this). Is it possible to create a button on excel in which automatically opens this form and enters the desired data?