Excelguru - excelguru.ca - Excelguru.ca
General Information:
Latest News:
Loop and sum via VBA 27 Aug 2013 | 05:52 pm
I need help. How to add some value to the existing value but for multiple rows and multiple columns via VBA macros This example has only three columns, I need to independently adjust the VBA code in...
Number format in formula with text 27 Aug 2013 | 04:31 pm
How do I get the latter sum of this formula to return the value in percentage, not as a decimal number: ="No of girls: "&(SUM(AT2:AT260))&" / % girls:"&((SUM(AT2:AT260)/(SUM(AS2:AS260)))) I.e. as re...
Select and Copy a Set of Data in a Column based on starting and Ending Values 27 Aug 2013 | 01:00 am
I have a macro that copies three sections of data from a word document and pastes it within the Excel worksheet. The column of data is pasted in a single column starting at A1 (data to be space-delimi...
Duplicating a formula for other categories 26 Aug 2013 | 11:31 pm
Hi all, I'm currently creating a document (pdf) finder, I have attached the final version for you to see how it works. The field named 'file path' has a formula which I would like to duplicate for a...
Fomula for Percentage Calculation 26 Aug 2013 | 05:08 pm
HI Sir, I have table for Quality , where data validation sources are YES, NO and Blank , I want a formula (Quality %) where if I choose yes for one box , no for other and blank as well. The percentag...
Calculate Consolidated Summary 26 Aug 2013 | 02:48 pm
Hello XL Mac Guru's hope you are all doing fine. here's my requiremnts Project A worksheet: contains values for a row stating Preparation, Design, Execution, Total Project B worksheet: contains va...
Help with Spreadsheet 26 Aug 2013 | 01:07 pm
Hi, I was hoping to get some help with a spreadsheet I have for footballing stats. I am was trying to get a "database" on one sheet with players and info etc filled in on that sheet. Then on a second ...
Autofilters 26 Aug 2013 | 04:27 am
Hi Guys i'm using the following to autofilter a field by month Worksheets("Master").Range("$A:$AB").AutoFilter Field:=5, Criteria1:=xlFilterAllDatesInPeriodJuly, Operator:=xlFilterDynamic this work...
MouseOver/MouseHover Event On Autoshapes 25 Aug 2013 | 10:38 pm
Hi, In excel on 'Sheet1' there is an image of world map on which there are few points that are AutoShapes. On 'Sheet2' i have data from where data like Employee count by Function for each country ar...
MouseOver/MouseHover Event On Autoshapes 25 Aug 2013 | 10:37 pm
Hi, In excel on 'Sheet1' there is an image of world map on which there are few points that are AutoShapes. On 'Sheet2' i have data from where data like Employee count by Function for each country ar...
