 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007How do I exchange data between worksheets?
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? > Hi, I tried to do a data exchange between worksheets, should I use "Macro" or > "VB"? [quoted text clipped - 10 lines] > > 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, > 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 [quoted text clipped - 17 lines] > > > > Any help is highly appreciated!!
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.