MarkMueller
New Member
- Joined
- Aug 16, 2018
- Messages
- 23
- Office Version
- 365
- Platform
- Windows
I'm, working on a workbook that has a Master sheet with about 26 columns and up to 5 rows. This spreadsheet is used to update 6 other worksheets of which are defined as tables. When the content matches the headings the cells below the Headings are updated (copied) from the content within the Master worksheet to the workbooks named below. In many cases there are not match's and in that case a Blank can be inserted.
So the Sheet names within the workbook are: INPUT (Master sheet), Sub, Cust, NewUser, StudentEnroll, Attributes, and Audit!
------------------------------------------------------------------------------------
Heading information from INPUT (Master) listed below: Table Name(INPUT)
Heading information from Sub: Table Name(Sub)
Heading information from Cust: Table Name(Cust)
Heading Information from NewUser: Table Name(
Heading Information from StudentEnroll: Table Name(Enroll)
Heading information from Attributes: Table Name(Attributes)
Heading Information from Audit: Table Name(Audit)
I hope that the above information will help. It has been some time since using VBA. Thank you.
So the Sheet names within the workbook are: INPUT (Master sheet), Sub, Cust, NewUser, StudentEnroll, Attributes, and Audit!
------------------------------------------------------------------------------------
Heading information from INPUT (Master) listed below: Table Name(INPUT)
First Name | Last Name | Student Email | User Role | Company Name | Mine Site Name | Location - City/Province/Region | Location - Country | Manager Email | Requestor Name | Requestor Email | Request Type | Course 1 | Course 2 | Course 3 | Course 4 | Course 5 | Course 6 | Course 7 | Course 8 | Creator Comments | DateProcessVerify1 | DateProcessVerify2 | Date Processed | CourseDesc | Course Code |
Heading information from Sub: Table Name(Sub)
First Name | Last Name | Job Title | Job Type | job Level | Local First Name | Local Last Name | Local Language Name | Student Email | Person Id | Phone | Mobile | Organization Name* | Active | Disable Invite Email | Manager Email | products(NewsArea) | parts(NewsArea) | training(NewsArea) | service(NewsArea) | brightspace user role(Inherited) | organization | distributor.User(Inherited) | organization2 | general Role(Inherited) | organization3 | kac General(Inherited) | organization4 | subsidiary General Role(Inherited) | organization5 | subsidiary.User(Inherited) | organization6 | user(Inherited) | organization7 | user(Inherited)8 | organization9 |
Heading information from Cust: Table Name(Cust)
First Name | Last Name | Job Title | Job Type | job Level | Local First Name | Local Last Name | Local Language Name | Student Email | Person Id | Phone | Mobile | Active | Disable Invite Email | Current Organization – Account# - Data Source | New Organization – Account# - Data Source(Mandatory for New Users)* | Manager Email | products(NewsArea) | parts(NewsArea) | training(NewsArea) | service(NewsArea) | brightspace user role(Inherited) | organization | distributor.User(Inherited) | organization2 | general Role(Inherited) | organization3 | kac General(Inherited) | organization4 | user(Inherited) | organization5 | user(Inherited)6 | organization7 |
Heading Information from NewUser: Table Name(
Action - IMPORT | Student Email | Blank | First Name | Last Name | Password | Role | Active (1 or 0) | Email Address / User Name | Course Code |
Heading Information from StudentEnroll: Table Name(Enroll)
Action - ENROLL | Student Email | Blank | Role | Course Code |
Heading information from Attributes: Table Name(Attributes)
LMS Username | Affiliated Org Units | Company Employee Id | Company Name | Cost Center | Department | Division | Employee Role | Hired Date | Language | Location | Manager | Region | Role Category | Team |
Heading Information from Audit: Table Name(Audit)
Action - CREATE | Manager Email | Student Email |
I hope that the above information will help. It has been some time since using VBA. Thank you.