Re: $$Excel-Macros$$ Macro to clean up file

2010-08-04 Thread Joel Dawson
Need macro to get file output to look like tab 3 whether the input file looks like tab 1 or tab 2. What I think needs to happen is look for the column headers in the file and if they are there copy the entire column and paste to new tab, if they are not create just the column header and paste that

Re: $$Excel-Macros$$ Macro to clean up file

2010-08-01 Thread Joel Dawson
Any progress on the file formating? *Joel* On Sun, Jul 25, 2010 at 03:35, Sandeep Kumar Maurya wrote: > Hi, > I got your file but next time use gmail and attach in the mail. > > > Thanks & Regards > Sandeep > > On Sun, Jul 25, 2010 at 1:02 AM, JD <5635.daw...@gmail.com> wrote: > > How do I atta

Re: $$Excel-Macros$$ Macro to clean up file

2010-07-25 Thread Sandeep Kumar Maurya
Hi, I got your file but next time use gmail and attach in the mail. Thanks & Regards Sandeep On Sun, Jul 25, 2010 at 1:02 AM, JD <5635.daw...@gmail.com> wrote: > How do I attach? I placed in file section of > MS EXCEL AND VBA MACROS. > > > On Jul 24, 5:35 am, Sandeep Kumar Maurya > wrote: >> Hi

Re: $$Excel-Macros$$ Macro to clean up file

2010-07-24 Thread JD
How do I attach? I placed in file section of MS EXCEL AND VBA MACROS. On Jul 24, 5:35 am, Sandeep Kumar Maurya wrote: > Hi JD, > > You forgot to attach file. > > Thanks & Regards > Sandeep > > On Sat, Jul 24, 2010 at 5:52 AM, JD <5635.daw...@gmail.com> wrote: > > I am looking to clean up a file

Re: $$Excel-Macros$$ Macro to clean up file

2010-07-24 Thread Sandeep Kumar Maurya
Hi JD, You forgot to attach file. Thanks & Regards Sandeep On Sat, Jul 24, 2010 at 5:52 AM, JD <5635.daw...@gmail.com> wrote: > I am looking to clean up a file that gets sent to me weekly see > "example file.xlsx" on file page. The file may look like the first tab > the 1st week it is sent to me

$$Excel-Macros$$ Macro to clean up file

2010-07-23 Thread JD
I am looking to clean up a file that gets sent to me weekly see "example file.xlsx" on file page. The file may look like the first tab the 1st week it is sent to me and like the second tab the 2nd week it is sent to me but I need it to look like the 3rd tab all the time for import into database. Ca