Find value and copy from different worksheet

Posted on 2011-10-18
Last Modified: 2012-05-12
I think this is pretty simple for someone who knows there way round VBA, I have been struggling to get it working :(

I am trying to write a macro that will loop through the values in the A column of the 'Jobs' sheet, which I have managed to do.

 What I a having problems trying to do is to use the value from 'Jobs' to get the relevant value highlighted in Green from the 'Values' sheet and place it in the B collumn. The desired output is on the third worksheet.

Could someone point me in the right direction please.

Question by:wellso
    LVL 19

    Expert Comment

    you would not even have to use VBA in order to achieve this
    LVL 19

    Expert Comment

    LVL 19

    Accepted Solution

    The formula is to get the sum for specific job numbers, you can build from there.

    eg to hide the zero's use

    Open in new window

    and to highlight it green apply conditional formatting
    LVL 2

    Author Closing Comment

    Sorry for the delay answering, top notch

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now