Recent content by Pofski

Marc, thank you for your help as well. I failed to check out your link, but i will still use it for potential future issue's.

Hui, thank you for your help. I managed to adapt your solution to fit completely in our project.

Formula's (which i would personally prefer to use) are not an option in the situation that this file will be used in. Would also recommend using the index/match lookup in place of vlookup for such things.

in my example, the numbers on the sheet "Data" should be completed with the information that can be found on the sheet "Reference".

Hi, I am looking for a vb code that would run through column A on the first worksheet, and looks up each reference number in column A of the second worksheet. After this, if it would find the number in the second list, it should copy the line of information next to the reference number of the...

Narayan, the information that is now in the second drop down should fill in the area I3:I66. This is because this information would be compared with another list of filtered information, to check for differences. Interesting way how you did this though. Never thought to do it like that.

Hello everybody, i remember seeing this somewhere here before, but i seem to be unable to find it. I am trying to create a dynamic list between two values In the attached example you would be able to select a continent (I1), and then all the countries of that continent would be below. Now i...

.... Like i said, i feel stupid now :) Thanks Narayan, will use a substitute to transform all the "," to ".". Sincerely

Hi, this will prolly be something stupid, but here goes. I have a sheet where i have to put some calculations, but for some reason, when i have a number with a "," it doesn't want to be recognized as a number. I tried different things already (putting it as =text(a1,"@"), or using the format...

Fantastic Somendra, now i understand this. And your code is actually a lot simpler. Thank you

Hello, i was wondering if somebody could explain a formula to me. I have been using this formula for almost a year now, and to be honest, whenever i have to re use it, i often wonder how it works. The formula i am speaking of is...

Hi, If you would like the cells to just remain blank, in stead of giving the #value! error, you could just put existing formulas in an iferror. An example would be the D5 formula: =IFERROR(IF($B5>0,C5/($B5*$B5),""),"") Hope this is what you are looking for.

i think you've got it Narayan. It looks correct, and i did seem to have made a mistake in row 16. Thanks a lot, you guys really helped me out again. This is why i love this forum.

free to be implemented.

Unfortunately no Narayan. The company that i work for prefers to not implement vba in their excel sheets. I realise that this does not make it easier.