Hi Karen
please don't use ALL CAPS as it makes the post difficult to read and is
generally considered "shouting" in a ng environment.
if the cells that you want to populate are on different sheets then one way
to do it (without using code) is to put a formula in the other cells so that
they take their information from one sheet. For example, if you want to
populate
Sheet1!A1, Sheet2!a10 and Sheet3!B27 all at the same time in sheet2!A10 type
=Sheet1!A1 and do the same in Sheet3!B27, now when you type in Sheet1!A1
these two cells will be populated at the same time.
Alternatively, if its the same cells but in different workbooks (ie cell A1
in Sheets1, 2 & 5 ) then
click on the sheet tab for Sheet1, hold down your control key and click on
the sheet tab for sheet3, keep the control key down and click on Sheet5's
tab. The sheets are now grouped. Let the control key go and click in A1
and type the entry. Now check the other sheets (this will ungroup them).
Hope this helps
Cheers
JulieD
