Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Find value and copy from different worksheet

Posted on 2011-10-18
4
Medium Priority
?
175 Views
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.




Example.xls
0
Comment
Question by:wellso
  • 3
4 Comments
 
LVL 19

Expert Comment

by:Arno Koster
ID: 36985323
you would not even have to use VBA in order to achieve this
0
 
LVL 19

Expert Comment

by:Arno Koster
ID: 36985340
0
 
LVL 19

Accepted Solution

by:
Arno Koster earned 2000 total points
ID: 36985349
The formula is to get the sum for specific job numbers, you can build from there.

eg to hide the zero's use
=IF(SUMIF(Values!A:A,Jobs!A2,Values!I:I)="";"";SUMIF(Values!A:A,Jobs!A2,Values!I:I))

Open in new window


and to highlight it green apply conditional formatting
0
 
LVL 2

Author Closing Comment

by:wellso
ID: 36987143
Sorry for the delay answering, top notch
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Make the most of your online learning experience.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

580 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