Re: $$Excel-Macros$$ Moving Row Data to the Left Forcing Blank Cells to the Right

2014-05-22 Thread JohnA
ou can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > ------------- > >*From:* John A. Smith > > *To:* excel-...@googlegroups.com > *Sent:* Wednesday, May 21, 2014 12:56 PM > *Subject:* $$Excel-M

Re: $$Excel-Macros$$ Moving Row Data to the Left Forcing Blank Cells to the Right

2014-05-21 Thread Paul Schreiner
--- From: John A. Smith >To: excel-macros@googlegroups.com >Sent: Wednesday, May 21, 2014 12:56 PM >Subject: $$Excel-Macros$$ Moving Row Data to the Left Forcing Blank Cells to >the Right > > > >My daily download has intermittent blank cells per row based on

$$Excel-Macros$$ Moving Row Data to the Left Forcing Blank Cells to the Right

2014-05-21 Thread John A. Smith
My daily download has intermittent blank cells per row based on the column heading. I need shift all the data to the left leaving the blank cells per row on the right. I am interested in a macro or a formula or both. I have attached a sample file with the required details. Thank you for your on