Forum

OK so that's a fail - I'm not sure about the purpose of Application.InputBox or why its different to the InputBox function after all. According to MS ...

Thanks mate, I didn't know there were two types of InputBox ... <sigh> Anyway I tested it and it didn't work in the sense that it allowed me ...

Thanks mate, you're a champ!

Yeah I've seen that one and it doesn't really do it for me ... the throw away line '... by subtracting the result of a calculation that uses the WEEKD...

Firstly, you'll need to get an understanding of Excel's Date arithmetic - this is a good source: Basic tracking could involve IF statements whe...

Hi Mynda I'm not sure what you mean by "select the merged column > Transform tab ...". I'm on Excel 2010 so I don't have a Transform tab, and my...

Thank you Sunny, I think this may have cracked it. My only concern is the non-uniqueness of the dates may produce erroneous results but that will t...

Thanks for that. We can't assume anything about the value of the ID and its relationship to Createdate, but I think your suggestion will work so lo...

I know what you mean - on an old box I used to run Office 2003 and Office 2007 and although it didn't seem to cause problems, Office was forever re-co...