Example.xlsxTrying to get C28:C35 to AG28:AG35 to populate with the number 1 when the same name is chosen on another sheet. On the "Daily" sheet if K2 is the same as the "Costs" sheet B28 then the number 1 should be populated in "Costs" C28 etc. the actual workbook has 31 "Daily" sheets.
I have it working except if the "Costs" sheet is blank then cell B28 it populates a 1 in C28...I know there has to be some work around for this but can't seem to figure it out.
I can be a macro or a cell formula, it doesn't matter to me.
Thanks for your help.
Bookmarks