software

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 quot;masterquot;. 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 dataquot; =master!C4quot;
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?
ThanksbumpI like this technique:

Put this in the top cell in your range:
=quot;$$$Master!Cquot;amp;(2*ROW(A1)) 2

Notice that you don't actually have a formula that retrieves the value from the
Master Sheet. It's a formula that builds a formula.

Drag down the column as far as you need

Select that range
Edit|copy
Edit|paste special|values

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

--

Dave Peterson

Thanks Dave for your response!
I will give this a shot and see if it works! I appreciate it. I will
let you know the outcome.
Regards,
TravisGreat solution! Thanks so much for this Dave. Worked like a charm.