akers77
06-23-2014, 02:18 PM
Hi,
I need some help transferring Data from one worksheet to another on a continuous basis. On the file attached, the first tab is labeled “Master Sheet”, the second tab is labeled “Reoccurring.”
I will be adding more data (rows) to the “Master Sheet” Tab, but I’d like to automatically copy the data from the “Reoccurring” tab to the Master sheet tab by hitting the “Transfer” button.
The problem is, I don’t know how to write a macro that won’t override data I manually input on the “Master Sheet”
Any ideas?
Thanks!
I need some help transferring Data from one worksheet to another on a continuous basis. On the file attached, the first tab is labeled “Master Sheet”, the second tab is labeled “Reoccurring.”
I will be adding more data (rows) to the “Master Sheet” Tab, but I’d like to automatically copy the data from the “Reoccurring” tab to the Master sheet tab by hitting the “Transfer” button.
The problem is, I don’t know how to write a macro that won’t override data I manually input on the “Master Sheet”
Any ideas?
Thanks!