$$Excel-Macros$$ Re: Excel to Oracle (urgent Please help)

2009-08-17 Thread vijender kumar
Hi I think you can use the WEB ADI functionaly to upload data in ORacle AP.. On 8/17/09, bala Subrahmanyam puligadda simplyb...@gmail.com wrote: Hi All, Can anyone help me in loading the excel information to Oracle Applications. I have a list of transactions which I manually enter in

$$Excel-Macros$$ Re: How to unhide the sheet

2009-01-17 Thread vijender kumar
Just go to Fomat sheet unhide the sheet. On 1/16/09, vinu vinu1sm...@gmail.com wrote: hello frnds, Whenever I open Excel new file(2003) I can see only sheet 1 and 3, sheet 2 is hidden. I tried to unhide by using Menu. It didnt work. Even I open the VBA and seen sheet 2 named as

$$Excel-Macros$$ Re: Hide Formula or data in column

2009-01-06 Thread vijender kumar
Hi ... you can hide the column in very simple way Select the column Right Click with your Mouse click on Hide On 1/5/09, Keyur Shah keyursha...@gmail.com wrote: hi, Can anybody guide me how to hide data in column sothat no one can visible and i want to lock sheet that mouse pointer

$$Excel-Macros$$ Re: Excel Macro

2009-01-06 Thread vijender kumar
Hi Tom, Thanks this book is very useful. but do you have any such book which has more examples of macro .I am very keen to learn macros to automate most of my process. Thanks. On 1/4/09, Kamal Gulati kamalgula...@gmail.com wrote: Thanks a lot Mr. Tom, for the nice file for the

$$Excel-Macros$$ Re: how to make read only file in the particular folder

2009-01-04 Thread vijender kumar
On Tue, Dec 30, 2008 at 2:05 AM, vijender kumar simplevi...@gmail.comwrote: Hi to All, I have problem if you guys have solution then please provide me. My probelm is I have 20 or 30 folders and each folder containing 30 to 40 excel file which I have to sent to the market. and I have to protect

$$Excel-Macros$$ Re: Count function

2008-12-03 Thread vijender kumar
Use Pivot table Option for this On 12/3/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I have to use Count function, and I have multiple criteria's for example I have to count the number of times a person's name is apperaring in a sheet and again count if he is active member or not from the

$$Excel-Macros$$ Re: Concatenate Formula

2008-10-28 Thread vijender kumar
Hi, Use the below formula. =A1B1TEXT(C1,(dd-mm-yy)) On 10/26/08, karthik balasubramanian [EMAIL PROTECTED] wrote: Hi, Use this formulae: =CONCATENATE(E17,F17,TEXT(G17,[$-409]d-mmm-;@)) COL: E F G ROW ms excel 24-oct-2008 E17 is ms F17 is excel

$$Excel-Macros$$ Re: Concatenate Formula

2008-10-24 Thread vijender kumar
hi. do one thing first paste special the cell value which has date then try concatenation On 10/24/08, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi All, I have an issue while using concatenate formula, Can any one of you help me out with this: Query: Column A : MS Column B : Excel

$$Excel-Macros$$ Re: change from small letter to capital

2008-09-21 Thread vijender kumar
Hi, Just use this formula =upper(cell reference) On Sat, Sep 20, 2008 at 5:22 PM, vinay keni [EMAIL PROTECTED] wrote: dear all, i want to know how to change from small letters to capital letters as i have some 500 persons name which i have typed in small letters now wants to

$$Excel-Macros$$ Re: Vlookup Help

2008-09-03 Thread vijender kumar
Hi Rishi, In first case you can you can copy the vlookup formula from one cell to another cell where you want the result. or just drag the formula. second case this is not posibble because vlookup formula find the exact value. On 9/2/08, rishi dakalia [EMAIL PROTECTED] wrote: Thanks a lot