VBA to move cells to sheet2 based on selection in sheet1

Excel Discussion in 'Microsoft Office' started by help_me, Aug 3, 2018.

  1. help_me

    help_me

    Joined:
    Aug 3, 2018
    Likes Received:
    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
     

    Attached Files:

    help_me, Aug 3, 2018
    #1
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.