Advance Code or macro

Hi,
I have the following scenario:

I have the following worksheet names: Summary, Sheet 1, Sheet 2, Sheet 3.

The cell A10 in Sheet 1,2,3 may contains a value depending if the user filled it or not.

Now I would like to do is the following:
If A10 in contains a value in sheet 1 then copy it to Summary sheet A1
If A10 in contains a value in sheet 2 then copy it to Summary sheet A2
If A10 in contains a value in sheet 3 then copy it to Summary sheet A3

If for exmaple A10 in sheet 2 does not contain a value then don't copy it to Summary sheet A2, instead, copy the value A1 in sheet 3 to Summary sheet A2

I think you get my point?

THank you.

Hi

Here's a couple of ways

Please Login or Register  to view this content.

HTH

rylo