Hi everyone, I've tried searching the message board to find an answer to my question but to no avail (I may have even stumbled on a solution, but as VB is a relatively foreign language to me, it's a tad difficult making any sense of the code), Anyway, my question
Using VB in a file named "Test" in Sheet1, is there any way I can have a command button, that when clicked, will copy/paste/value from a closed workbook sheet (i.e. named "Data") and dump the values from "Data" to Sheet2 in "Test" ?
Note: the entire sheet of "Data" does not necessarily have to be copied...from an efficiency standpoint, the range of values to copy in "Data" could be limited to $1:$500.
Any insight appreciated.
Mark
Using VB in a file named "Test" in Sheet1, is there any way I can have a command button, that when clicked, will copy/paste/value from a closed workbook sheet (i.e. named "Data") and dump the values from "Data" to Sheet2 in "Test" ?
Note: the entire sheet of "Data" does not necessarily have to be copied...from an efficiency standpoint, the range of values to copy in "Data" could be limited to $1:$500.
Any insight appreciated.
Mark