Re: $$Excel-Macros$$ Re: remove empty cells (rows) between two cells

2010-03-01 Thread Christopher Luka
Whoops, forgot the attachment. On Mon, Mar 1, 2010 at 1:59 PM, Mark Kim wrote: > thanks.. > > um.. where is the code? ^ ^ > > On Tue, Mar 2, 2010 at 6:01 AM, Christopher Luka < > christopher.l...@gmail.com> wrote: > >> OK, I modified the code to leave the six rows prior to the FBT details >> lin

Re: $$Excel-Macros$$ Re: remove empty cells (rows) between two cells

2010-03-01 Thread Mark Kim
On Fri, Feb 26, 2010 at 4:44 PM, Ayush wrote: > Hi Markkim, > > Would you please send the sample file containing this data? > > Best regards, > Ayush Jain > > On Feb 26, 6:18 am, Markkim wrote: > > Hi > > I have been trying to make these but have failed. ^ ^;; > > I’d like to create a macro > >

Re: $$Excel-Macros$$ Re: remove empty cells (rows) between two cells

2010-03-01 Thread Christopher Luka
OK, I modified the code to leave the six rows prior to the FBT details line. Does this do what you want it to? On Sun, Feb 28, 2010 at 9:15 PM, Mark Kim wrote: > Hi, Thanks for the code. > > But I tried but it doesn’t seem to work as expected. Can I ask you this > please? > > in the data sheet

Re: $$Excel-Macros$$ Re: remove empty cells (rows) between two cells

2010-02-28 Thread Mark Kim
Hi, Thanks for the code. But I tried but it doesn’t seem to work as expected. Can I ask you this please? in the data sheet you uploaded, what I want is to select Dat1 to Data 7 and remove blank rows. In my real data I work with, there are 6 rows between the last transaction record and FBT detail

Re: $$Excel-Macros$$ Re: remove empty cells (rows) between two cells

2010-02-26 Thread Christopher Luka
See attached for example. On Thu, Feb 25, 2010 at 9:44 PM, Ayush wrote: > Hi Markkim, > > Would you please send the sample file containing this data? > > Best regards, > Ayush Jain > > On Feb 26, 6:18 am, Markkim wrote: > > Hi > > I have been trying to make these but have failed. ^ ^;; > > I’d

$$Excel-Macros$$ Re: remove empty cells (rows) between two cells

2010-02-25 Thread Ayush
Hi Markkim, Would you please send the sample file containing this data? Best regards, Ayush Jain On Feb 26, 6:18 am, Markkim wrote: > Hi > I have been trying to make these but have failed. ^ ^;; > I’d like to create a macro > > A21 has a word called ‘Date’ > > And somewhere down in column A has