Real new to macros in Excel. I created a form which multiple users complete. Data from the form is linked in a hidden tab and then a macro Push() on event before closing the form unhides the tab-copies the data- opens the master database- inserts the copied cells- saves the master database-closes master database-returns to the form and finishes closing.

Situation is- I dont need multiple sets of the data as currently happens- I only need it to copy and paste links if no data exists for that particular job. Job# being the key identifier.

Job Process Control Form2D.xlsmProcess Database.xlsx

Please Login or Register  to view this content.