I am having 4 issues here...2 are really similar. I'm building a workbook to help stay organized at work that includes a new worksheet for every month of the year. For example, this is the month of September and the year is 2011, hence "Sept'11", then "Sept'11Analysis"....I'll be making it like that for the whole year. Then for 2012. I'm really looking to make this as automated as possible. I'm hoping someone, somewhere knows the formula for these. Most of it is copying and duplicating numbers.....I just can't recall nor can I find how.
ISSUE NUMBER 1: I'm stuck on what I assume is a rather simple formula. Can't find it anywhere. I am needing cells to automatically be copied from one worksheet to another. In the worksheet titled "Sept'11Analysis" I have cell numbers for the worksheet "Sept'11" that I want automatically to appear in "Sept'11Analysis" when entered in "Sept'11".
ISSUE NUMBER 2: In Column T on "Sept'11"........if there is no value or 'N/A' in Column N, I'm getting the '#VALUE!' error. How can I make that go away?
ISSUE NUMBER 3: I am needing Column W to automatically multiply the value in Column U by the percentage found in Cell W2. (I entered an example in W19)
ISSUE NUMBER 4: I am needing Column X to automatically multiply the value in Column N by the percentage found in Cell W2. (I entered an example in X19)
Bookmarks