Re: $$Excel-Macros$$ Format data from Tally 7.2

PFA.. ReGaRdS AiVrAn kUmAr On Tue, Mar 13, 2012 at 9:46 AM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi experts, I have a large data in Tally 7.2,when i try to I got data in a different format, please check the attached file Sheet 2 and make a solution. Thanks in advance Rajesh

Re: $$Excel-Macros$$ Help Needed

Hi All can any one help me pl..its very urgent,,, On Mon, Mar 12, 2012 at 12:52 PM, Patil MG mailpati...@gmail.com wrote: Dear Experts, I have to create 'N' number of empty files of word and note pad files, this word will long time to do can any one help to write a macro

Re: $$Excel-Macros$$ Logical Formula Problem

thanks Don On Mon, Mar 12, 2012 at 7:39 PM, dguillett1 dguille...@gmail.com wrote: See if this simpler approach is helpful Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* hilary lomotey resp...@gmail.com *Sent:* Monday, March 12, 2012 10:22 AM *To:*

Re: $$Excel-Macros$$ Format data from Tally 7.2

Hi Thanks for ur reply, but i need a format like which add in attached file. Regards Rajesh Kainikkara On 3/13/12, Aivi aivran...@gmail.com wrote: PFA.. ReGaRdS AiVrAn kUmAr On Tue, Mar 13, 2012 at 9:46 AM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi experts, I have a large data

$$Excel-Macros$$ Macro for format table

Hi experts Find the attached file,and help me to create a macro to format a table from the data given. My idea to solve this select column A:E, paste in G1 Select blank cells in column B ,here B2:B26 Deletethem Repeat the sale in next columns Regards Rajesh Kainikkara -- FORUM

Re: $$Excel-Macros$$ Macro for format table

Should do it Sub CopyColumnsToTableSAS() Dim i As Integer Dim fr As Long Dim lr As Long 'col A Cells(2, 1).Resize(Cells(2, 1).End(xlDown).Row).Copy Cells(2, g) 'other columns For i = 2 To 5 fr = Cells(2, i).End(xlDown).Row lr = Cells(Rows.Count, i).End(xlUp).Row Cells(fr, i).Resize(lr).Copy

Re: $$Excel-Macros$$ Format data from Tally 7.2

I thought I already responded to this. Sub CopyColumnsToTableSAS() Dim i As Integer Dim fr As Long Dim lr As Long 'col A Cells(2, 1).Resize(Cells(2, 1).End(xlDown).Row).Copy Cells(2, g) 'other columns For i = 2 To 5 fr = Cells(2, i).End(xlDown).Row lr = Cells(Rows.Count, i).End(xlUp).Row

$$Excel-Macros$$ Saving Excel Macro file to Xls format

How can I save excel macro file (.XLSM) file to XLS format? and macro still working in that file? Thanks and Regards, Avinash Daga -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help,

Re: $$Excel-Macros$$ Help Needed

Hi, Please find the attached text file. Copy and paste in that excel file and run. Regards Kumar On Tue, Mar 13, 2012 at 2:08 PM, Patil MG mailpati...@gmail.com wrote: Hi All can any one help me pl..its very urgent,,, On Mon, Mar 12, 2012 at 12:52 PM, Patil MG

Re: $$Excel-Macros$$ Help Needed

Hi, check this out Sub CreateWordDocs() ' add a reference to the Word-library ' this is for creating number word Documents and renaming them with file names mentioned in 'C' column ' this code doesn't write any content, it just creates word documents and saves them Dim newapp As

Re: $$Excel-Macros$$ Saving Excel Macro file to Xls format

Just save it as .xls and hope that your macros are BACKWARD compatible. Some are NOT. Test! Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Avinash Daga Sent: Tuesday, March 13, 2012 10:55 AM To: excel-macros@googlegroups.com Subject:

Re: $$Excel-Macros$$ Turn Tab Order on/off

Hi Asa At the moment the H1 setting makes no difference. The sheet works like normal with the setting at activate or deactivate, and not in tab order. Thanks Charlie On Sun, Mar 4, 2012 at 10:09 PM, Asa Rossoff a...@lovetour.info wrote: Hi Charlie, The button is actually just a cell

$$Excel-Macros$$ Divide Results from 2 Pivot Tables

I'm trying to divide a value in one Pivot Table by a value in a second Table. Please see the screen shot and the following explanation in the attached Word document. Any ideas? I'm thinking that I may be missing a very obvious alternate to solving this problem: The YTD Booking Rate isn’t the

RE: $$Excel-Macros$$ Goal Seek option from Tools menu....(little urgent)

U r Welcome! Regards, Muneer, CC.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ferry H Sitohang Sent: Tuesday, March 13, 2012 3:27 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Goal Seek

$$Excel-Macros$$ Email Sheet with message

i'm using the following code to send email how do i add something to the body? does anyone know if its possible to add a message to the email? ThisWorkbook.Sheets(1).Copy With ActiveWorkbook .SendMail Recipients:=emailaddr...@df.com, _ Subject:=Try Me)