Basic excel copy and paste formula one page to another with few conditions
Budget: ₹750 – ₹1,250 INR
I cant figure out the correct formula for this hence asking our incredible freelance community online.
I have a spreadsheet with two pages.
-To-do page
-Done Page
The To-do page contains a table with data
The Done page has that same table with no Data (it has the same headings)
I want to be able to move a row of data from table in the To-do page to the table in the Done page.
After I've moved that row of data, the row should be completely deleted from the To-do page.
Also would like a Total counter on the To-do page that increments by 1 every time a row is moved.
Attached is a test sheet containing small sample size of data.
If someone can implement the correct formulas so it works on the test sheet, I'm happy to share the correct dataset with them for them to action.
Dataset is around 220 rows.
Thanks heaps.
I have a spreadsheet with two pages.
-To-do page
-Done Page
The To-do page contains a table with data
The Done page has that same table with no Data (it has the same headings)
I want to be able to move a row of data from table in the To-do page to the table in the Done page.
After I've moved that row of data, the row should be completely deleted from the To-do page.
Also would like a Total counter on the To-do page that increments by 1 every time a row is moved.
Attached is a test sheet containing small sample size of data.
If someone can implement the correct formulas so it works on the test sheet, I'm happy to share the correct dataset with them for them to action.
Dataset is around 220 rows.
Thanks heaps.