I
Ian Belcher
Hi,
I've got two spreadsheets. One has got data on, and one is blank but with
validation on (from the data -> validation menu). I need to get the data
onto the sheet with the validation and got through the validation process.
If you paste or use vb commands such as range or cell, the validation is
bypassed.
Is there a way of simulating the act of typing in the data into the
spreadsheet? Unfortunately I don't have control from either the source
sheet, or the destination, but I can set up a routine to transfer the data.
Thank you
Ian
I've got two spreadsheets. One has got data on, and one is blank but with
validation on (from the data -> validation menu). I need to get the data
onto the sheet with the validation and got through the validation process.
If you paste or use vb commands such as range or cell, the validation is
bypassed.
Is there a way of simulating the act of typing in the data into the
spreadsheet? Unfortunately I don't have control from either the source
sheet, or the destination, but I can set up a routine to transfer the data.
Thank you
Ian