Re: $$Excel-Macros$$ Formula required

Hi Priya, Please find attachment. Let me know if you need anything else. Thanks Regrds, Kaushik Savla -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

Re: $$Excel-Macros$$ vba to notepad

Dear krishna, It is possible to copy the contents of Excel to note pad.But, the only problem is the pasted content will not maintain the same format as in Excel. Regards, Vijaykumar On Mon, Oct 18, 2010 at 12:47 AM, Krishna krishnaja...@gmail.com wrote: How can we copy the contents from

Re: $$Excel-Macros$$ vba to notepad

Dear Vijaykumar, Do you mean, an is inserted for all the data? Can you please illustrate by an example? Thanks, Krishna On Oct 18, 2:04 am, P.VIJAYKUMAR vijay.4...@gmail.com wrote: Dear krishna, It is possible to copy the contents of Excel to note pad.But, the only problem is the pasted

Re: $$Excel-Macros$$ vba to notepad

you can save your workbook (containing ONE worksheet) as XX.TEXT or as XX.CSV please note the notepad (a TEXT editor) is not contains multi cells like excel worksheet On Mon, Oct 18, 2010 at 2:07 PM, Krishna krishnaja...@gmail.com wrote: Dear Vijaykumar, Do you mean, an is

Re: $$Excel-Macros$$ Formula required

Dear All, Thanks for your prompt reply, as i mentioned in my query what is that i am looking for is a formula but not Pivot table which i now very well this can be acheived. If you guys look at the data it has something like pulling the data with respect to a value from left and right. thats the

Re: $$Excel-Macros$$ Stander O/s Format

I could not identify whether it is a solution or your query.If this is solution pls ignore my mail, otherwise you may please explain the objective and problem. Thanks Regards, C.G.Kumar On Sat, Oct 9, 2010 at 2:20 PM, SUMIT VYAS svyas0...@gmail.com wrote: Thanks For all member of

Re: $$Excel-Macros$$ Time in Decimal format

Excellent explanation. and to me too, 3:48 is NOT equivalent to 3.48 hours. Well Done Paul On Fri, Oct 15, 2010 at 5:42 PM, Paul Schreiner schreiner_p...@att.netwrote: just so you know: 3 hours 48 minutes is NOT 3.48 hours. it's 3.8 hours... If you're wanting the hours/minutes

Re: $$Excel-Macros$$ Formula required

Hi Priya, Please find attachement with solution. Thanks, Noorain Ansari On Mon, Oct 18, 2010 at 1:38 AM, Priya Jose questpr...@gmail.com wrote: Dear All, Thanks for your prompt reply, as i mentioned in my query what is that i am looking for is a formula but not Pivot table which i now

$$Excel-Macros$$ Excluding holidays from a UDF

Hi, I have the following code that calculates the number of days (excluding Sundays) between two dates, and ideally I'd like to add another parameter to my function to allow me to exclude non-working days (in a similar way to the in-built NETWORKDAYS function - -

$$Excel-Macros$$ help required

Dear Experts, need one urgent help from you guys i have attached one file having 2 sheets named system data Raw CDR i need a formula for getting name in sheet Raw CDR for exam sheet system data having no 93 Afghanistan Other and Raw Cdr having No 93854512115 for getting destination name

Re: $$Excel-Macros$$ Macro to copy down/right and back up one line

Can anyone help with this? Not sure how well this copied but I have gl accts on the left with the months across the top. I need to copy only the acct data over to another tab and occasionally new accounts will be inserted so I don't want to lock in the range. I would like to go to Dec Actual

Re: $$Excel-Macros$$ help required

Dear Girish, Sorry I didn't understand what you are looking for, Please give an Example, what you want exactly? May be i have some communication problem to understand your query. Thanks, Excelkid On Mon, Oct 18, 2010 at 7:52 PM, girish kumar girishkumar832...@gmail.comwrote: Dear Experts,

$$Excel-Macros$$ Excel Macro to Copy data from Excel File and Update in a Webpage

Hi Excel Gurus, Is it possible to create a Excel macro using which, it has take data’s from a excel file and it need to update in a specified web page. I have given the example below In Excel file Sl.No NameEmp.No. Enterprise id Supervisor Name Supervisor Email id 1 Selva

$$Excel-Macros$$ Excel Macro to Copy data from Excel file and update in a Webpage

Hi Excel Gurus, Is it possible to create a Excel macro using which, it has take data's from a excel file and it need to update in a specified web page. I have given the example below In Excel file Sl.No Name Emp.No. Enterprise id Supervisor Name Supervisor Email id 1 Selva

Re: $$Excel-Macros$$ vba to notepad

Dear Krishna, I mean we can copy the range of cells A1:B5 from excel to note pad. But , it is very difficult to copy the whole workbook to notepad. Regards, Vijaykumar On Mon, Oct 18, 2010 at 12:47 AM, Krishna krishnaja...@gmail.com wrote: How can we copy the contents from excel to notepad.

Re: $$Excel-Macros$$ help required

Hi Krishna, see file attached, in that second sheet u see in b column i used Left function and in c column Vlookup left function i used =left(A2.13) and vlookup answer is #N/A Because In System Data sheet Left function answer is not there if i decrease the no's in left function i ll get the