$$Excel-Macros$$ posibly a sumif or such problem
i have column E with downwards multiple entrys of wich some is repetetive in other words e13 a e14 b e15 a e16 c e17 a e18 b e19 a e20 c e21 a e22 b and in g i have amounts thats corresponding/refering to E for example g13 100 g14 101 g15 204 g16 20 g17 50 g18 10 g19 100 g20 101 g21 30 g22 47 i need in column L to only show L13 a L14 b L15 c and in column M i will need the sum of all the a's in M13 and sum of b's in M14 and sum of c's in M15 for example M13 484 M14 158 M15 121 there will be on different sheets different amounts of rows so it could be on one sheet 23 unique items in column E and on another sheet 100 unique items thank you!!! can send sample of the workbook -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/excel-macros/2cf092f0-a355-402a-95bf-48f3c8a6ec2co%40googlegroups.com.
$$Excel-Macros$$ screenshot window and send via whatsapp to contact
Good day i would like to see if possible to have a code that i can automate via macro to take a screenshot of the current window(page) [ctrl+alt+screenshot] and send this via whatsapp for windows to a specific contact... greetings Phillip Swanepoel email: pswanie 0825360597 -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ select one of 6 cells down
good day.. i have a column where they need to select just one cell at a time. if for example E9 has a x then this but if user select E11 this and then E9 must be deselected automatically... and perhaps any way to 'clean up' or make use of this easier for the end user? pswa nie gm ail -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. salad label.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ sumif kinda formula needed
Hi This posting relate to a earlier one regarding birthdays on a excel sheet. in column b i got the /mm/dd column c i got the person name and last name column d i got the age of the person in h10 i need every one that has birthday today with theiry respective age next to the name. since there might be more than one or even sometimes more than 2/3 a normal if then would not work... in h11 i need every on that has birthday tomorow again with their respective age next to. in h12 i need a list of every one that has birthday this month. this can be with out the age. then i got the userform with the labels and will pull d1 , d2 , d3 to the labels... Thank you guys Phillip Swanepoel pswa...@gmail.com (JanPhi) 0825360597 0287134213 34° 4'58.48S, 21°14'51.33E This email has been forwarded using a mobile phone with a internet/wap application. Go to www.operamini.com for more info -- -- 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 7000 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 birthdays-Andy_01.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Birthdays list formula or macro
Hi all Attached is a sample work book. In column b down i got birthdays. next to that the persons name. B2 will be either =today() or =now() (or something else that will trigger the days date... how can i display in a column who has a birthday today or tomorrow? Phillip Swanepoel pswa...@gmail.com (JanPhi) 0825360597 0287134213 34° 4'58.48S, 21°14'51.33E This email has been forwarded using a mobile phone with a internet/wap application. Go to www.operamini.com for more info -- -- 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 7000 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 birthdays.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Display birthday person name on userform
Hi. i got a userform with 3 labels. and sheet5 column a down names. b down the birthdays of each person. label1 i need everyone that has birthday today. lable2 i need every one with birthday tomorow and finaly label3 i need all the names of people with birthday day after tomorow... thanx! PHILLIP -- -- 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 7000 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
Re: $$Excel-Macros$$ BeforeSave - Enabling Macros
that is the way to go but better yet use the very hidden comand. other wise the user can still go and unhide the sheets with macro unabled On 2/4/10, Paul Schreiner schreiner_p...@att.net wrote: The problem is this: Evil hackers have managed to write Malicious code and place it in Excel files. So, Microsoft has made it possible for you to DECIDE if you want macros to run. Primarily, the only time this really helps is if you don't EXPECT the file to contain macros, yet it does, so you can choose not to enable them. In order for this to work, Microsoft CANNOT enable an Excel file to bypass this feature. Otherwise, why do it? What I've done is this: Hide all sheets (and password protect them as well as the VBA code) Show only a single sheet that instructs the user to close and re-open it with macros enabled. Then, in a Workbook_Open event, hide the cover sheet and unhide the rest. That way, if the user opens it with macros enabled, all is well. If he does not, he gets a minor slap... Best I've been able to come up with... Paul From: PWS p...@twelve.me.uk To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com Sent: Thu, February 4, 2010 11:14:04 AM Subject: $$Excel-Macros$$ BeforeSave - Enabling Macros Interesting situtaion which I sure others have come across before. I cannot think of a solution, I wonder if anyone else has or can? I have the requirement to not allow a workbook to be saved if a user has not entered information into a specified cell. I thought that is easy I will write a procedure which, using the BeforeSave event checks that the criteria (the cell has the required information) has been fulfilled and if not will cancel the save event. I wrote a nice warning box advising the user that the workbook could not be saved without the criteria being fulfilled and thought that was that. The first user who tried this opened the workbook, did not enable macros, and was therefore able to save the workbook without the required information because the Before Save event did not fire because macro had been disabled. I suppose I am asking is there any way to not open a work unless macro are enabled? PWS -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 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 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW !! We reach over 6,700 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 -- Phillip Swanepoel pswa...@gmail.com (JanPhi) 0825360597 0287134213 34° 4'58.48S, 21°14'51.33E This email has been forwarded using a mobile phone with a internet/wap application. Go to www.operamini.com for more info -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com HELP US GROW
$$Excel-Macros$$ Re: $$ TIP $$ Backing up Excel Files
This is excel-lent!!! Thanx On 9/17/09, Harmeet Singh harmeet.hew...@gmail.com wrote: *I agree with you Andy...* Thanks Regards, Harmeet Singh Sent via BlackBerry Wireless On Thu, Sep 17, 2009 at 6:51 PM, Aindril De aind...@gmail.com wrote: Hats Off Ayush... Excellent Tip... Regards, Andy On Thu, Sep 17, 2009 at 7:31 PM, Ayush Jain jain_ayus...@yahoo.comwrote: ** Do you have important Excel files that would create nothing short of chaos and disaster for you if you were to lose those files? Now I'm sure that you regularly make copies of these files just in case - but wouldn't it be nice if Excel could help us out a bit on this score? Yeah - I thought so too so I did some research… I found in the options of Excel's Save As window a little backup for our very important files. To take a look you'll need to go to the *Save As *window, *Tools* menu, *General Options* choice. [image: Click Here For More Mails - gurlzgroup -]http://www.gurlzgroup.blogspot.com/ At the top of the Save Options window that opens you should see a checkbox for something labeled as *Always create backup*. [image: Click Here For More Mails - gurlzgroup -]http://www.gurlzgroup.blogspot.com/ Should you choose to* check this option *and *click OK *what will happen is obvious. Every time you save, after the initial Save As, Excel will create a backup file too - automatically. Yes - it's that easy to get Excel to lend a helping hand. Now - I did do some experimenting with this and found that the backup always seemed to be one version of the file behind. In other words - the latest changes were saved in the actual file and the backup file was saved without the newest changes. This could be useful in the Oh man, I really messed up this file arena. Also, to actually see the backup when trying to open it you'll need to change the type of file you're looking for in the Open window. You could try All Files or you could scroll way to the bottom of the list where you'll find Backup Files listed. Either way - the backup is not listed among your usual files. It's called Backup of x. Just one more strategy to employ in the never-ending battle against lost data. __,_._,___ -- Love Cricket? Check out live scores, photos, video highlights and more. Click here http://in.rd.yahoo.com/tagline_cricket_2/*http://cricket.yahoo.com -- Phillip Swanepoel pswa...@gmail.com (JanPhi) 0825360597 0287134213 This email has been forwarded using a mobile phone with a internet/wap application. Go to www.operamini.com for more info --~--~-~--~~~---~--~~ -- 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 6,500 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: UserForm
what kinda ten Q's u need? where does the names and tel numbers come from? you want to fill it in r must it come from the sheet? Do you want to view the sheet? print the sheet? etc please reply with more spesific specs. would be nice if you can attach a sample or pix of what you vision This email has been forwarded using a mobile phone with a internet/wap application. Go to www.operamini.com for more info Mitch Hedberghttp://www.brainyquote.com/quotes/authors/m/mitch_hedberg.html - I drank some boiling water because I wanted to whistle. On Mon, Jun 15, 2009 at 7:24 PM, Jack j...@jackcwood.co.uk wrote: Hi anyone know where i can down load a user form quiz that ha name tel numbe then 10 questons that would then save the results to a protected sheet ?? --~--~-~--~~~---~--~~ - 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: UserForm
What is the criteria on the name? does the user at some time enter his/her name and number of does the develeper do this on the sheet? the develeper select his/her name from a list on the userform? This email has been forwarded using a mobile phone with a internet/wap application. Go to www.operamini.com for more info Samuel Goldwynhttp://www.brainyquote.com/quotes/authors/s/samuel_goldwyn.html - I'm willing to admit that I may not always be right, but I am never wrong. On Tue, Jun 16, 2009 at 11:02 AM, Jack j...@jackcwood.co.uk wrote: Name tel Would come from a sheet1 Cols a and b Also questions from sheet 2 cols a b - I need to collate the answers on sheet 3 and only the user can view the quiz user form Thanks for you reply On Jun 16, 8:09 am, Phillip Swanepoel pswa...@gmail.com wrote: what kinda ten Q's u need? where does the names and tel numbers come from? you want to fill it in r must it come from the sheet? Do you want to view the sheet? print the sheet? etc please reply with more spesific specs. would be nice if you can attach a sample or pix of what you vision This email has been forwarded using a mobile phone with a internet/wap application. Go towww.operamini.comfor more info Mitch Hedberg http://www.brainyquote.com/quotes/authors/m/mitch_hedberg.html - I drank some boiling water because I wanted to whistle. On Mon, Jun 15, 2009 at 7:24 PM, Jack j...@jackcwood.co.uk wrote: Hi anyone know where i can down load a user form quiz that ha name tel numbe then 10 questons that would then save the results to a protected sheet ??- Hide quoted text - - Show quoted text - --~--~-~--~~~---~--~~ - 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: scamble names on work roster
Hi... anybody looking into this? Are there a solution? Apreciate all feedback and help... On 5/24/09, Phillip Swanepoel pswa...@gmail.com wrote: I include the sample file... Hi all.. I got this roster on a excell work book. Could you please help me to get the following. the names on the first collumn has to be put random in the grid below the roster. but first check and see if the person work morn shift. only if person 4 is working morning on monday 18 may then his name can be added to the grid below every week i print one of these rosters. these names must be scrambled every week on the below grid. the last condition is that the names must be duplicated as littel as possible From time to time i add or take away names. -- This email has been forwarded using a mobile phone with a internet/wap application. Go to www.operamini.com for more info --~--~-~--~~~---~--~~ - 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: VBA Help (Follow up)
Did anybody fix this workbook that was send with this email? workbook in question is called CallLogging_newA.xls and it has been send on 28 March 2009 08:11 PM. Thanx Pswanie - Original Message - From: Ashish Jain To: excel-macros@googlegroups.com Sent: Saturday, March 28, 2009 8:11 PM Subject: $$Excel-Macros$$ VBA Help -- Forwarded message -- From: Hems coolh...@gmail.com Date: Sat, Mar 28, 2009 at 4:27 PM Subject: VBA Help To: 26may.1...@gmail.com Dear Ashish, This is my 1st mail to you. I am really thankful to you for making life easy for us through your subject knowledge. I am very much inspired from your knowledge and trying my first project in macro and VBA. I am working in airline solution company and working in internal solution where user logs a call with my team and we solve it. Now I am trying to make a call logging utility. There few issues appreciate if you help me with it. · To view the list of call · In Main form, today’s date should always appear on loading of form · In main form the data should be picked up from drop down and not any other. · After entering the respective called in called form all the details should be displayed in frozen ways. · After call id is generated and call is closed the mail should go to respective mail add. Kindly find attached the template. Please feel free to make the changes for betterment of it. Thanking you in advance Appreciate if you keep our mails between us. Thank you, Kind Regards Hems -- Regards Ashish Jain --~--~-~--~~~---~--~~ - 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$$ 365 inspirational qoauts to be in excel file
Hi I created a file from excel that our people use daily. now i want to make a page with in column a down 365 qoauts or bible verses. the code to get to either print or display this i got figured out. what i need though is the qouats. ;-) any one know where i can download/copy paste such file? Thanx in advance --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~--~~~~--~~--~--~---