Sorry, I have unexpectedly been out for a few days.
My original document lists the following:
On the "ACTIVE" sheet:
Columnd "A" is project numbers.
Columns "B" through "I" are hard keyed descriptives about the project, like location, title, project manager, p.o. number, etc.
Column "J" is the hard keyed dollar amount of the purchase order.
Column "K" is a calculated field. It calculates the total expenditures that are hard keyed by me in columns "X" though "BZ". I have dates listed at the top of those columns and I key in the weekly expenditures in each project's row.
Columns "L" through "N" are calculated values that have no bearing on the formats.
Column "O" lists the percentage of the p.o. that has been spent. This is how I decide what color to make that row. I change the color manually each week according to the following criteria: Red = 100 % or more. Orange = between 95 & 99%. Blue = between 90 & 94% and yellow means there is no purchase order (column I - p.o. number and J - p.o. $ would be empty). I also use Purple to signify that a project is suspended and Green to mean we are on hold. This must be done manually as there are no calculations that tell me this.
Column "P" through "W" are more hard keyed project descriptives and comments.
On the "SEND TO ROY" sheet: (this is the sheet that is doing the vlookup)
Column "A" is a hard keyed list of all projects that Roy is interested in reviewing.
All of the rest of the columns contain vlookup functions using the number in "A" to find the corresponding information from the "ACTIVE" sheet. Not all columns from "ACTIVE" are pulled to this sheet. Only information that I need to share with Roy.
Column "J" does pull the percentage information from "ACTIVES" column "O" that I use for formatting.
Does this help?