JaseSt
asked on
Import spreadsheet from an attachment on an email to my production spreadsheet
gowflow, continuing on and as you suggested you could do:
When an email comes in from our Western Union representative he has a copy of the spreadsheet I originally sent him with values filled out in Col H. I need those values automatically inserted into my Col H of the WU-Staging-FBME sheet - which you have.
There needs to be checking that the value from his Col H is put into the correct row of my Col H by checking the MTCN# (Col D), the Remitter (Col E) and maybe the Sender City and County (Col F) before the value from his Col H is inserted into my Col H.
Let me know what else you need. Thank you once again for helping me out.
When an email comes in from our Western Union representative he has a copy of the spreadsheet I originally sent him with values filled out in Col H. I need those values automatically inserted into my Col H of the WU-Staging-FBME sheet - which you have.
There needs to be checking that the value from his Col H is put into the correct row of my Col H by checking the MTCN# (Col D), the Remitter (Col E) and maybe the Sender City and County (Col F) before the value from his Col H is inserted into my Col H.
Let me know what else you need. Thank you once again for helping me out.
ASKER
Sorry, This is for working with the Visa file where the WU-Staging-FBME sheet resides.
ok fine.
So to summ it up,
The file that is issued from the Visa file and sent to the Western Union representative, is updated in Col H and you need these updates to be reflected in the current Visa file (for sure matching the correct records)
Correct ?
gowflow
So to summ it up,
The file that is issued from the Visa file and sent to the Western Union representative, is updated in Col H and you need these updates to be reflected in the current Visa file (for sure matching the correct records)
Correct ?
gowflow
ASKER
Correct. That is step 1.
The next step (next question) will be to sum up those amounts in Col H from the specific batches and put that total in the top row for each batch in Col i - which I have indicated already kicks off a code - as imperfect the code that kicks it off is.
The next step (next question) will be to sum up those amounts in Col H from the specific batches and put that total in the top row for each batch in Col i - which I have indicated already kicks off a code - as imperfect the code that kicks it off is.
ok so can we call this a new command button Import data from WU or whatever ... ?
gowflow
gowflow
ASKER
Yes. I guess you can call it: 'Import WU Spreadsheet from Email'. Maybe that's too long. :)
or Import WU Confirmed Amts
gowflow
gowflow
ASKER
sure, that's better
Question
1) Is it possible that amount in an item to be originally say 1000 and confirmed from joseph comes say 800 and in a future batch comes the same item for the balace of 200 ? like the amount to be confirmed can come split or less than the original or more for that matter ?
gowflow
1) Is it possible that amount in an item to be originally say 1000 and confirmed from joseph comes say 800 and in a future batch comes the same item for the balace of 200 ? like the amount to be confirmed can come split or less than the original or more for that matter ?
gowflow
ASKER
no, Josef can only pick up the full amount or none at all. however, it does happen where the amount he actually picks up is slightly different (WU will allow a 10% difference) than the amount I submitted to him
yes but when its diffrent still you would plugin hte amt he posted right ?
gowflow
gowflow
ASKER
whatever he puts in Col H I plug into my Col H - and sometimes as you see in the screenshot from the related question before, he tells me if something is wrong with the pick up and puts that into Col H
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
gowflow goes for it again!!!
Thank you. I will try it out tomorrow.
Thank you. I will try it out tomorrow.
ok let me know.
gowflow
gowflow
ASKER
While I don't normally save the spreadsheet attachment that Josef sends me, I guess I can do that and doing so it seemed to run perfectly with your code.
I'll close this question, however, will need to run it more over the days to come when he sends me other sheets I can test the code against to see if there are any glitches. But for now, perfecto!! Thank you, gowflow. A wizard you are.
Next part coming up.
I'll close this question, however, will need to run it more over the days to come when he sends me other sheets I can test the code against to see if there are any glitches. But for now, perfecto!! Thank you, gowflow. A wizard you are.
Next part coming up.
your welcome and glad we nailed it ... pretty fast or I should say at a logical normal speed !!! :))
ok waiting for your next one
gowflow
ok waiting for your next one
gowflow
ASKER
Next up is this:
A button on the WU-Staging-FBME sheet so that when clicked does this:
1. Sums the individual batch amounts in Col H and inserts that total in Col i of the top row of that batch only for those where Col H has a value for each record in the batch. (A "batch" is the batch of records brought in from a single email. See attached.)
If any row in a single batch has an empty value in Col H that means it has yet to be picked up by our receiver and therefore the batch can receive no further processing until all rows in the batch have SOME value.
2. When Col i is filled in it then should kick off the code that is already there, however - and here is a tricky part - I need this formula to instead of putting 1.4 in Col U to look up and input the current USD to Euro conversion rate. Is that possible?
The code that kicks off calculations and input for Cols T - Z is located in Sheet2 (WU-Staging-FBME). It can be removed and replaced with your code if you wish, of course.
Furthermore, the button should only effect those batches where Col i is filled in AND where Cols T-Z are NOT filled in already.
Thank you.
Let me know if any questions and I will then submit as a question.
A button on the WU-Staging-FBME sheet so that when clicked does this:
1. Sums the individual batch amounts in Col H and inserts that total in Col i of the top row of that batch only for those where Col H has a value for each record in the batch. (A "batch" is the batch of records brought in from a single email. See attached.)
If any row in a single batch has an empty value in Col H that means it has yet to be picked up by our receiver and therefore the batch can receive no further processing until all rows in the batch have SOME value.
2. When Col i is filled in it then should kick off the code that is already there, however - and here is a tricky part - I need this formula to instead of putting 1.4 in Col U to look up and input the current USD to Euro conversion rate. Is that possible?
The code that kicks off calculations and input for Cols T - Z is located in Sheet2 (WU-Staging-FBME). It can be removed and replaced with your code if you wish, of course.
Furthermore, the button should only effect those batches where Col i is filled in AND where Cols T-Z are NOT filled in already.
Thank you.
Let me know if any questions and I will then submit as a question.
ok post it and if I hv questions I will ask
gowflow
gowflow
ASKER
ASKER
gowflow, also have another urgent one, if you could, as an edit to one you worked on earlier:
https://www.experts-exchange.com/questions/27613437/Import-data-from-spreadsheet-to-another-based-on-value-found-in-both-spreadsheets.html
Sorry, but this one is a big, time consuming problem that needs solving.
https://www.experts-exchange.com/questions/27613437/Import-data-from-spreadsheet-to-another-based-on-value-found-in-both-spreadsheets.html
Sorry, but this one is a big, time consuming problem that needs solving.
MC workbook is Mastercard ?? Are we not updating Visa file ???
gowlfow