Dear Group, Thanks for the response. But there is no total at the end for the schemes. Moreover for each dealer there will be hundreds of schemes so please let me know the steps followed to prepare the report.
Thanks & Regards... CA Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants 3010 Ram Kumar Arcade, Chatribari Road, A T Road, Guwahati-781001 0361-2603895,9435019908 save earth From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] Sent: 14 January 2012 05:12 To: Digest Recipients Subject: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 10 Messages in 7 Topics Today's Topic Summary Group: <http://groups.google.com/group/excel-macros/topics> http://groups.google.com/group/excel-macros/topics § Delete text only [1 Update] § Plz do the needful [2 Updates] § Retaining headers and footers when creating a new worksheet [1 Update] § HELP - Can´t sum the same columns of a comparative column [2 Updates] § Form to datasheet [1 Update] § access query [2 Updates] § SLA and Daily Productivity Tracking sheet for BPO [1 Update] <http://groups.google.com/group/excel-macros/t/76f02d58d44c14de> Delete text only Lokesh Loki <lokeshsmg2...@gmail.com> Jan 14 03:56AM +0530 Hi All, Thanks to all of you experts, Keep rocking !!!!!. Regards Lokesh.M <http://groups.google.com/group/excel-macros/t/95be59637383fc16> Plz do the needful Aamir Shahzad <aamirshahza...@gmail.com> Jan 13 10:16PM +0500 Dear Maries/Anjul Porwal, Why tou use "13" in your formula. can you brief? Regards, Aamir Shahzad -- Regards, Aamir Shahzad xlstime <xlst...@gmail.com> Jan 13 11:12PM +0530 Dear Aamir, very simple 13 mean 1 pm and 14 mean 2 pm but as per your example sheet you should need to replace 14 to 15.. because 15 mean 3 to 3 -- ......................... <http://groups.google.com/group/excel-macros/t/7f2d869ad150e89a> Retaining headers and footers when creating a new worksheet Steve Weaver <stevebwea...@comcast.net> Jan 13 12:28PM -0500 Greetings, Several months ago I received help from this group on a project to separate transactions from a single Excel worksheet into three different worksheets based on the rep number. Your assistance was and still is very much appreciated. I would like to improve on this process even more and need further help. The problem I have is that each month when I create a new worksheet I lose the headers and footers established for each rep report along with the report totals on the last page. Please refer to the attached file. Is there some way to retain the headers and footers, along with the total on the last page, when creating the individual rep worksheet? Is it possible to overwrite the existing rep worksheet, thereby retaining the headers and footers, rather than creating a new worksheet? Thank you very much for your help! Steve <http://groups.google.com/group/excel-macros/t/a1daa96e7363fb46> HELP - Can´t sum the same columns of a comparative column xlstime <xlst...@gmail.com> Jan 13 09:47PM +0530 Hi Friend, as per my observation, please find the attachment Team XLS -- ......................... "dguillett1" <dguille...@gmail.com> Jan 13 11:11AM -0600 I’m looking at your file and trying to determine what you want.??? Do you want to know the sum for 11 Jan of each year? What___ A better explanation and example showing comes from what cell or cells __________to where__________and why_________? Don Guillett SalesAid Software dguille...@gmail.com From: Jorge Marques Sent: Friday, January 13, 2012 9:07 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ HELP - Can´t sum the same columns of a comparative column Hi guys, i´m doing a excel file for comparatives of the year 2010, 2011, 2012, the problem is that i need to compare days, like if i choose to see day 10 January of 2012 with the 2011, i must compare the same number of cells with values, so it has to compare 11 january 2011 that has 7 numbered sums to sum, not counting weekdays, i tried to do a formula withs sums and counts but i´m not getting there, is there anyway with a macro or a formula? thank you very much -- 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 <http://groups.google.com/group/excel-macros/t/ed834dce89b8a4c2> Form to datasheet Marcio Bandeira <marciobandeir...@gmail.com> Jan 13 03:10PM -0200 Hi, thanks for any help. I have a form to input data in a worksheet. One of this data is a number, but when I put in the excel this data, the calculation doens´t work. The formula in the field is: Cells(Ultimalinha, 15).Value = BemImovel There is a value in the form (Bem Imovel), USD 5000 for example, but in the excel (datasheet) it´s only a data “5000” and I can´t SUM in a formula for example. Can someone try to give me a hint how I do this? TKs Atenciosamente, Marcio Bandeira de Azevedo <http://groups.google.com/group/excel-macros/t/283a35f6babb3ee3> access query xlstime <xlst...@gmail.com> Jan 13 10:00PM +0530 Dear Friend, Please find the attachment of test access database. Team XLS -- ......................... xlstime <xlst...@gmail.com> Jan 13 10:03PM +0530 sorry attachment missing.. -- ......................... <http://groups.google.com/group/excel-macros/t/3014ea83c4dddb56> SLA and Daily Productivity Tracking sheet for BPO xlstime <xlst...@gmail.com> Jan 13 10:02PM +0530 for which type process like inbound or outbound -- ......................... You received this message because you are subscribed to the Google Group excel-macros. You can <mailto:excel-macros@googlegroups.com> post via email. To unsubscribe from this group, <mailto:excel-macros+unsubscr...@googlegroups.com> send an empty message. For more options, <http://groups.google.com/group/excel-macros/topics> visit this group. -- 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.jpg>>
