$$Excel-Macros$$ convert daily stock data into weekly data

2013-10-04 Thread asdhhc
Columns(1).Insert With Range(b2, Range(b Rows.Count).End(xlUp)).Offset(, -1) .Formula = =if(and(weekday(b2,2)weekday(b3,2),b3),1,) .Value = .Value On Error Resume Next .SpecialCells(2, 1).Offset(0, 1).Delete Shift:=xlUp .SpecialCells(2, 1).Offset(0,

$$Excel-Macros$$ Excel Header Problem

2013-10-04 Thread Raj Kumar
Hi expert, i have some problem in excel when i open new excel file then some problem in header change and reflect like this A B1 2 C 3 D 12345 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ export table to Excel from a link

2013-10-04 Thread asdhhc
On Thursday, October 3, 2013 11:01:36 PM UTC+8, ashish wrote: check the attached file see if it helps working. Thank you. Plse teach me how to make 'Run macro' icon as per your attached query.xlm regard Ray Ho On Thu, Oct 3, 2013 at 8:24 PM, asd...@gmail.com javascript:

$$Excel-Macros$$ Complicated Formula (automatic add back)

2013-10-04 Thread amar takale
Dear Experts Pls solution my critical formula issue in excel.I hope anyone help me to resolve this issue. Regards Amar -- 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 @

Re: $$Excel-Macros$$ Excel Header Problem

2013-10-04 Thread ashish koul
have u selected r1c1 style follow below steps to change it uncheck it http://en.kioskea.net/faq/15308-excel-switch-to-r1c1-reference-style On Fri, Oct 4, 2013 at 5:16 PM, Raj Kumar rajlu...@gmail.com wrote: Hi expert, i have some problem in excel when i open new excel file then some

$$Excel-Macros$$ Excel 2013 and zoom...

2013-10-04 Thread jpad
Hi All, Looking for some advice or comments. I have some code, that works well in all versions of Excel prior to 2013. To simplify what it does let's just say there is a worksheet with a button on it. When the user presses the button a userform comes up. On that userform are some comboboxes

Re: $$Excel-Macros$$ Re: Pie chart

2013-10-04 Thread joseph camill
Hi, Attached is the file with two examples. I am looking for a similar output to be done using vba. Let me know if you need any further clarification on this. Thanks, Joseph On Wed, Oct 2, 2013 at 12:42 PM, ashish koul koul.ash...@gmail.com wrote: please share the chart On Wed, Oct 2,

Re: $$Excel-Macros$$ Help required in formula.....

2013-10-04 Thread Indrajit $nai
*Wow! you are amazing met. :)* -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any

$$Excel-Macros$$ Urgent Help.

2013-10-04 Thread Rakesh kumar
Dear Friend, i want to use total no of present or absent list using pivot table. Please find the attachment. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- 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

$$Excel-Macros$$ Re: Urgent Help.

2013-10-04 Thread Rakesh kumar
Please find the attachment. On Sat, Oct 5, 2013 at 11:22 AM, Rakesh kumar rakesh.apt...@gmail.comwrote: Dear Friend, i want to use total no of present or absent list using pivot table. Please find the attachment. -- Thanks £ Regards Rakesh Kumar +91-9650303464 -- Thanks £