Re: $$Excel-Macros$$ Project Work
Hi Sathish, Please share if any project related to excel without complex macros. I m very much comfortable with the excel. Would be thankful to you if you do so.. -- Thanks & Regards, Sanjay Soni 930366 On Sat, Oct 29, 2011 at 1:19 AM, satish wrote: > Dear All, > > I am free lance data analyst, I have set of excel templates to > calculate the Savings and Overcharges. I would like to auto-maize the > whole process using VBA and Macro. I would like to know the > professional who can create the package ( Excel along with VBA and > Macro. Please leave your contact details along with > Name > Address > Contact number > Email Id etc. > > I will send you the full description of the project work along with > Tender list. Please quote your fee & duration to create the project > work and send back to me before Tender deadline. Since I am > freelancer, I cant afford to pay you high salary, comparably with > software companies. > > You can send you contact details in below email id. > > skanda...@hotmail.com > > Kind Regards > > SATISH KUMAR. > > -- > FORUM RULES (925+ 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 > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ HaPpY BirthdaY - Sir Paul Schreiner
Dear Paul Sir, Wish You Many Many Happy Returns of the Day !! Enjoy the day..! Sanjay From: OpenExcel.com <26may.1...@gmail.com> To: excel-macros@googlegroups.com Sent: Monday, 27 June 2011 8:30 AM Subject: $$Excel-Macros$$ HaPpY BirthdaY - Sir Paul Schreiner Wish you many many Happy Returns of the Day :) Enjoy :) HappY BirthdaY :) Best Regards Ashish Jain eXceLiTems-- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Best Regards, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - May'11
Dear Ashish G, Congratulations on a great success. It is really appreciable for winning consecutive 6 times as "MOST HELPFUL MEMBER". Sanjay From: Ayush Jain To: excel-macros Sent: Thursday, 2 June 2011 10:29 PM Subject: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - May'11 Hello Everyone, Ashish Koul has been selected as 'Most Helpful Member' for the month of May'11 He has posted 67 posts in May 2011 and helped many people through his expertise. He has been consistent contributor to this excel forum and achieved this recognition from last six months consecutively.This is really awesome. ASHISH, Many Many thanks for the valuable support to group. We are proud to have you in this forum. I have published the same on discussexcel.com homepage. Regards Ayush Jain Group Manager -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Best Regards, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Our NEW Microsoft MVP - Dilip Kumar Pandey
Hi, Dilip Congratulations for the great success.. Sanjay On Mon, Jan 3, 2011 at 3:31 PM, Ayush wrote: Dear Group, > >I am very very very very happy to share a good news with you. One of our >dearest >group member "Dilip Kumar Pandey" is awarded Microsoft MVP award on 1st >January >for his exceptional Excel skills and voluntary contribution. >He is well deserving for the award and I am very happy about his recognition. > >Dear Dilip, Many Many congratulations, Keep it up. >I am very proud of you to be part of this group. I wish your long association >with this group. > >Best Regards, >Ayush Jain >Microsoft MVP-2010 >-- >-- > >Some important links for excel users: >1. Follow us on TWITTER for tips tricks and links : >http://twitter.com/exceldailytip >2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >3. Excel tutorials at http://www.excel-macros.blogspot.com >4. Learn VBA Macros at http://www.quickvba.blogspot.com >5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >To post to this group, send email to excel-macros@googlegroups.com > ><><><><><><><><><><><><><><><><><><><><><><> >Like our page on facebook , Just follow below link >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts Best Regards, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
$$Excel-Macros$$ Macro :- Selecting a variable range in a excel sheet
Dear All, Please help me to provide a macro code for selecting a variable range. Suppose for example the data enter from (A1:B10) but if the more data is entered into a cell by changing a range to (A1:B20) or (A1:B18). Thanks in advance Please provide solicit inputs if you can Sanjay +91930366 Best Regards, -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: $$ Excel-Macros $$ Consolidation of different sheet by macro
Dear Shreedar, Actually Problem is that to consolidate two or more sheet it doesn't work. Can u send me a macro recorded file for consolidating more than two sheets. Best Regards, Sanjay --- On Fri, 3/7/09, Shreedar Pandurangaiah wrote: From: Shreedar Pandurangaiah Subject: $$Excel-Macros$$ Re: $$ Excel-Macros $$ Consolidation of different sheet by macro To: excel-macros@googlegroups.com Date: Friday, 3 July, 2009, 6:06 AM Hi Sanjay, If you are using Excel 2003 then keeping your cursor in the data and then clicking Ctrl+A would choose the whole range of the data where your cursor is placed...Try doing this while recording the macro, It will work. Thanks, Shreedar On Thu, Jul 2, 2009 at 12:27 PM, SANJAY SONI wrote: Dear All, Please help me to solve my problem. As I want to have the macro for making the consolidation of different sheets through a recorded macro with the variable ranges in sheets. Best Regards, Sanjay Love Cricket? Check out live scores, photos, video highlights and more. Click here Looking for local information? Find it on Yahoo! Local http://in.local.yahoo.com/ --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help on copying formula.....
Dear Dave, Thanx its working nicely. Best Regards, Sanjay --- On Thu, 2/7/09, Dave Bonallack wrote: From: Dave Bonallack Subject: $$Excel-Macros$$ Re: Help on copying formula. To: "excel-macros@googlegroups.com" Date: Thursday, 2 July, 2009, 5:13 PM #yiv891761651 .hmmessage P { margin:0px;padding:0px;} #yiv891761651 { font-size:10pt;font-family:Verdana;} Hi all, There is another way to do this using the INDIRECT function. Have a look at the attached sheet. Select B2, then copy across. Column A will appear in Row 1 You may have to change the formula slightly to suit your data. Regards - Dave. Date: Thu, 2 Jul 2009 12:24:24 +0530 From: sanjaysoni2...@yahoo.co.in Subject: $$Excel-Macros$$ Re: Help on copying formula. To: ca.ashut...@gmail.com CC: excel-macros@googlegroups.com Dear Ashutosh, I understood you problem it can be solved by making the coloum fixed by dollar sign and then copy that formula. For eg :- "=A1" fix the coloum by "=$A1". Best Regards, Sanjay --- On Thu, 2/7/09, Dave Bonallack wrote: From: Dave Bonallack Subject: $$Excel-Macros$$ Re: Help on copying formula. To: "excel-macros@googlegroups.com" Date: Thursday, 2 July, 2009, 12:13 PM #yiv891761651 .ExternalClass #EC_yiv711815090 .EC_hmmessage P {padding:0px;} #yiv891761651 .ExternalClass #EC_yiv711815090 {font-size:10pt;font-family:Verdana;} Hi Ashutosh, Absolute refrencing won't help you here. If you have control of the spread-sheet, and you can easily re-structure it, change the vertical list to a horizontal one. If you can't do that, select the refrence list, then copy. find an unused pert of the sheet. Click in a cell, then rightclick, Paste Special. in the Paste Special dialog box, tick the transpose option (near the bottom). you can use the new list as a reference for the copy-across you want to do. Hope this helps.. Regards - Dave. Date: Thu, 2 Jul 2009 09:46:31 +0530 Subject: $$Excel-Macros$$ Help on copying formula. From: ca.ashut...@gmail.com To: excel-macros@googlegroups.com Hi All, Genrally in spreadheet, if you copy a formule in other rows, formula is changed according to row number. e.g. we have a cell with formula ""=A1" and now we copy this formula across columns to the right. Naturally, this results in the Formula reference changing to =B1, =C1, =D1 etc. However, this is not the result I want. I want that if I copy this formula across columns to the right, it should show as =A2, =A3, =A4 and so on.Can anyone help in this. Many Thanks, Ashutosh Yahoo! recommends that you upgrade to the new and safer Internet Explorer 8 Let us help with car news, reviews and more Looking for a new car this winter? Yahoo! recommends that you upgrade to the new and safer Internet Explorer 8. http://downloads.yahoo.com/in/internetexplorer/ --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Help on copying formula.....
Dear Ashutosh, I understood you problem it can be solved by making the coloum fixed by dollar sign and then copy that formula. For eg :- "=A1" fix the coloum by "=$A1". Best Regards, Sanjay --- On Thu, 2/7/09, Dave Bonallack wrote: From: Dave Bonallack Subject: $$Excel-Macros$$ Re: Help on copying formula. To: "excel-macros@googlegroups.com" Date: Thursday, 2 July, 2009, 12:13 PM #yiv711815090 .hmmessage P { margin:0px;padding:0px;} #yiv711815090 { font-size:10pt;font-family:Verdana;} Hi Ashutosh, Absolute refrencing won't help you here. If you have control of the spread-sheet, and you can easily re-structure it, change the vertical list to a horizontal one. If you can't do that, select the refrence list, then copy. find an unused pert of the sheet. Click in a cell, then rightclick, Paste Special. in the Paste Special dialog box, tick the transpose option (near the bottom). you can use the new list as a reference for the copy-across you want to do. Hope this helps. Regards - Dave. Date: Thu, 2 Jul 2009 09:46:31 +0530 Subject: $$Excel-Macros$$ Help on copying formula. From: ca.ashut...@gmail.com To: excel-macros@googlegroups.com Hi All, Genrally in spreadheet, if you copy a formule in other rows, formula is changed according to row number. e.g. we have a cell with formula ""=A1" and now we copy this formula across columns to the right. Naturally, this results in the Formula reference changing to =B1, =C1, =D1 etc. However, this is not the result I want. I want that if I copy this formula across columns to the right, it should show as =A2, =A3, =A4 and so on.Can anyone help in this. Many Thanks, Ashutosh See the Web's breaking stories, chosen by people like you. Check out Yahoo! Buzz. http://in.buzz.yahoo.com/ --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ $$ Excel-Macros $$ Consolidation of different sheet by macro
Dear All, Please help me to solve my problem. As I want to have the macro for making the consolidation of different sheets through a recorded macro with the variable ranges in sheets. Best Regards, Sanjay Love Cricket? Check out live scores, photos, video highlights and more. Click here http://cricket.yahoo.com --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---