Keebellah

Hi Keebellah
Thanks for reply I have posted a file with what I attempt to achieve
Regards Steve

Hi Hans, sorry for delay, just been out to get a new internet modem, my connection is much better now. I think what I will do is send you my complete 2003 wb so that you can see exactly what is what. If you sell it, we go halves on the profit. It is a diamond pricing calculator, really useful to jewelers. As you will see,it has 30 sheets, 24 of which contain data bases and conversion formulas. Before I send it you must tell me if you have the means to open the password protected vba editor. If you haven't then let me know.
Regards, John

Hi Keebellah,

Again...thanks for your help!

-tennisfrk159

Hi! It has been a long time - I have been unemployed since Jan. of 2011 and don't have a new version of Office (I have been using LibreOffice instead, but I don't really like it much.) The lack of a newer version has meant that I haven't been able to assist people on here much. I miss it, but oh well....

Hi mate need a formula for a an excel sheet...
If I type firstname lastname in cell A, cell B should auto populate with firstname.lastname@abm.com (ex: satish babu in cell A = satish.babu@abm.com in cell B).... This formula did not work anyother suggestion (=LEFT(A1,FIND(" ",A1)-1)&"."&SUBSTITUTE(A1,LEFT(A1,FIND(" ",A1)),"")&"@XYZ.COM")

Hello Hans, I just saw your note from January! Sorry I missed it. I like your function. As little overhead as the constants carry, since they are loaded at time of compile, I don't mind just concatenating what I need together, and would use less resources during run time. Why did you not just use the String() function, why the loop?

Hi Kebelah,

You helped me on a macro find and replace back in december. Now i want to reverse column c to show the sku and not the number id. i have attached a link to the original post below
http://forums.techguy.org/business-a...ml#post8195167

please advise

Hi Hans...
I hope yo are well... would yo need me to post the attachment here,
http://forums.techguy.org/business-a...cel-macro.html

hi Keeellah,

Can you look at this post, I don't have time right now....

http://forums.techguy.org/showthread...2&goto=newpost

Hi Hans,

Hope you have a great new year.

I need your help in one of my older post called Combining 30 text files into single text file. In this thread you have given one VB script file for removing header in the output file. I have clarification that whether i need change any coding that because for running that Vb script file for the month of December i am getting error that "Kmart_1211.txt" does not contain any data. Actually i check file also it having only December month data.

I think the problem is because of the year. The output file have the data of December 2010 (1210), But if run the VB script now it will consider as 2011, i think this is the confusion.

http://forums.techguy.org/business-a...ext-files.html

Please help me on this.

Regards,

Vinoth S