Hi
Can someone assist with this please. Is it possible to copy cell value from sheet 1 based on selection to specific next available cell in sheet 2 under relevant heading within table. Then also color code individual date cells in sheet 2 based on date values in sheet 1.
Sheet1
Sheet 2
So i need AIR INTERNET when selected in sheet1 to appear in the next available cell under the title PBS in sheet2.
Also i need the training and consolidation dates from columns Q,R and T,U from sheet1 to populate and color code the individual days in sheet2 as per examples above.
Thanks heaps in advance for any assistance you can provide me.
Cheers
Can someone assist with this please. Is it possible to copy cell value from sheet 1 based on selection to specific next available cell in sheet 2 under relevant heading within table. Then also color code individual date cells in sheet 2 based on date values in sheet 1.
Sheet1
Sheet 2
So i need AIR INTERNET when selected in sheet1 to appear in the next available cell under the title PBS in sheet2.
Also i need the training and consolidation dates from columns Q,R and T,U from sheet1 to populate and color code the individual days in sheet2 as per examples above.
Thanks heaps in advance for any assistance you can provide me.
Cheers
