can you share the sample file
On Mon, Dec 17, 2012 at 9:57 PM, sw1085 wrote:
> Hi all,
>
> I've been searching for hours looking for a generic macro to help with the
> following problem.
>
> If cell value in column J of worksheet "Sheet1" = "Apple" or "Pear" then
> copy that cell plus the previ
Hi all,
I've been searching for hours looking for a generic macro to help with the
following problem.
If cell value in column J of worksheet "Sheet1" = "Apple" or "Pear" then
copy that cell plus the previous 4 cells to a new worksheet called "Sheet2".
Hope someone can help.
Best regards
sw10