Not sure if this is possible, but I will ask anyway.
I have a worksheet that gets data imported from a survey form
This data is imported into Sheet 1 Row A1 through to A12
What i would like to do is once the data is imported, is to copy it to Sheet 2 rows A1 to A12, so I delete Sheet 1 info, this will allow me to import next survey
What I want is to keep data on sheet 2, but the next survey data to be copied from Sheet 1 rows A1 to A12 to Sheet 2 rows B1 to B12 and so on for all survey results Sheet 2 rows C1 to c12, Sheet 2 rows D1 to D12 etc
this is to keep a record of all results on Sheet 2, while leaving Sheet 1 clear for new imported data.
your thoughts appreciated
I have a worksheet that gets data imported from a survey form
This data is imported into Sheet 1 Row A1 through to A12
What i would like to do is once the data is imported, is to copy it to Sheet 2 rows A1 to A12, so I delete Sheet 1 info, this will allow me to import next survey
What I want is to keep data on sheet 2, but the next survey data to be copied from Sheet 1 rows A1 to A12 to Sheet 2 rows B1 to B12 and so on for all survey results Sheet 2 rows C1 to c12, Sheet 2 rows D1 to D12 etc
this is to keep a record of all results on Sheet 2, while leaving Sheet 1 clear for new imported data.
your thoughts appreciated
