Hello,
Is there a macro that can copy info from another tab and place it in the current tab.
Example:
I'm in Sheet 2 and want to copy data from Sheet 1. and the cells I want to copy is A8 thru J207 from sheet 1 to sheet 2's A8 thru J207.
Also, I'm creating a button and would like to add prompt before the macro is executed that reads "Are you sure want to copy the data from the previous day? All current data will be lost." Yes No and if they press yes it would execute macro
Any help would be appreciated. Thank you.
Eric
Is there a macro that can copy info from another tab and place it in the current tab.
Example:
I'm in Sheet 2 and want to copy data from Sheet 1. and the cells I want to copy is A8 thru J207 from sheet 1 to sheet 2's A8 thru J207.
Also, I'm creating a button and would like to add prompt before the macro is executed that reads "Are you sure want to copy the data from the previous day? All current data will be lost." Yes No and if they press yes it would execute macro
Any help would be appreciated. Thank you.
Eric