Hi all,
I have the following situation:
I have 2 worksheet with different tabs in each one, let assign a name to the first as WSA and to the second WSB.
let say that I'm working in WSA in the tab a. I need to make a sum along a column in the tab a of WSA. The sum is the evaluation of data present in a tab a column + data that are stored in a column in WSB.
Now I would like to create in the WSA a dialog box that asks to the user which file has to be open, if possible also which column to be copied but it is no the matter, and then excel to copy the data from the column in WSB and make the sum in WSA.
In your experience it is possible or not? If yes, does any VBA code exists?
Thank you in advance for your help!
BDF