Hi, I tried to do a data exchange between worksheets, should I use "Macro" or
"VB"?
To explain it in a a little detail, I got some experimental data ouput and
saved on one worksheet (named as "Cent1" under "workbook1"). I want to export
these data to another worksheet (named as "sheet1" under "workbook2") to do
some calculation. After the calculation and I want the result from "sheet1"
exporting to and showing in "Cent1". Ideally I want the calculation in
"sheet1" runing behind, which means I don't want Excel load and show
"Sheet1". I just want the "Cent1" sheet shows in screen.
To trigger the data exhange, I plan to put a button as "Calculate" in
"Cent1", so when I hit "Calculate", the data go to "Sheet1" and result shows
in "Cent1" while "Sheet1" runs behind the scene.

Any help is highly appreciated!!