Feb 17 2023 01:09 PM - edited Feb 21 2023 03:04 PM
I have a workbook that produces 2 percentages when data is feed into it from another workbook. In this workbook I type in a specific cell the name of the workbook which includes a date. When I open this workbook the name I typed in, the data pulls into the workbook that produces the percentages. I am trying to create a formula that will pull the percentages and the date of the workbook name and place them in a calendar on the date as depicted in the file name that was typed in. The calendar is an excel calendar.
The attachment UnitAvailabilityDetails02_07_2023 is where the counts are coming from based on the category the info is in. It supplies the numbers that get feed into the Monday Morning Report workbook. The Monday Morning Report Calculation workbook is where the data feeds into and where the File Name resides that gets changed whenever a new UnitAvailabilityDetails report gets produced. The attached calendar is where I'm trying to get the percentages and date from the file name recorded to. This is the formula help I a looking for.
Can I get any help with this formula?
Feb 26 2023 03:10 PM
Feb 26 2023 03:31 PM
Feb 27 2023 09:22 AM