Hello,
I have two files attached: "'Copy" and "Paste"
1. Assume the Copy file updates intermittently via macros and the outputs land on the page shown in the "Item 1" row. I need a macro button in the "Paste" file that will grab the updated information from the "Copy" file and paste it into the next blank column, in this case column L (and transposed as shown in previous columns).
2. As an alternate option I would also like a macro button on the "Paste" file that would simply copy the tab from the "Copy" tab and append to the tabs in the "Paste" file. Once complete, I would like this new tab to automatically be named the number of the next project shown in the next available column, in this case column L, Project 11. The newly added tab would be named, "Project 11".
Any help is greatly appreciated.
Bookmarks