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!!

Hey, i would seriously consider putting the calculations on the same workbook
You can run a vba code to make it xlveryhidden as in no one can open it
unless they got in to the code.

And whats the calculation, is it for one cell or multiple cells or do you
have any more information?

"TucAO" wrote:

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!!

Hi, The calculation is pretty complex and with a lot of formulas and based on
multiple cells. I don't want the calculation get messed up , and that is why
I want it to run behind the scene, and not in the same workbook. My
experimental data has 8 data and so takes 8 cell spaces. The output from the
calculation is also 8 data, and I want it to dispaly in the "Cent1" sheet.

A littlt clear? Answers?
Thanks,



"AKphidelt" wrote:

Hey, i would seriously consider putting the calculations on the same workbook
You can run a vba code to make it xlveryhidden as in no one can open it
unless they got in to the code.

And whats the calculation, is it for one cell or multiple cells or do you
have any more information?

"TucAO" wrote:

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!!