Hey All,
I have a form that allows a user to input data directly into the original table. The original data was all in excel documents, and all the sheets have been imported. I have just recently been told that the data in a specific field B was originally based off a sheet (that i have imported.) The request is to use a number identifier to then update the columns automatically.
So hopefully to clarify: Field A in Table 1 refers to data in Field A in Table 2. The data from Field B (in Table 1) comes from Field B (in Table 2) based on the number from Table 1 Field A and its corresponding Field A in Table 2... Is there a way to do this via VBA. I'm way out of my depth with this!
Thanks
Tim
I have a form that allows a user to input data directly into the original table. The original data was all in excel documents, and all the sheets have been imported. I have just recently been told that the data in a specific field B was originally based off a sheet (that i have imported.) The request is to use a number identifier to then update the columns automatically.
So hopefully to clarify: Field A in Table 1 refers to data in Field A in Table 2. The data from Field B (in Table 1) comes from Field B (in Table 2) based on the number from Table 1 Field A and its corresponding Field A in Table 2... Is there a way to do this via VBA. I'm way out of my depth with this!
Thanks
Tim