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 sandymau...@gmail.comwrote: 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

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 sandymau...@gmail.com

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 and

$$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. Can