I've got a protected spreadsheet at work that prevents me from creating links or writing macro's to do some repetitive copying and pasting from one spreadsheet to another. I hope someone can help.
I'd like to use VB (if possible) to copy from a specific range in Spreadsheet1.Sheet1 (let's say D5 to J15). I then want to go to Spreadsheet2.Sheet1 and "Paste Value" starting at cell D2. Is this actually possible? If so, can someone direct me to where I might find the commands/codes that would allow me to do this? Is this done very much like writing a macro?
In advance, thanks for the help. I certainly appreciate any articles or video's that might help me get started with this project.