Search if etc

R

RT

Hi

I am getting slightly stressed with myself over a stupid thing I was sure i
knew how to tackle and I am getting no where

I am having problems with VBA and macros
Please be patient with me whilst not being a virgin in Macros I am still at
the early learning stage

This is what I whish to achieve

On "Sheet1" I have two columns A & B in which there are names in A and
figures in B


The names come from a list called "Company" and the figure updated
automatically from another sheet


On a seperate sheet "sheet2" I have a column for each name in the "Company"


What I want to achieve is that each time a cell in column B of "Sheet1" is
updated that the amounted is copied into the next free cell of the column
with the name in column A on "Sheet1"

Also it would be nice if some kinf of check mark could be added onto the
cell on "Sheet1" so that I know it has been added to "Sheet2"
This could be as simple as changing colour or font or background


Any idea on how to do this would be greatly appreciated
 
B

Bob Phillips

Try this.

On Sheet2, B1

=IF(NOT(ISNA(VLOOKUP(A1,Sheet1!$A$1:$B$100,2,FALSE))),VLOOKUP(A1,Sheet1!$A$1
:$B$100,2,FALSE),"")

On Sheet1, do some conditional formatting, Format>Conditional Formatting,
set acondition of FormulaIs, and a formula of
=NOT(ISNA(VLOOKUP(A1,Sheet2!$A$1:$B$100,2,FALSE)))
and set a pattern colour


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top