comibantion of various functions

  • Thread starter Thread starter fflores818
  • Start date Start date
F

fflores818

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
 
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.
 
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 youup
something.
Just let me know.








- Show quoted text -
Click to expand...

Hi MIke.
What e-mail should I send you the file to?
thank you for your help.
Francisco
 
Francisco,
Send to (e-mail address removed)
Also on another sheet or a different workbook show what you want the sheet
to look like when finished.

Thanks Mike
 
Back
Top