Find text and reorganzize data

[rizmomin]

Hello:

Please refer to attached file.
I need VB Code or Macro to do the following steps to accomplish my goal:
1. Find "PLU# / Descriptor" in column A.
2. Find next "TOTALS" down in column A.
3. Now you have Start and End Row#'s.
4. Now replace the text in column A cells between above rows with the digit number only in column A.
For Example :
PLU000000000000000032 / FOOD MSC$+ in cell A57 needs to be 32
PLU000000000000000305 / HAMBURGER in cell A58 needs to be 305

5. Now copy the associated data in column D and E into column B and C.
6. Once done need to delete associated data in column D thru I

Please let me know if any questions.

Thanks

Riz

[p24leclerc]

The file you supplied is not an Excel workbook. Seems to be a TXT file.

[rizmomin]

Hello:
Sorry, please find the attached excel file.
Thanks and let me know if any questions.
Riz

[sktneer]

Try this to see if this help.....

Please Login or Register  to view this content.

[AB33]

Hi Riz,
Try the attached.

[rizmomin]

Hello AB33 and sktneer:

Please refer to attached sheet, i have sheet called "Shouldbe".
Please refer to that and i believe AB33 can tweak the code little to get me there.
Please let me know if you have any questions.
Thanks.
Riz

[AB33]

Hi Riz,
I do not see what the issue is. My code was not on the attached and could not see the difference between my code out put and your "Shouldbe".
You need to show me what my code is missing.

[sktneer]

I didn't find any difference in the Sheets "YourCode" and "ShouldBe". On the YourCode Sheet I have used a formula to compare these two sheets whether they differ or not but I didn't find any difference in two sheets. You can refer to the formula in yellow cells in the YourCode sheet.
Would you please explain that what difference between these two sheets you have noticed? Or I am missing something?

[rizmomin]

Hello sktneer:

Please have a look at the file and see the cells B5:C53.
Those should not be deleted.
Please let me know if you have any questions.
Thanks.

Riz

[rizmomin]

Hi AB33 :

In your file,
cell D217:E217 should be in cell B217:C217
Heading Coun1 and Amount1 should be in column B and C.
Delete Column D to I.
Please let me know if you have any questions.
Thanks.


Riz

[sktneer]

Please find the attached sheet and click on the Green Button on Test Sheet to see if you get the desired output now.

[rizmomin]

Hi sktneer:

Yes you got it, works great now.
Thanks a lot.
Riz

[sktneer]

You're welcome Riz and thanks for the feedback as well.

[AB33]

just requires one line of tweaking. Adjusted code attached.