Hello,
I Need a formula not a macro to help with this, I have tried SUMIF's and OR combination but am having issues,
My workbook as two tabs (1) Data (2) Template
Data Tab has in Col A - D and rows 1 - 7
I need formula to change the Cost Center and Account String based on this logic.
Template tab should show this in Col A - D and rows 1-7
Any assistance would be greatly appreciated and thank you in advance.
Regards,
Doug
I Need a formula not a macro to help with this, I have tried SUMIF's and OR combination but am having issues,
My workbook as two tabs (1) Data (2) Template
Data Tab has in Col A - D and rows 1 - 7
Journal Amount | Employee Last Name | Cost Center | Account String |
441.6 | Smith | 99-555 | 5-9-4-1355 |
38.23 | Smith | 24-500 | 5-9-4-1350 |
40 | Smith | 99-555 | 5-9-4-1354 |
7.54 | Smith | 22-700 | 7-9-4-1300 |
15.97 | Reed | 28-600 | 6-9-4-1300 |
37.61 | Reed | 98-555 | 5-9-4-1353 |
I need formula to change the Cost Center and Account String based on this logic.
If Cost center starts with 21, 24 - 30, 98 it will need to be changed to 99-100 |
and Acct String will need to be changed to 1-0-0-71xx (where xx = first two digits of cost center) |
Template tab should show this in Col A - D and rows 1-7
Journal Amount | Employee Last Name | Cost Center | Account String |
441.6 | Smith | 99-555 | 5-9-4-1355 |
38.23 | Smith | 99-100 | 1-0-0-7124 |
40 | Smith | 99-555 | 5-9-4-1354 |
7.54 | Smith | 99-100 | 1-0-0-7122 |
15.97 | Reed | 99-100 | 1-0-0-7128 |
37.61 | Reed | 99-100 | 1-0-0-7198 |
Any assistance would be greatly appreciated and thank you in advance.
Regards,
Doug