I have a spreadsheet with 5 tabs. There are a number of things I need to have done with it, but for this question, here's the first.
Currently there is a button on 'Import WU Emails' on the attached spreadsheet. When clicked it goes through my Inbox and inputs the data onto that page and does so fairly well. However, here's what I need changed:
1. Move the button currently on the 'Import WU Emails' sheet to the 'Main' sheet..
2. When clicked input the data to 'WU-Staging-FBME' and NOT to the 'Import WU Emails' sheet. When that is done I will delete sheet, 'Import WU Emails' and move on to the next question.
3. When importing if there is a leading zero for the MTCN number or an ending zero, they must stay when imported to the WU-Staging-FBME sheet. In the code currently used, the leading zero seems to be dropped.
4. Also, if there is any other characters besides a dollar sign, it needs to be removed and not imported.
Please look at the code behind Button 1: Sub Q_26900870() to see how it works. It needs to be improved as it sometimes misses importing if there is not a colon or if the label in the email body is misspelled. Improving how it functions will be a related question after this first part is solved. Thank you.
Example sheet with names and card numbers altered is attached. Visa-Aug2011-EE-Example.xlsm