VBA to copy specific columns from one sheet in to specific columns on another sheet based upon certain criteria

  • Hang around places like Ozgrid?!


    There are tons of websites with tutorials, the best way, in my experience, is to automate your own bits of work and ask questions when you get stuck, as you have here. If you hunt around Oz you might find a thread on useful websites etc.

  • Hi Stephen,


    Sorry to bother you again!


    I was wondering if you could help with one last piece of code for this workbook?


    Each month, most clients will have all of their stats green for each department. Therefore instead of both users having to go in and fill in each individual department green for that client, I was hoping to create a command button which would populate all of the relevant cells with the letter "G" based upon the options chosen from two drop down lists.


    What I would need is:

    - When a user selects "Operations" from the first drop down list and selects a client, the command button will input the letter "G" in columns: G, I, K, M, O, Q, and S for that client.

    - When a user selects "Client Management" from the first drop down list and selects a client, the command button will input the letter "G" in columns: H, J, L, N, P, R, and T for that client.


    I've attached my updated sheet with the first row completed as an example if a user was to select "Operations" and "Apple" then hit the command button.


    Many thanks!!