Re: $$Excel-Macros$$ VBA PRINTING AND RECORD UPDATING

2010-04-16 Thread OSA
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

Re: $$Excel-Macros$$ VBA PRINTING AND RECORD UPDATING

2010-04-15 Thread Paul Schreiner
_ 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

Re: $$Excel-Macros$$ VBA PRINTING AND RECORD UPDATING

2010-04-14 Thread OSA
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

Re: $$Excel-Macros$$ VBA PRINTING AND RECORD UPDATING

2010-04-14 Thread Paul Schreiner
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 (

$$Excel-Macros$$ VBA PRINTING AND RECORD UPDATING

2010-04-14 Thread OSA
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