Hi First off let me say this is my first Google Groups post, and I am
excited to see how this will work out.
Ok so my problem is this:
I am trying to set up an auto style spreadsheet that will just take a
value from one cell on a worksheet, and enter it into the designated
cell in another worksheet with in the same workbook. My main data
entering worksheet is called "master". The second sheet i am trying to
set up so that when i enter data on the master sheet, it also appears
where i tell it to on the book 2.
I am using this formula on book 2 where i want the data" =master!C4"
and it works ok. The big thing is is that the next cell needs to
reference master!c6 and then next is c8 and so on. So i basically need
to repeat this formula for every other alternating cell in the master
document. When i enter 4 or 5 of these manually in book 2, and then try
to use the auto fill handle, it does not recognize the even numbver
pattern. ANy ideas?
Thanks