Long Term Project - Creating scorecard with automation
Budget: $30 – $250 USD
First thing i want to do is link sheets together to fill out a table. The table also has fields that need to auto fill based off a another.
There are 3 sheets - Facilities Report, Supply Chain, Store Services. I need them to Populate automatically each time i get new data onto "MAIN TABLE". This consistently needs to then put their priority level and days to resolve from another sheet based off category. Anyway to avoid formulas would be great since this will ultimately go on pivot table.
There are 3 sheets - Facilities Report, Supply Chain, Store Services. I need them to Populate automatically each time i get new data onto "MAIN TABLE". This consistently needs to then put their priority level and days to resolve from another sheet based off category. Anyway to avoid formulas would be great since this will ultimately go on pivot table.