Macros would be better since you can arrange to NOT leave resource hogging
formulae but try. Notice the
! ! !

=sheet1!a4

--
Don Guillett
SalesAid Software

"RedHeadedMenace" wrote in
message ...
Stupid newbie question, Excel 2003:

I have a 2 sheet document. SOME of the info from Sheet 1 needs to appear
on
Sheet 2.

For example, Sheet 1 Column G values need to be populated to Sheet 2 as
Column B, Column H needs to be Column D, etc.

Is there any way to automate this without having to write a VB script? I
know a macro could kind of do it, but I don't think it could take all the
parameters, since Sheet 1 is constanly being altered (i.e., new values,
etc.). Oh, and all rows are relational so that G3 value from Sheet 1 when
it
goes to Sheet 2 B17 also has to have H3 from Sheet 1 go to D17.
Essentially,
the command is: suck only these input values from Sheet 1 and pout them
HERE
on Sheet 2.

It would be really nice if the formula could be set up not just as a page
function but as a workbook function (i.e, =SH1A3 (as in Sheet 1, cell A3),
but I haven't seen anything to suggest that this could be done, and my
excel
guru friend says she's never done anything but C&P to move info.

Have tried to read VB programming instrux and eyes glaze at the gibberish.
Sorry, I am just a dumb girl trying to run Office, not a a techie who can
even begin to understand prog jargon.

respond please via NG OR email.

THX!!!!