Search results

Good evening. I created a python code which, due to a naming error given to the sheet, instead of pasting the rows into the same Excel sheet, one below the others, created as many sheets as there are rows of extracted data by inserting the extracted data into the first line. Would it be...

I tried again and it went well. Thank you for everything (even for using the formulas in Italian) Have a good time :)

thanks for the formulas. the formula " E2:" doesn't work. the zip code is linked to the city, not the province. so when the city and province match then the postal code should be entered

Good morning. I have a city file with postal code, city, provinces etc sheet "ITALIAN CITIES"). Starting from the "ADDRESSES" sheet, I would need a formula that lays out the address by first entering the street (the part after ")", then the postal code and then the city and province initials "in...

There is not only to extract the coordinates from column F but extract them and insert them at the same way. Streets are not in the same row

Thank you for your intervention. Unfortunately it is not what I was looking for because your formulas provide that the ways are equal on the same line instead it is not so. You should look for the same way as column a in f and then with the same way extract the coordinates. In addition...

Good morning. I have an excel file that contains addresses in column a. I'm using a system to obtain the geographical coordinates online which I copy next (coonna f of the file). I would like to insert in column "b" and "c" formulas like an index compare which by associating the two addresses...

Resolved. I used the formula translator. Thank you

the formula doesn't work. Could you apply it directly to the file?

they concern the same file and data. It would be better to use the same post, don't you think?

I would like the order to happen first based on date and then when the dates are equal based on number. Example Risposta n. 20 del 12/2/2023 Risposta n. 40 del 20/3/2020 Risposta n. 19 del 12/2/2023 becomes in order: Risposta n. 40 del 20/3/2020 Risposta n. 19 del 12/2/2023 Risposta n. 20 del...

I would also like to extract the number. The one between "n." and the date in order to sort them by date, and if the date is the same, progressively by number. If it were possible to do everything in one formula it would be better, to have one column Is possible?

thanks

Good evening. I extracted the date from the first column with the aim of sorting the column from the most recent to the oldest date. If you notice they are not sorted correctly. Can you help me? Thank you

:(

the links code i posted use excel vba code, right?

do you always use vba code if you work on outlook?

VBA excel

Could you help with the VBA?

could you help me do it?

I have a macro that sends emails with the CDO system. It would be useful for me to find a way to save received emails as files in the .eml format in order to save both the text of the email and the attachments in one file. Would this be possible?

HI. I found this on the web: https://www.howtoexcel.org/how-to-import-your-outlook-emails-into-excel-with-vba/ https://www.example-code.com/excel/pop3_saveAttachments.asp https://www.example-code.com/excel/imap.asp...

Good morning. Could you help me by showing me the most complete macro that has been posted in this forum that allows you to completely manage the sending and receiving (with elimination from the mail) of emails? Thank you

hi. This code allows you to save emails received using outlook?

I thought you had a solution :(