Hello everyone,
Im new here and also new to VB... Im creating some spredsheet for local hospital im working at, so it would make life much easier on some nurses to help them out, but im limited when it comes to advanced stuff of excel.
I have attached simple example of spreadsheet, just to make it easier to understand.
Things we need to focus on: formula in column C and checkboxes in colums J, K and L.
What i would like to achieve is following:
Row 6 is already predefined and waiting visible for first input, but every next row should copy formula from C and checkboxes with their functions acording to new row ONLY WHEN data is inputed into D column of new row.
So to make it more clear... "i input name into D column and serial number is shown in C plus checkboxes J-L waiting to be clicked or not". Checkbox cell should change color based on clicked or not (green/red).
I hope im not asking for to much... i tried quite few examples of code, but nothing hapens... so i gave up... and then i found this place.
thank you all in advance for all your help
Im new here and also new to VB... Im creating some spredsheet for local hospital im working at, so it would make life much easier on some nurses to help them out, but im limited when it comes to advanced stuff of excel.
I have attached simple example of spreadsheet, just to make it easier to understand.
Things we need to focus on: formula in column C and checkboxes in colums J, K and L.
What i would like to achieve is following:
Row 6 is already predefined and waiting visible for first input, but every next row should copy formula from C and checkboxes with their functions acording to new row ONLY WHEN data is inputed into D column of new row.
So to make it more clear... "i input name into D column and serial number is shown in C plus checkboxes J-L waiting to be clicked or not". Checkbox cell should change color based on clicked or not (green/red).
I hope im not asking for to much... i tried quite few examples of code, but nothing hapens... so i gave up... and then i found this place.
thank you all in advance for all your help
