Hi Group,
Maybe another dumb question from a noob, but I would like to be
able to enter data from selected cells in another worksheet when I
enter on sheet1....I know I could go to the second worksheet, select
the cell where I want the data entered and insert =, go back to sheet
1 select the cell whose data I want entered, and press enter, etc,
etc.,....the question is: how would you go about writing a function,
or VBA, that would do it automatically as you type in data on sheet1,
without having to go to sheet2 and doing the = everytime??....as it is
now, I can only do one line at a time, then repeat the = process each
time to change the cell reference, which is a very slow process...I
know the answer is probably very simple, but I don't have the
knowledge or expertise to make it so...any help would be very greatly
appreciated, as it always is...
Ken