Thread: communication between worksheets and value errors

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)

Hi dreinisch. Could you upload an example workbook? I can give you an answer to number 2, however.
ISSUE NUMBER 2: use the IFERROR command (XL 2007 and later). Example

=IFERROR(B1/C1,"")

Attached is a working copy of what I think you're looking for. I took an educated guess at what you were shooting for with Issues 3 & 4 as the descriptions in the workbook did not match and the result of all descriptions would result in an error. I'm hoping that with these formulas intact, you should be able to complete the workbook on your own. Good luck!

I removed the attachment per your request. This was the key formula used to get the desired result

=OFFSET('Sept''11'!$A$1,INT(ROW()/19)+4,0)

Great! Please mark the thread as SOLVED at your earliest convenience. Thanks!