Hi,
I have a wkst that allocates projected cash based on a percentage of collections each month.
(worksheet attached) The attached worksheet is correct, but I entered the formulas line by line. I have tried numerous ways to put the first formula in for January and then copy it to the entire worksheet, but obviously I am not doing something correct.
I think it is a problem with where I am entering absolutes.
Anyone have any ideas? This is way too time consuming and I have about 30 more to complete.
Thanks in advance.
Bookmarks