I have a form on one sheet that I'd like to copy the values only of these to another sheet named "New Log"
Problem I have is I've named all the ranges that I'd like pasted and I need to paste all of these into the log at the same row then move down 1 row ready for the next submission
I can find solutions to the individual pieces of my issue but haven't been able to piece them together into a single neat solution.
The order of the paste should be using these names ranges on the same line on the log sheet;
"Employee", "Details", "Task1", "NewData1", "Task2", "NewData2", "Task 3", "NewData3" etc so on until the last range of "NewData10".
I surmise its pretty simple but if there's a solution I'd be eternally grateful.
If a dummy copy needs to be shared for understanding sakes let me know and I'll create it.
Problem I have is I've named all the ranges that I'd like pasted and I need to paste all of these into the log at the same row then move down 1 row ready for the next submission
I can find solutions to the individual pieces of my issue but haven't been able to piece them together into a single neat solution.
The order of the paste should be using these names ranges on the same line on the log sheet;
"Employee", "Details", "Task1", "NewData1", "Task2", "NewData2", "Task 3", "NewData3" etc so on until the last range of "NewData10".
I surmise its pretty simple but if there's a solution I'd be eternally grateful.
If a dummy copy needs to be shared for understanding sakes let me know and I'll create it.
