Re: $$Excel-Macros$$ Rearrange data: Move and split cells, delete irrelevant info

2012-12-07 Thread Paul Schreiner
>the secondary "odd" part is that in viewing the "PDF-looking report", you (or >someone) CHOSE to enter data in columns E-F-G.. >Is that where the "real" data would end up? >in other words:  is this sample data "consistent" in formatting as the actual >data will be? &g

Re: $$Excel-Macros$$ Rearrange data: Move and split cells, delete irrelevant info

2012-12-06 Thread Becky Kaliq
et me know which direction you'd like to go from here! > > > > > *Paul* > > ------------- > *“Do all the good you can, > By all the means you can, > In all the ways you can, > In all the places you can, > At all the times you can, &g

Re: $$Excel-Macros$$ Rearrange data: Move and split cells, delete irrelevant info

2012-12-06 Thread Becky Kaliq
Paul, I'm very excited to find someone who thinks this will be fun! Once I know more, I'm sure I'll think it's fun, too. :) I'm currently training other staff members, but I will answer your questions as soon as possible later today. I believe we do have the option of exporting as a text file.

Re: $$Excel-Macros$$ Rearrange data: Move and split cells, delete irrelevant info

2012-12-06 Thread Paul Schreiner
Becky, This looks like FUN (I know, sick AND twisted!) --- There's a few things I need to help you out. First of all, do you recieve this data already in an Excel file?  or is it a "flat" text file? If it's a "text" file, it would almost be easier to use VBA to read t