T
titushanke
Hi all,
I am in desparate need of a macro that automatically copies the value
from one file to another. Sounds simple?
Well, not quite.. Let me give you an example..
I have 2 files:
- MASTER FILE
- OLD VALUES FILE
My Master file contains some cells in which numbers are manuall
inserted, let us say, C2:C200. The cells are currently blank.
The OLD VALUES file contains the same cells, also with numbers manuall
input (and actually contains numbers).
Instead of simply linking the files to each other, I would like a macr
that copies all numbers from one file to the other (paste special
values).
The user should be prompted to locate the file to copy from (OLD VALUE
FILE), as this might be located somewhere in another folder.
Think of this whole thing as an update procedure. My master fil
sometimes changes, but I don't want to manuylly Re-Input all th
figures from the old file to the new file. Therefore I would need thi
routine to manually copy all values in a certain range from one fil
another, with the user being promted to locate this file.
Does anybody have a clue how I can do this? Especially the prompting o
the user to locate the file...
Thanks in advance for your help!!!!
Ciao, Titus
I am in desparate need of a macro that automatically copies the value
from one file to another. Sounds simple?
Well, not quite.. Let me give you an example..
I have 2 files:
- MASTER FILE
- OLD VALUES FILE
My Master file contains some cells in which numbers are manuall
inserted, let us say, C2:C200. The cells are currently blank.
The OLD VALUES file contains the same cells, also with numbers manuall
input (and actually contains numbers).
Instead of simply linking the files to each other, I would like a macr
that copies all numbers from one file to the other (paste special
values).
The user should be prompted to locate the file to copy from (OLD VALUE
FILE), as this might be located somewhere in another folder.
Think of this whole thing as an update procedure. My master fil
sometimes changes, but I don't want to manuylly Re-Input all th
figures from the old file to the new file. Therefore I would need thi
routine to manually copy all values in a certain range from one fil
another, with the user being promted to locate this file.
Does anybody have a clue how I can do this? Especially the prompting o
the user to locate the file...
Thanks in advance for your help!!!!
Ciao, Titus