Hello- Very new to VBA here and very stuck! Any help will be greatly appreciated.
I have a workbook with several different sheets (individual coverage) and one Master of all sheets combined. On the master I have Columns with Name, employee ID and 8 different coverages. Each sheet is for each individual coverage the employee is signed up for. I am trying to find a way that each time an employee is signed up for and added to the Master sheet, each coverage option amount they enroll for along with their name and employee ID is copied over to the appropriate sheet.
I have a workbook with several different sheets (individual coverage) and one Master of all sheets combined. On the master I have Columns with Name, employee ID and 8 different coverages. Each sheet is for each individual coverage the employee is signed up for. I am trying to find a way that each time an employee is signed up for and added to the Master sheet, each coverage option amount they enroll for along with their name and employee ID is copied over to the appropriate sheet.
OCSB Billing Remit to Payroll_Working_F.xlsx | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
1 | Name | EE ID | AD&D | Cr Ill Ins | Dental | D C Sp Acct | H C Sp Acct | L T D | S T D | AD&D | VISION | Vol Acc | FlCred | Total EE Cost | ||
2 | John | 123456 | $ 5.00 | $ 5.00 | $ 6.05 | $ 16.05 | ||||||||||
3 | Jane | 458972 | $ 1.00 | $ 500.00 | $ 501.00 | |||||||||||
4 | Bob | 8587452 | $ 5.00 | $ 7.00 | $ 8.00 | $ 20.00 | ||||||||||
5 | Austin | 894646123 | $ 5.00 | $ 5.00 | ||||||||||||
6 | Ruben | 5465612984 | $ 7.00 | $ 8.00 | $ 15.00 | |||||||||||
7 | James | 45813464 | $ 7.00 | $ 5.00 | $ 12.00 | |||||||||||
8 | Lisa | 48648 | $ 9.00 | $ 6.00 | $ 15.00 | |||||||||||
9 | Ashley | 4874816 | $ 8.00 | $ 8.00 | ||||||||||||
10 | Laura | 5897897461 | 8 | $ 8.00 | ||||||||||||
11 | $ - | |||||||||||||||
12 | $ - | |||||||||||||||
MASTER |
Cell Formulas | ||
---|---|---|
Range | Formula | |
N2:N12 | N2 | =SUM(C2:M2) |