Re: Fwd: $$Excel-Macros$$ Macro for Segrating and file creation

Thanks a tonn Alpeshah... Macro provided by you solves the Segregation part... Can any other group member help me out for workbook creation? *Conditions/Criteria* > 1. Delete columns C,I, U,X,Y,Z - Solved by Alpeshah > > 2. Delete the rows which has "180" in column A - Solved by Alpeshah > > 3.

$$Excel-Macros$$ Convert Numeric Value in Character.....

Dear Experts, I need to convert Numeric Value in charaters..Is it possible through excel or Macro. Example... 25302- *Twenty Five thousand three hundred two.* With Advance Thanks, Noorain Ansari -- -- Some import

Re: $$Excel-Macros$$ Code Help

Hi Mithlesh, Thanks for sending formula..it solve my problem.. Regards Nikhil On Mon, Aug 9, 2010 at 12:15 AM, Mithlesh Sharma wrote: > Hi Nikhil, > > Try this one, will give result in VPS. > > Vishal Pravinchandra Shah > > =LEFT(A1,1)&MID(A1,FIND(" ",A1,1)+1,1)&MID(A1,SEARCH(" ",A1,FIND(" > "

$$Excel-Macros$$ Open pipe delimited file

Hi all, When I open a pipe delimited file in excel it opens the file but does not put the data per cell as expected. Is there an option to have excel open a pipe delimited file appropriately as it does for comma delimited files? Thanks, Mat -- --

Fwd: $$Excel-Macros$$ Question asked in Interview...

Hi, But Interviewer need this thing through a macro only. And second thing that when we enter the value to cross that limit then it will not allow to enter that value as well. Please provide some more help on this. Thanks once again. Regards, Vijay Kumar Aggarwal 048542 -- Forward

Re: Fwd: $$Excel-Macros$$ Macro for Segrating and file creation

Hi Vinod, This is not the most efficient way, however I did not have enough time to make it ideal. I have re-used code found on the web in certain cases, source include: http://www.rondebruin.nl/delete.htm for the delete row. Sub code 1 deletes 180 value Sub code 2 deletes "Z0,1,2,WW" Sub code 3

$$Excel-Macros$$ Can I Run SQL Queries with help of Macro

Hi Friends, Can i Run Multiple SQL Query using Macro, in Multiple sheets -- With Best Regards, Vilas Chavan Email : cvi...@ymail.com, vilaschav...@gmail.com Mumbai - Maharashtra -- -- Some important links for ex

$$Excel-Macros$$ Re: Month Code Query

Hi Nikhil, If you are looking for formula that will provide the following output Column A January February March Column B Jan Feb Mar I would suggest using excel's function: Left(string argument, length returned). So in this case, if January were in cell A1, then the formula would be LEFT(A1,3).

Re: $$Excel-Macros$$ Question asked in Interview...

Hai, Our Favourite buddy in this group Mr. Dave has already given attention and replied to your query please see it again. I hope you might not have seen it. Regards Ahmed On Sun, Aug 8, 2010 at 6:51 AM, Vijay Kr. Aggarwal wrote: > Hi Friends, > > > If question is not clear in attached file th

$$Excel-Macros$$ Assistance Required

Dear Experts, In the attached excel sheet i have employees attendance details for the entire month (Leaves - Violet, On Duty - Yellow, Present - Green Etc) with different color fills. I need the count of leaves, On duty, Etc for each employee. Is there is any way to count color wise, for each emp

Re: $$Excel-Macros$$ Code Help

Hi Nikhil, Try this one, will give result in VPS. Vishal Pravinchandra Shah =LEFT(A1,1)&MID(A1,FIND(" ",A1,1)+1,1)&MID(A1,SEARCH(" ",A1,FIND(" ",A1,1)+1)+1,1) Regards, Mithlesh Sharma On Sun, Aug 8, 2010 at 7:13 PM, Nikhil Shah wrote: > Hi Friends, > > In Column " A " .. I have written ---

Re: $$Excel-Macros$$ Month Code Query

Dear Nikhil, Use *left *function left(a1,3) Regards Sudhir Ingale On Sun, Aug 8, 2010 at 2:48 PM, Nikhil Shah wrote: > Hi Friends, > > I have written In Column " A " ...January ... > > Now I want in Column " B " should be ..Jan ...only...I want formula..( No > Macro ) > > Awaiting Reply > > Tha

Re: $$Excel-Macros$$ Month Code Query

Hi Nikhil You can use function of LEFT Column A Column B January =LEFT(A1,3) On Sun, Aug 8, 2010 at 6:48 AM, Nikhil Shah wrote: > Hi Friends, > > I have written In Column " A " ...January ... > > Now I want in Column " B " should be ..Jan ...only...I want formula..( No > M

Re: $$Excel-Macros$$ Month Code Query

Hi Nikhil you can use =LEFT(A1,3) , i dont knw what exact you looking for but you can enter date in column A cell then go to Format cells-custom select date type as "" then use =TEXT(A1,"mmm") formula in B column so even if you change the month in A column it will show only 3 Alphabet in B co

Re: $$Excel-Macros$$ Code Help

Hi Nikhil Insert this code in a standard module Function FirstLetters(rng As Range) As String Dim arrWords Dim I As Long arrWords = Split(rng, " ") If IsArray(arrWords) Then For I = LBound(arrWords) To UBound(arrWords) FirstLetters = FirstLetters & Left(arrWords(I), 1

$$Excel-Macros$$ save all sheets as csv and KEEP xls format open for edit (Excell 2003)

Dear All, I'm new to this group and my programming skills in VBA are a bit outdated. Writing some csv file is quite easy, but I have some restrictions with it. Hoever, I would like to ask for some quick help on this: I have a workbook (active) and want to create a vba macro manages to: 1) save al

$$Excel-Macros$$ Code Help

Hi Friends, In Column " A " .. I have written --- > Vishal Pravinchandra Shah . Now I want In Column " B " should be VPSautomatically..I want Formula I want First Letter Of First Name ; First Letter Of Middle Name ; First Letter Of Last Name in one column.. Awaiting Reply.. Thanks Nik

$$Excel-Macros$$ Month Code Query

Hi Friends, I have written In Column " A " ...January ... Now I want in Column " B " should be ..Jan ...only...I want formula..( No Macro ) Awaiting Reply Thanks Nikhil -- -- Some important links for excel users:

Re: $$Excel-Macros$$ Pivot table problem

Hi Deepak Rawat, You can create a calculated pivot field. it´s possible by accessing Options tab (when selected a pivot table cell) and click on formulas button. I´ve created the formula in the attached file. Regards, FLemos. 2010/8/7 Deepak Rawat > Hi all > > I have attached a file containg

$$Excel-Macros$$ USE OF AUTO CORRECT & THEN EDIT THE SAME CELL WITHOUT F2

Hellow Friends, I want to know is it possible to do the following I am using Excel 2007 version. I have added in Auto Correct option -- Replace [ .m] & With No. [ 34/09/11/] It works properly -- but i want to do that i have to enter always some no. after that say ex. 359535 etc Now w

Fwd: $$Excel-Macros$$ Question asked in Interview...

Hi Friends, If question is not clear in attached file then please do let me know your cell number. I will elaborate this. Ayush, Dave, Mahesh, Dilip, Vinod, Paul, Harmeet :- It is my humble request to you to pay your special attention to solve this question. Regards, Vijay Kumar Aggarwal 99