MsgBox "data not found in Sheet1"
> Cancel = True
> End If
> End Sub
>
> Paul
>
> ----------
> *From:* OSA
> *To:* excel-macros@googlegroups.com
> *Sent:* Wed, April 14, 2010 8:16:34 PM
> *Subject:* Re: $$Excel-Macros$$ VBA
_
From: OSA
To: excel-macros@googlegroups.com
Sent: Wed, April 14, 2010 8:16:34 PM
Subject: Re: $$Excel-Macros$$ VBA PRINTING AND RECORD UPDATING
Hi Paul,
Thank you always for your response. I guess worksheet before print is Ok.
Please suggest a short code. thanks.
On Wed, Apr 1
with this.
>
> Paul
>
> --
> *From:* OSA
> *To:* excel-macros@googlegroups.com
> *Sent:* Wed, April 14, 2010 2:08:49 AM
> *Subject:* $$Excel-Macros$$ VBA PRINTING AND RECORD UPDATING
>
> Dear Group,
>
> I have a worksheet (sheet2) t
quot; when anything is
changed.
let me know if you need additional help with this.
Paul
From: OSA
To: excel-macros@googlegroups.com
Sent: Wed, April 14, 2010 2:08:49 AM
Subject: $$Excel-Macros$$ VBA PRINTING AND RECORD UPDATING
Dear Group,
I have a worksheet (
Dear Group,
I have a worksheet (sheet2) that I always print. Many of the information
from this printed worksheet is coming from record located at sheet1. Column
A in sheet1 contains the codes which I input in sheet2.range(b9) as a
criteria to extract data from sheet 1.
I would like that after pr