123Maximus
New Member
- Joined
- Dec 31, 2016
- Messages
- 13
Hello!
In Sheet 1 I have raw data in column A and in B1 and C1 I have calculated values from this column. D1 gives me the date,
i. e =TODAY().
The three values are transferred to B1, C1 and D1 in Sheet 2 (=Sheet1!B1...D1).
I have also a button (named "Delete Report") in Sheet 1 that deletes the data in column A and highlights A1.
Now I want to put in some more code that only saves the data in Sheet 2 and highlights the next emty row when I click the "Delete Report button".
Is this possible?
Thanks in advance!
In Sheet 1 I have raw data in column A and in B1 and C1 I have calculated values from this column. D1 gives me the date,
i. e =TODAY().
The three values are transferred to B1, C1 and D1 in Sheet 2 (=Sheet1!B1...D1).
I have also a button (named "Delete Report") in Sheet 1 that deletes the data in column A and highlights A1.
Now I want to put in some more code that only saves the data in Sheet 2 and highlights the next emty row when I click the "Delete Report button".
Is this possible?
Thanks in advance!