I think this problem will require a macro, though it might not. Basically, I have a list of values (columns A and B in attached excel sheet). In columns C and D I subtracted 15 and added 15 to the values in column B, respectively. The new list (columns E and F are what I want). What I want can best be explained with an example. Take the case of A2&B2 in list 1. I subtract 15 and add 15 to 35 (as shown in columns C and D). Then in columns E&F I want excel to start at 20 (the lower bound) and count by increments of 1 until it gets to the 50 (the upper bound). These new values need to make up the entries of the list in columns E&F. So this means it would generate the values IPI2002 20, IPI2002 21, IPI2002 22,....,IPI2002 49, IPI2002 50. Excel would do this for every entry in list 1. I badly need this formula/macro for my work. I'm struggling to figure it out, so if anyone can help, that would be awesome.
Note: the added coloring of the cells is just to help you visualize what I mean. It does not need to be included in the final product.
Bookmarks