charlies_angel
New Member
- Joined
- Nov 29, 2013
- Messages
- 2
Hi,
Here is my spreadsheet scenario:
(MS Office 2013)
"Data Input Sheet" has approx. 80 rows, each one is designated to individual pieces of rental equipment (for example; Row 6 is for Unit 202 info, Row 7 is for Unit 203 info, etc)
Once the required data is entered, completion is indicated by a green checkmark icon (as well as a "100")
I need a macro (button) that will ONLY allow a row to be transferred from "Data Input Sheet" to the "History Sheet" when that condition (green checkmark, or 100) is met, as well as only copy/paste the cell values (I do not want my formulas from the data input sheet to end up in the history) I also need the row on "Data Input Sheet" to clear so the next rental's info may be entered.
The "History Sheet" needs to accept any of the 80 rows from "Data Input Sheet" (as selected by user) and it is preferred if the most recent completions can be transferred into the top of the "History Sheet", continuously bumping the older ones downward.
It would also be great if I could double the cell with the green checkmark as my macro button location- but I'm not sure if that would cause the formula already within that cell to not function??
Thank you for any help you can offer!!
Here is my spreadsheet scenario:
(MS Office 2013)
"Data Input Sheet" has approx. 80 rows, each one is designated to individual pieces of rental equipment (for example; Row 6 is for Unit 202 info, Row 7 is for Unit 203 info, etc)
Once the required data is entered, completion is indicated by a green checkmark icon (as well as a "100")
I need a macro (button) that will ONLY allow a row to be transferred from "Data Input Sheet" to the "History Sheet" when that condition (green checkmark, or 100) is met, as well as only copy/paste the cell values (I do not want my formulas from the data input sheet to end up in the history) I also need the row on "Data Input Sheet" to clear so the next rental's info may be entered.
The "History Sheet" needs to accept any of the 80 rows from "Data Input Sheet" (as selected by user) and it is preferred if the most recent completions can be transferred into the top of the "History Sheet", continuously bumping the older ones downward.
It would also be great if I could double the cell with the green checkmark as my macro button location- but I'm not sure if that would cause the formula already within that cell to not function??
Thank you for any help you can offer!!