Hi,
I am trying to get this macro to work. What it does is look at B2 and matches it with the months across the top. When it finds the right month it loads the formula I want. There are two separate macros on this sheet, a working one and a not working one. The working one does what I want it to do, but because I am going to have several sheets and several rows to do it on I do not want to take up space by writing it a bunch of times. I am trying to use the not working one to loop it and make it work for the price sheet. Then I am going to try to make it be one button to do all the sheets, in this case both price and cost. The non working one is giving me a compiler error, can you tell me what I am doing wrong?
Bookmarks