Re: $$Excel-Macros$$ Need help in converting table format data to pivot format in excel

hi Sudhir, pls find code below- Sub test() Sheets("Output").UsedRange.Clear Dim i As Long Dim j As Long Dim k As Long Dim s As Long k = 2 Sheets("Input").Select For i = 2 To Range("a4").Row For j = Range("e5").Column To Range("g5").Column For s = Range("i5").Column To Range("k5").Col

Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook

You will not find customised code as per your requirement anywhere. You have to make changes on your own. The above link will tell you how to zip one file and then combine it with mail macro to send that file Regards Ashsh On Thu, Feb 6, 2014 at 5:39 PM, Atul Kesaria wrote: > Hi Ashish, > > W

Re: $$Excel-Macros$$ Export table data from outlook body to excel files

To move outlook mails http://msdn.microsoft.com/en-us/library/office/aa220127(v=office.11).aspx On Fri, Feb 7, 2014 at 1:44 AM, Ankit Mehra wrote: > Hi Ashish, > > Thank you for your response. I have been able to write a macro which will > copy table information from outlook mail body and past

Re: $$Excel-Macros$$ How do you find distance with Google Maps to a general locatioin in Excel 2013?

hi You can do it by automating the below http://msdn.microsoft.com/en-us/library/ff701717.aspx or https://developers.google.com/maps/documentation/distancematrix/ but you need to purchase API key Regards, Ashish On Fri, Feb 7, 2014 at 12:41 AM, wrote: > Hello, > > What I'm trying to do is

$$Excel-Macros$$ Facing Challenges To Automate A Reconciliation Sheet

Hi Team, I'm facing challenges to automate attached worksheet. I've to match total of debit and credit amount to reconcile the data, match could be possible in single and multiple transaction entries. Please provide your valuable inputs after you go through to the data sheet. -- Regards, Deepa

Re: $$Excel-Macros$$ Export table data from outlook body to excel files

Hi Ashish, Thank you for your response. I have been able to write a macro which will copy table information from outlook mail body and paste the same in the excel file. However, i am curious to know if the mails that have been worked upon by the macro could be moved to any other sub-folder so tha

$$Excel-Macros$$ How do you find distance with Google Maps to a general locatioin in Excel 2013?

Hello, What I’m trying to do is have the final cell (Distance in the above excel) the distance of a general location (i.e. Golf Course) from the distance of a set address (XYZ Street). Is this possible? I'm running Office 2013. Thank you. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

Re: $$Excel-Macros$$ Export table data from outlook body to excel files

Hi Ankit Save the outlook mail as word document and then open the document and copy content and paste it in excel You need to automate above steps Sent on my BlackBerry(R) from Vodafone -Original Message- From: Ankit Mehra Sender: excel-macros@googlegroups.com Date: Thu, 6 Feb 2014 16

Re: $$Excel-Macros$$ Need help in converting table format data to pivot format in excel

can u please resent me complete code. On 6 February 2014 12:55, ashish koul wrote: > you need to add if condition here > > if Cells(i, s).value <> 0 then > Sheets("Output").Range("g" & k) = Cells(i, s).text > end if > > > > > On Mon, Feb 3, 2014 at 6:28 PM, Umesh Kumar wrote: > >> Hi Ashish, >

Re: $$Excel-Macros$$ Excel Formula - Huge Formula - Help to simplfy

Hi Brett, Instead of studying formula, it will be easy to create alternate formula if you could provide calculation steps. Regards, Swapnil. On Fri, Jan 31, 2014 at 10:41 PM, Brett Manning wrote: > > > On Friday, January 17, 2014 6:11:10 AM UTC, Rajan_Verma wrote: > >> i didnt review the formu

Re: $$Excel-Macros$$ Re: Excel Password Breaker Code...

Hi Excel Password Unlocker Software easily recover Excel file password and unlock Excel spreadsheet within just few mouse clicks. This software is good performer program for cracking Excel sheet password and unlocking Microsoft Excel workbook after then fastly

Re: $$Excel-Macros$$ Macro for Sending Multiple file to Multiple recepeint using Outlook

Hi Ashish, What I am looking at zipping respective PDF file as a seperate zip file and not all pdf files in one zip. Sorry but i could not see that in that link. Regards Atul On Thu, Feb 6, 2014 at 12:56 PM, ashish koul wrote: > check this > http://www.rondebruin.nl/win/s7/win001.htm > http:/

$$Excel-Macros$$ Export table data from outlook body to excel files

Dear Experts, I have a query related to email that i receive in my outlook. The below mentioned table is part of the body of the email. I am looking for the following solution: 1. Copy the table contents from the body of the outlook email and paste the same in an excel file. 2. There are 4 existi

$$Excel-Macros$$ Extract a non accrued interest rate from principal, total interest and number of payment periods.

Hi guys, I have been busting my head for this problem but to no avail, please help me out here. Basically we are inquiring for loan offers from lenders and I have the following proposal: we take 1.7 million euro as loan, payable in 60 months (5 years), and we pay a total of 413.000 EUR as a t