Forum

Hi Stephan, You can use INDIRECT to reference the year in Column A, for example in D6 you could have =INDIRECT(TEXT(A6,"yyyy")&"!$V$32") ...

Hi Adam, Please see attached and compare to your solution. After unpivoting the date columns, I've grouped by Country and Date to give the final...

No worries Pat. Learning VBA can put years on you 🙂

Hi Marsil, That is a Microsoft Exchange user. Are you connected to Exchange? Phil

Hi Pat, There's a few things there that need fixing up. You have an IF statement with lots of OR conditions and these conditions are carried ove...

Hi David, You check from the account setup in Outlook. It'll depend on your version of Outlook but it'll be something like File -> Account Sett...

Hi Steve, In Private Sub Arow5_Change() you can use Me.Arow6.Value = Arow5.List(Arow5.Value, 1) Regards Phil

Hi David, There seems to be some confusion which isn't helped by you not answering my questions. The code I've written is to read emails from a ...

Hi Marsil, Try this. regards Phil

David, Is your OST file attached to Outlook and in use with an email address? Or is it just a file in a folder? Phil

Hi Adam, Without actually seeing your data I can't give the best answer. You could perhaps use Power Query though that maybe overkill. You could ...

yes, these qs seem like homework ....

Hi Deepak, Without your workbook we have to enter everything by hand. That not only takes time, it makes things prone to error, and it means we ar...

Hi David, In Reply #4 of this thread I explained how to change the VBA. Open the file I created, press ALT+F11 to open the VBA editor then make th...