$$Excel-Macros$$ Inbox by Gmail Invite for Excel Macros Group.

2014-11-14 Thread Vaibhav Joshi
Friends, I have few Inbox by Gmail Invite, wish to share with you all. Send me an email if you want one do not reply to this message if you need one. Read more about this product: http://www.tuaw.com/2014/11/12/google-inbox-is-a-handy-way-to-optimize-your-gmail-with-a-few-ca/ Cheers!! --

Re: $$Excel-Macros$$ Help Required in MS Access(Urgent)

2014-11-14 Thread priti verma
Please try these query. Query1. SELECT Table1.Name, Table2.NAme FROM Table1 INNER JOIN Table2 ON cstr(Table1.Name) = cstr(left(Table2.NAme,len(Table1.Name))); query2. UPDATE Table1 INNER JOIN Query1 ON Table1.Name = Query1.Table1.NAme SET Table1.Name = [Query1].[Table2]![NAme] WHERE ((Not

Re: $$Excel-Macros$$ To create a sheet with macro and overwrite on next attempt

2014-11-14 Thread Ashish Kumar
Hi Pravin, PFA!! Edit your data in Pending CN and Highlight the row which you want to paste in Party Wise and hit the macro. Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum

$$Excel-Macros$$ Re: How to Get Data of 527 employees from One Excel Sheet to another Sheet on given proforma

2014-11-14 Thread MRafique Ujjan
Hi Dear Excel Experts! I am still looking for solution, plz help me to get me out of problem. Thanks in advance ___ M. Rafique -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

$$Excel-Macros$$ *** mask password in inputbox

2014-11-14 Thread Eirik
Hello! I am trying to get this access code to work. It's for making in the field of an inputbox, so the password cant be seen. I's originally a code for a 32 bit system, so the real challenge here is converting it to 64 bit. The code are: Public sPwd As String Public gMsgTitle As

$$Excel-Macros$$ Re: *** mask password in inputbox

2014-11-14 Thread Eirik
Posted this on other forums; Just for information (got some angry moderators breathing down my neck;): I have posted this issue on several forums, simply because I don't think it's an easy fix, and most likley It's just a few people who can solve this. Where they are is hard to know, so I have

$$Excel-Macros$$ Re: Fix the Shape

2014-11-14 Thread Mandeep Baluja
Try Freeze panes On Thursday, November 13, 2014 4:38:49 PM UTC+5:30, Eugene Bernard wrote: Hi all, FInd attached an excel sheet, where in i pasted a circular shape in that sheet. Whenever i scroll down the row, or move accross the column, I want keep the circle on the same position. ie

$$Excel-Macros$$ Re: How to Get Data of 527 employees from One Excel Sheet to another Sheet on given proforma

2014-11-14 Thread Mandeep Baluja
Mr. Rafeeq Let me tell I have faced the same problem while preparing the invoice for various vendors. I can only provide you the way to create each and every sheet in separate pdf. if you want. But still question is I dont' understand dt his amount will be calculated from Source Data!Sheet (G4)

Re: $$Excel-Macros$$ Query on count

2014-11-14 Thread Waseem Saifi
Hi Kal Excel, PFA resolved query of yours. Regards, Waseem Saifi On Thu, Nov 13, 2014 at 5:11 PM, Kal xcel kalx...@gmail.com wrote: Dear Experts, Please help me to solve my query. Thanks in advance -- *Kalyan Chattopadhyay* *Executive Corporate MIS* *Joy Cosmetics* -- Are you

Re: $$Excel-Macros$$ Re: Fix the Shape

2014-11-14 Thread Eugene Bernard
Thanks, I am, temporarily doing by this mehod only. regards Eugene On Sat, Nov 15, 2014 at 9:49 AM, Mandeep Baluja rockerna...@gmail.com wrote: Try Freeze panes On Thursday, November 13, 2014 4:38:49 PM UTC+5:30, Eugene Bernard wrote: Hi all, FInd attached an excel sheet, where in i

Re: $$Excel-Macros$$ Fix the Shape

2014-11-14 Thread Ashish Kumar
Hi Eugene, PFA...! Use down arrow key to scroll down the sheet. Shape will appear on the top always. Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @