$$Excel-Macros$$ posibly a sumif or such problem

2020-06-18 Thread Phillip Swanepoel
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

$$Excel-Macros$$ screenshot window and send via whatsapp to contact

2018-08-18 Thread Phillip Swanepoel
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

$$Excel-Macros$$ select one of 6 cells down

2018-06-28 Thread Phillip Swanepoel
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 --

$$Excel-Macros$$ sumif kinda formula needed

2010-09-02 Thread Phillip Swanepoel
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

$$Excel-Macros$$ Birthdays list formula or macro

2010-08-20 Thread Phillip Swanepoel
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

$$Excel-Macros$$ Display birthday person name on userform

2010-08-19 Thread Phillip Swanepoel
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

Re: $$Excel-Macros$$ BeforeSave - Enabling Macros

2010-02-04 Thread Phillip Swanepoel
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

$$Excel-Macros$$ Re: $$ TIP $$ Backing up Excel Files

2009-09-17 Thread Phillip Swanepoel
/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

$$Excel-Macros$$ Re: UserForm

2009-06-16 Thread Phillip Swanepoel
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

$$Excel-Macros$$ Re: UserForm

2009-06-16 Thread Phillip Swanepoel
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

$$Excel-Macros$$ Re: scamble names on work roster

2009-05-26 Thread Phillip Swanepoel
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

$$Excel-Macros$$ Re: VBA Help (Follow up)

2009-04-14 Thread Phillip Swanepoel
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,

$$Excel-Macros$$ 365 inspirational qoauts to be in excel file

2009-01-05 Thread Phillip Swanepoel
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