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 Kainikkara -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *Thanks Regards * *Aivran kumar *E-mail:- aivran...@gmail.com http://facebook.aivik1 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com book1222.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
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 where in which i can create empty word files or note pad files by running the macro, my files will be listed in excel file (please refer the attached Excel sheets -- Thank You Patil MG -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thank You Patil MG 9663374848 Life is Very Beautiful!!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸•´ Smiling! `•.¸.•´. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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:* excel-macros EXCEL-MACROS@googlegroups.com *Subject:* $$Excel-Macros$$ Logical Formula Problem Hi Experts i am trying to use the logical formula ie or operator to have an outcome such that if the figure in say cell A is greater than that of cell B, i want it to read is higher than, if false then lesser than, this would be achieved by selecting the year from the drop down, i have done all than but its not working, pls see the attached sheet and assist. Specifically, in 2009 Operating margin was lower than in 2008, but am not getting the desired outcome. thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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 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 Kainikkara -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *Thanks Regards * *Aivran kumar *E-mail:- aivran...@gmail.com http://facebook.aivik1 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com TallY(2).xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$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 RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com TallY Data.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
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 Cells(2, i + 6) Next i End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Rajesh K R Sent: Tuesday, March 13, 2012 8:50 AM To: excel-macros Subject: $$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 Delete them Repeat the sale in next columns Regards Rajesh Kainikkara -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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 Cells(fr, i).Resize(lr).Copy Cells(2, i + 6) Next i End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Rajesh K R Sent: Monday, March 12, 2012 11:16 PM To: excel-macros Subject: $$Excel-Macros$$ Format data from Tally 7.2 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 Kainikkara -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$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, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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 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 where in which i can create empty word files or note pad files by running the macro, my files will be listed in excel file (please refer the attached Excel sheets -- Thank You Patil MG -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thank You Patil MG 9663374848 Life is Very Beautiful!!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸•´ Smiling! `•.¸.•´. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com 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 Word.Application Dim newDoc As Word.Document Dim xsht As Worksheet Dim filename As Range Dim xcell As Range Dim LastCell As Range Dim i As Integer Set xsht = ActiveWorkbook.Sheets(Sheet1) Set LastCell = xsht.Range(C65000).End(xlUp) If Not LastCell.Row 1 Then Exit Sub 'condition to check whether filename is entered or not Set filename = xsht.Range(C2:C LastCell.Row) Set newapp = CreateObject(word.application) newapp.Visible = True For Each xcell In filename Set newDoc = newapp.Documents.Add With newDoc .SaveAs (D:\New Folder\ xcell.Value .doc) 'instead of D;\New Folder, you can give your own path .Close End With Set newDoc = Nothing Next xcell newapp.Quit Set newDoc = Nothing Set newapp = Nothing End Sub -- Sub CreateNotePads() 'this with create notepads without writing any content in them Dim fs As Object Dim a As Object Dim xsht As Worksheet Dim filename As Range Dim xcell As Range Dim LastCell As Range Dim i As Integer Set xsht = Sheets(Sheet1) Set LastCell =
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 Word.Application Dim newDoc As Word.Document Dim xsht As Worksheet Dim filename As Range Dim xcell As Range Dim LastCell As Range Dim i As Integer Set xsht = ActiveWorkbook.Sheets(Sheet1) Set LastCell = xsht.Range(C65000).End(xlUp) If Not LastCell.Row 1 Then Exit Sub 'condition to check whether filename is entered or not Set filename = xsht.Range(C2:C LastCell.Row) Set newapp = CreateObject(word.application) newapp.Visible = True For Each xcell In filename Set newDoc = newapp.Documents.Add With newDoc .SaveAs (D:\New Folder\ xcell.Value .doc) 'instead of D;\New Folder, you can give your own path .Close End With Set newDoc = Nothing Next xcell newapp.Quit Set newDoc = Nothing Set newapp = Nothing End Sub -- Sub CreateNotePads() 'this with create notepads without writing any content in them Dim fs As Object Dim a As Object Dim xsht As Worksheet Dim filename As Range Dim xcell As Range Dim LastCell As Range Dim i As Integer Set xsht = Sheets(Sheet1) Set LastCell = xsht.Range(C65000).End(xlUp) If Not LastCell.Row 1 Then Exit Sub 'condition to check whether filename is entered or not Set filename = xsht.Range(C2:C LastCell.Row) Set fs = CreateObject(scripting.filesystemobject) For Each xcell In filename Set a = fs.createtextfile(D:\New Folder\ xcell.Value .txt, True) 'give your own path Set a = Nothing Next xcell End Sub 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 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 where in which i can create empty word files or note pad files by running the macro, my files will be listed in excel file (please refer the attached Excel sheets -- Thank You Patil MG -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thank You Patil MG 9663374848 Life is Very Beautiful!!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸•´ Smiling! `•.¸.•´. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post
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: $$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, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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 that is colored. It has Data Validation enabled for that cell that restricts values to Activate and Deactivate. ** ** The tab order macro seems to be pretty straightforward and I would expect it to work with Excel 2000, but I am not an expert at what is and is not supported. ** ** The macro moves the selection to the next data entry cell only when a cell is edited. *Not* particularly when tab is pressed. ** ** Can you confirm that when cell H1 says Activate and you edit one of the cells listed at the end of this sentence and hit either tab or enter to leave the cell that the selection does not go to the next cell in this list: h8, h9, h10, h11, h13, l11, l12, h17, k17, h18, k18, k21, k22, n26, n27, n31, k37, e82, f82, h82, j82, e83, f83, h83, j83, e84, f84, h84, j84, e85, f85, h85, j85, e86, f86, h86, j86, e87, f87, h87, j87, e88, f88, h88, j88, e89, f89, h89, j89? ** ** Asa ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Cab Boose *Sent:* Saturday, March 03, 2012 10:07 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Turn Tab Order on/off ** ** HI In attached workbook Ashish has produced a great macro but he is not use to XL2000, only later ones. There is a button at top of worksheet to turn on/off the macro that sets the tab order. Not working currently, is there an adjustment to make for XL2000 ? Once going, please check when in tab order mode that if a entry is incorrect and user hits delete for that cell that it does not delete info in all tabbed cells. Your assistance appreciated. Charlie -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$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 solution since the Pivot Tables change and while the names match up row for row in this example, If Sue doesn’t book any jobs, her name isn’t in the PT on the right and the YTD Booking Rate table to the right is incorrect. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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 option from Tools menu(little urgent) Thanks Muneer..this is good for me From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 12 March, 2012 05:53 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Goal Seek option from Tools menu(little urgent) Dear Muneer, See attached pdf, hope it will help to you On Mon, Mar 12, 2012 at 1:42 PM, Mohammed Muneer mmun...@ccc.com.qa wrote: Dear Group, I want to select multiple cell values(a1 b1) to change the target cell C1. Can I do it like this? Plz suggest? If any formula or code, anyway that can do well plz send. Regards, Muneer, CC... -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari http://noorainansari.com/ http://excelmacroworld.blogspot.com/ http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com image001.gif
$$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) .Close SaveChanges:=False End With *End Sub* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com