Excel VBA to move cells to sheet2 based on selection in sheet1

Joined
Aug 3, 2018
Messages
1
Reaction score
0
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
upload_2018-8-3_10-40-19.png


Sheet 2

upload_2018-8-3_10-42-5.png


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
 

Attachments

  • upload_2018-8-3_10-31-32.png
    upload_2018-8-3_10-31-32.png
    21.1 KB · Views: 87
  • upload_2018-8-3_10-36-35.png
    upload_2018-8-3_10-36-35.png
    15.3 KB · Views: 86

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top