The question I had today is whether the following process can be automated and if it is possible what is the best way to go about it for someone such as myself with limited knowledge of coding.
I've attached 2 files, the 1st one is named "Excel Data Cell" ("EDC"), which is the Excel s/s I enter tha data on, the other is "Access Data Entry" ("ADE"), which is a data entry screen in Access. What I would like to do is automate this process. I will use "ADE" and "EDC" abbreviations to distinguish the file names.
The following is exactly what I am trying to achieve:
1) First, I would like for this automation process to be able to pull up each file number seperately in the Access Database. The file numbers are shown in row 1, cell J-N, of the "EDC".
Once the first file is up (516115), I would like the following automated entries done for each file:
2)I would like the field directly next to the "Draft #" on the "ADE" field to be populated with the data entered on "EDC" Cell D7 (highlighted yellow)
3) I would like for the "Date Req:" and "Acctg Draft Date" fields on the "ADE" to both be populated with the data entered on "EDC" cell F3 (Highlighted black)
3) I would like for the "Amount" field to be poulated with the data entered in cell J7 (highlighted green)
4) For this spreadsheet I would like for Access to defulat to "Allocated Expense"
5) I would like for the "Payee" field on the "ADE" to be populated with the data entered in cell A2 (highlighted burgundy)
6) Lastly, I would like for the "Payment Reason" to list all invoices shown in cell D4 of the "EDC".
Bookmarks