Hello!
Thank you all so much for your help and effort on my previous post - actually I did not know a couple of things that I needed to include.
I did not know how to paste my code into the forum, so the macros and other suggestions did not work. I have downloaded the Jeanie tool so I can paste properly. Here is the actual code I need to extract the TAX and SHIPPINGTAX number from (again, in this example it is $8.76 and $1.50).
I am using Excel 2002 but also have access to 2007 if necessary.
Now, please note that I need to calculate both the TAX and the SHIPPINGTAX amounts. In this case, that is 8.76 for TAX and 1.50 for SHIPPINGTAX. It can be in separate columns or in the same, doesn't matter.
There are a few hundred of these orders that I need to go through, and it would greatly help me. Can you please help now that I have pasted it properly? I am so thankful I found this place!
Thank you all so much for your help and effort on my previous post - actually I did not know a couple of things that I needed to include.
I did not know how to paste my code into the forum, so the macros and other suggestions did not work. I have downloaded the Jeanie tool so I can paste properly. Here is the actual code I need to extract the TAX and SHIPPINGTAX number from (again, in this example it is $8.76 and $1.50).
I am using Excel 2002 but also have access to 2007 if necessary.
| Excel Workbook | |||
|---|---|---|---|
| A | |||
| 439 | |||
| 440 | |||
| 441 | *105-8920931-7716261 | ||
| 442 | *2011-05-01T04:39:41+00:00 | ||
| 443 | *2011-05-01T11:38:02+00:00 | ||
| 444 | *Shipped | ||
| 445 | *Merchant.com | ||
| 446 | * | ||
| 447 | * *Merchant | ||
| 448 | * *Standard | ||
| 449 | * * | ||
| 450 | * * *SHERMAN | ||
| 451 | * * *TX | ||
| 452 | * * *75090-3488 | ||
| 453 | * * *US | ||
| 454 | * * | ||
| 455 | * | ||
| 456 | * | ||
| 457 | * *B0022R74BC | ||
| 458 | * *MN-UPDC-Q1H3 | ||
| 459 | * *Shipped | ||
| 460 | * *Merkur Futur Double Edge Safety Razor #700 + 5 Free DE Razor Blades | ||
| 461 | * *2 | ||
| 462 | * * | ||
| 463 | * * * | ||
| 464 | * * * *Principal | ||
| 465 | * * * *140.0 | ||
| 466 | * * * | ||
| 467 | * * * | ||
| 468 | * * * *Tax | ||
| 469 | * * * *8.76 | ||
| 470 | * * * | ||
| 471 | * * * | ||
| 472 | * * * *Shipping | ||
| 473 | * * * *23.99 | ||
| 474 | * * * | ||
| 475 | * * * | ||
| 476 | * * * *ShippingTax | ||
| 477 | * * * *1.5 | ||
| 478 | * * * | ||
| 479 | * * | ||
| 480 | * | ||
| 481 | |||
| 482 | |||
April 1 - April 30 Orders | |||
Now, please note that I need to calculate both the TAX and the SHIPPINGTAX amounts. In this case, that is 8.76 for TAX and 1.50 for SHIPPINGTAX. It can be in separate columns or in the same, doesn't matter.
There are a few hundred of these orders that I need to go through, and it would greatly help me. Can you please help now that I have pasted it properly? I am so thankful I found this place!
