Forum Discussion
Wimberly5
Dec 11, 2023Copper Contributor
workbook formula no longer carrying to the assigned pages
Hello It seems i have exhausted all other options in the search for the answer to why all of a sudden the workbook I'm working in is not carrying the formulas to the allotted pages. there is a m...
- Dec 11, 2023
Detlef_Lewin
Dec 11, 2023Silver Contributor
Wimberly5
Jan 02, 2024Copper Contributor
Detlef_Lewinhello again! and Happy New Year!
i have a question about extending the formula to exceed row 279 as to use for entire calendar year. i've changed the formula but it is not working. should i ask a new question or leave the question here? I've attached the file.
- Detlef_LewinJan 02, 2024Silver Contributor
- Wimberly5Jan 03, 2024Copper Contributor
THank you for responding. the formula will not carry past the allotted 279 row. I cannot figure out the formula to carry the rows to...any number really...but i'd like to at least cover the calendar year.
- Detlef_LewinJan 07, 2024Silver ContributorI still don't know what you mean. I can't spot any problems.
However, I would recommend using FILTER().
Or filter directly on sheet "Master", which doesn't require to duplicate the data.