$$Excel-Macros$$ Sumproduct

Dear All, Can you tell me that what is the work of sum product. -- Thanks For Mail. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2

$$Excel-Macros$$ Fwd: Data required please help me in Sumproduct macro

-- Forwarded message -- From: Rajesh Nair Date: Mon, Apr 19, 2010 at 4:52 PM Subject: Data required please help me To: excel-macros@googlegroups.com Hi All, Please help me to pull data from sheet 1 to sheet2 in a column by clicking a command button ans should be in column I6

RE: $$Excel-Macros$$ Urgent Help Required in a macro

Hi Zac, Can I suggest a simpler approach? Using the Ctrl key, select the 2 cells you want to swap, then use a shortcut key to run this code: Sub swap() If Selection.Count <> 2 Then Exit Sub A = ActiveCell.Value B = ActiveCell.Address For Each c In Selection c.Select

Re: $$Excel-Macros$$ Fwd: Urgent Help Required in a macro

Thanks Ayush, it works nicely now. I received a mail from your personal address and I replied without checing the address thats why this happened. Any how, will be more careful in the future. :-) Thanks again for all the help. On Tue, Apr 20, 2010 at 6:34 PM, ayush jain wrote: > > Hi Ch

$$Excel-Macros$$ Fwd: Urgent Help Required in a macro

Hi Chaudhary, Please note that you should keep our Group email address in all communications. It will help you. I have modified the macro to swap the values. Have a look and it should work now. Let me know if any further assistance is required. The logic based updation of data is possible and so

Re: $$Excel-Macros$$ require default sheet as attached

curiously enough, it works just as well to copy a SHORTCUT pointing to your file to the XLSTART folder. that way, if the file is a shared file, or stored on a network folder for backup purposes, then you can still have it automatically open when you launch Excel without putting it somewhere tha

Re: $$Excel-Macros$$ require default sheet as attached

Files kept in XLSTART folder are always opened when excel starts. Keep the file you want to open in that folder. regards, harsh On Tue, Apr 20, 2010 at 12:35 PM, shivashankar katageri < shankarkatag...@gmail.com> wrote: > Dear all, > > please luk the attached sheet and I require,whenever i open

$$Excel-Macros$$ Re: Urgent Help Required in a macro

Hi ZAC, I have created a user form as per your needs. The shortcut is CTRL + Y and userform will pop up on this shortcut. The data will be updated on click of submit button. The fields will reset on data successfully updated. Please have a look and let me know if any further assistance is require

$$Excel-Macros$$ Urgent Help Required in a macro

Hi Group, I'm working in a huge excel sheet with thousands of entries. I am currently looking for a macro, that when invoked (upon press of a key etc) would open a dialogue box having three fields. The first field being Select Row, In which I can write a row number Like 3, the second filed would c

Re: $$Excel-Macros$$ require default sheet as attached

Find a folder named "XLSTART" in the Program files --->Microsoft Office ---> Office12 and place the excel file there. Regards Yahya On Tue, Apr 20, 2010 at 10:05 AM, shivashankar katageri < shankarkatag...@gmail.com> wrote: > Dear all, > > please luk the attached sheet and I require,whenever

Re: $$Excel-Macros$$ subtracting time

Hey Steve, Does one of these help? =INT((B1-A1)*24)Total hours between two times (4) =(B1-A1)*1440 Total minutes between two times (295) =(B1-A1)*86400 Total seconds between two times (17700) =HOUR(B1-A1)The difference in the hours unit between two times. This value cannot exceed 2

$$Excel-Macros$$ Combined Excel file

Dear All, Need ur help i recvd 10 -14 file on daily basis with same hadder, i have to combined all the file in one excel sheet is there any way with macro or without macro to combined all diff. file in single work sheet. awaited reply thanks in Anticipation Regards Harish Upadhyay 9773284902

$$Excel-Macros$$ require default sheet as attached

Dear all, please luk the attached sheet and I require,whenever i open the excell spread sheet I need to open the attached sheet by default..., please anty helpme out, adavance thanks -- Thanks & Regards Shivashankar.C.Katageri. -- -

Re: $$Excel-Macros$$ Want to forece numbers to look like text with Green Error Flag

Hi Ronald, What about running following macro first, and then sorting the dolumn... Greetings Paul Willekens '=== Sub Omzetten() Dim nRow nRow = 1 While Len(Cells(nRow, 1)) > 0 If IsNumeric(Cells(nRow, 1).Value) Then C

Re: $$Excel-Macros$$ Save As - error - object required

Hi Jonathan, Could it be a problem that you skipped the quots... should be Filename:=strSelectedPath & "\Run1.xlsx" instead of Filename:=strSelectedPath & "\" & Run1.xlsx Kind greetings Paul Willekens -- -- So