Find Value on Sheet1

[FallingDown]

Hi all

In my workbook I intend to automate a few manual steps.
One of them would include to have a new sheet, which will output values based on data in sheet 1, with a worksheet_change procedure

Let's say I have

ABC	500.45	17. July 2013
ABC	-745.69	17. July 2013
XYZ	-500.45	17. July 2013
XYZ	+745.69	17. July 2013

The lables "ABC", resp. "XYZ" do not change, howver, the amount does on a daily basis.

What I would like to achieve is that these values are shown on another sheet, but with the amount multiplies by -1 as per following example

ABC	-500.45	17. July 2013
ABC	+745.69	17. July 2013
XYZ	+500.45	17. July 2013
XYZ	-745.69	17. July 2013

The position of these data change every day, as there is much more data apart from this, so it may by on row 231 today, but on row 114 tomorrow.

How to achieve this?

I would manage, if "ABC" or "XYZ" would be unique values, but I have not found a solution to capture both, the postitive and negative amount for each

Thanks
FD

[elayaz]

Hi,

See if the attached way works for you. Next time please post the data as an excel file

If needed, you can hide the columns in yellow.