Francisco,
Send to
(E-Mail Removed)
Also on another sheet or a different workbook show what you want the sheet
to look like when finished.
Thanks Mike
"fflores818" wrote:
> On Nov 17, 1:22 pm, Mike <M...@discussions.microsoft.com> wrote:
> > It can be done. But it would be easier to have the workbook to write the
> > code. If you want you cab send me a copy of the workbook and can code you up
> > something.
> > Just let me know.
> >
> >
> >
> > "fflores818" wrote:
> > > Hi. I am new into the group.
> > > I have a new excel sheet that I create everytime I run a SQL query. I
> > > pull information from MAS90 software.
> > > Some of the information I'm getting is:
> > > PO number Item #, QTY, Description 1.
> > > This is the problem:
> > > For every PO#, I could get up to four lines.
> >
> > > 248020145 788904611392 RV JCP 600 PRESTIGE WGD COMF-K 1
> > > 248020145
> > > 00000000000000000020
> > > 248020145 788904611378 RV JCP 600 PRESTIGE WGD COMF-T 1
> > > 248020145
> > > 00000000000000000012
> > > 349236056 788904641382 FV JCP PRESTIGE WGD PILLOW-Q 2
> > > 349236056
> > > 00000000000000000017
> >
> > > How do I combine the second line (...000020) to the first one and the
> > > fourth one to the third one?
> > > I need to check if the PO column is the same. if it is,
> > > then if the item # cell is emty (Column B) copy F6 to F5 and delete
> > > the entire row.
> >
> > > Repeat the check for the PO # column.
> > > Bottom line is to end up with one row of just one PO #, item #,
> > > description, qty, and "long number"
> > > Is there anyone who can helo me figure this out?
> > > Thank you.
> > > I will appreciate it enternaly.
> > > Francisco- Hide quoted text -
> >
> > - Show quoted text -
>
> Hi MIke.
> What e-mail should I send you the file to?
> thank you for your help.
> Francisco
>
Similar Threads
