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 > >

$$Excel-Macros$$ Building an array out of semicolon separated values in a particular column from a data import

2010-03-01 Thread JAW-UC
Hello group! I'm relatively new to VBA. I'm trying to build an array by taking the string to the left of each semicolon (or to the right after the final semicolon) in each cell in a particular column from a data import and placing this string in the array as a value, rather than importing the dat

Re: $$Excel-Macros$$ month between two different month..formula

2010-03-01 Thread Christopher Luka
See attached for solution. On Mon, Mar 1, 2010 at 6:18 AM, Umesh Matkar wrote: > Pls suggest formula ..for below conditions > > > > From To Codes > > Jul-09Sep-09 JS0909 > > Apr-09 Jun-09 AJ0909 > > Oct-08 Mar-09 OM0809 > > Apr-08 Sep-08 AS0808 > > Oct-07 Mar-08 OM07

Re: $$Excel-Macros$$ Shell Object

2010-03-01 Thread Christopher Luka
The Shell command allows you to run other programs from Excel VBA. For example, you could type the following to open up Notepad in Windows: Shell "Notepad.exe" Make sense? Chris On Sun, Feb 28, 2010 at 10:45 AM, Harpreet Singh Gujral < harpreetguj...@gmail.com> wrote: > Hi Group, > > Some of

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

$$Excel-Macros$$ month between two different month..formula

2010-03-01 Thread Umesh Matkar
Pls suggest formula ..for below conditions >From To Codes Jul-09Sep-09 JS0909 Apr-09 Jun-09 AJ0909 Oct-08 Mar-09 OM0809 Apr-08 Sep-08 AS0808 Oct-07 Mar-08 OM0708 Oct-06 Sep-07 OS0607 Sep-06 TS06 (sep-06 and greater than that ..means jan04

Re: $$Excel-Macros$$ Attendance Tracker

2010-03-01 Thread Prabhat Kumar m...@ff@rPur/Delhi
Hi group< Please give me a format for Leave Tracker.its urgent need. Thanks Looking in to my Query. Regards chandrabhan Singh +919911255330 On Sat, Feb 27, 2010 at 1:45 AM, Prabhat Kumar m...@ff@rPur/Delhi < cs4...@gmail.com> wrote: > Dear sir, > > I have a new Challenge to Maintain Leave Rec