We have a budget file where users are entering periods in one column, ie. 1,2,5 etc (Jan, Feb, May). In columns to the right, columns referred to as 1 to 12 (these are the period) we need the numbers to get into those cells specific to those columns only. For example... 1 would show up in column 1, 2 in col 2, 5 in column 5 etc. Not too hard except when we get to 10, 11, 12 as these create issues for columns 1, 2, 10, 11, and 12.
Attached is the excel file for visual review. We would prefer a non vba solution. I spent about 3 hours researching a variety of nested if thens with mid, substitute, find etc. Got stuck in weeds on this. Please help with suggestions or experiences with splitting out numbers 1-12 that deal with 1,2,10,11,12 dilemma.
Reply With Quote