I have no idead how to do this even if it's possible in excel.
I have spread sheet with various info in one sheet ( stats ) has a table which is derived from other data. One of the main factors in this data is the times enterered in sheet ( mater input sheet ) cells D1:D1000 in hh:mm format.
I am trying to find a macro to run which will a change the times in the master input sheet D1:D1000 to other times ( need this to be random times in 15 min increments ie 11:00, 14:15, 21:45 etc )
Any help appreciated
I would like the sheet to then look at the table in sheet stats cells A1:h100 which will have numer both +ve and -ve and keep entering times in the master input sheet D1:D1000 untill it finds the ones that give hte best reult in the table in the sheet stats ( best result is all number or as many as possible are +ve ) but I know I am dreaming to get the sheet to do this so the first question will do me.
I have spread sheet with various info in one sheet ( stats ) has a table which is derived from other data. One of the main factors in this data is the times enterered in sheet ( mater input sheet ) cells D1:D1000 in hh:mm format.
I am trying to find a macro to run which will a change the times in the master input sheet D1:D1000 to other times ( need this to be random times in 15 min increments ie 11:00, 14:15, 21:45 etc )
Any help appreciated
I would like the sheet to then look at the table in sheet stats cells A1:h100 which will have numer both +ve and -ve and keep entering times in the master input sheet D1:D1000 untill it finds the ones that give hte best reult in the table in the sheet stats ( best result is all number or as many as possible are +ve ) but I know I am dreaming to get the sheet to do this so the first question will do me.