I have one source excel file and multiple target excel files. The manual process is to copy information from the source and paste it into target files one by one. The copy/pasting is not an entire sheet but specific areas on specific sheets.
Any idea the best way to achieve? Even an example work flow of just one source file to one target file could get me started. I'd rather not use range names as they are often deleted or altered in the source files.
This is very helpful. Let me absorb this. My source file has multiple tabs with the information separated to indicate the different different target files. In addition the source file isnt really in table format.
Again THANK YOU! You saved me alot of time.