|
comibantion of various functions
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 |
comibantion of various functions
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 |
comibantion of various functions
On Nov 17, 1:22*pm, Mike 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 |
comibantion of various functions
|
| All times are GMT +1. The time now is 05:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com