Bpcs Projects
Looking for freelance Bpcs jobs and project work? PeoplePerHour has you covered.
Post an offer to educate them
Past "Bpcs" Projects
Updating VBA code calculating mappings from one sheet to another
1. There is a mapping happening Button 1, that one works 2. Button 2 (Old file) this one does not work, job update the mapping program from a VBA module that creates a mapping from one tab to another one, for the upgraded program Tab 2 (Fin exclusion) is executed to filter the accounts from Tab BPC detail to Tab Summary, and the program already creates the total. The program works in the OLD sheet, for some reason in the new sheet it does not work.
Updating VBA code calculating mappings from one sheet to another
Hi there is a MS Excel sheet with 3 tabs, and a few modules, the data is in tab 1, the mappings tab 2, and when the program reads the mappings from tab 1 the output goes to Tab 3. No idea why not working, it is a little complex, it is possible a mapping issue, but i cannot figure it out. 1. SOURCE data tab: BPC Finance One Upstream Detail 2. TARGET sheet: SUMMARY, click Step 3 button, MUST generate the table in Step 3, I am attaching OLD file that WORKS, vs NEW file that does not, we have to fix the NEW file. 3. FINEXCLUSION and MAPPING are read to calculate TARGET Summary I believe the issue is in the module MdlSummary, which is the one that creates the calculation of the Summary Tab, clearly the FIle with the NEW must work not the OLD, just in case.