Hey guys,
I am looking for some formulas to help with my call planning.
In the attachment I have manually mocked up what I need to formulas to do.
Basically when I put in a 'Y' Value I want it then to fill and format the remaining weeks with an 'N' value based upon the Frequency number.
I also need it to reset the 'N' values based upon when a new 'Y' value is inputted so that I don't wind up with a bunch of 'N' values.
Can this be done?
Thanks
Moderator's Note:
Welcome to the forum.
May i suggest that you upload a real workbook for the members to work with.
Just make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Regards,
Vladimir
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks