5,999 reputation
1823
bio website teylyn.com
location New Zealand
age
visits member for 3 years, 2 months
seen yesterday

enter image description here

Microsoft MVP - Excel

twitter: @IngeborgNZ


Jan
14
comment Multplie Series Scatter Plot
As a volunteer who spends precious free after hours and weekend time to answer questions here without any personal gain, reading "I'm too lazy" does not really tickle my fancy. I'm moving on. Good luck
Jan
8
reviewed Approve Excel not updating pasted as value formula
Jan
8
comment Multplie Series Scatter Plot
Unless you want to use VBA to automate things, the solution from charting guru Jon Peltier in your link is the way to go.
Dec
30
answered Drag a forumla, so that it increases by 17 each time
Dec
29
comment How to create an Excel Macro that works with any Excel workbook on my computer?
Tony, do us a favour and put a few more words into your question, so it is clear that you want the macros to run in any Excel file. State your version. It would be ridiculous to close a question as "unclear" that has an accepted answer.
Dec
29
answered How can I make a Msgbox pop up over other application?
Dec
29
comment How to create an Excel Macro that works with any Excel workbook on my computer?
@Twisty I can't believe you're asking this. That's what the flipping file is for. But for the record: Yep. It does contain macros/VBA. BTW, try googling for personal.xlsm. You'll find that Google serves results for personal.xlsb instead. Coz that's what Excel uses.
Dec
29
comment How to create an Excel Macro that works with any Excel workbook on my computer?
@Twisty Without changing the extension, the Personal workbook has xlsb on my system using XL 2013 on Win 8.1 and on the other machine with 2010 and Win 7.
Dec
28
comment How to create an Excel Macro that works with any Excel workbook on my computer?
@mdpc it's tagged with Excel, so I think you can ignore any spreadsheet system that is not Excel, no?
Dec
28
answered How to create an Excel Macro that works with any Excel workbook on my computer?
Dec
27
comment In Excel 2010 - Trying to get the cell address from where a formula got its answer
It takes less than a minute to create a Dropbox account. You may already have a OneDrive account. Or a Google account. All these can be used to share files. Without a data sample I cannot picture how ' "Vault" represents several areas on the raw data page for the vault scores not all in the same column.' If you want to reverse the formula that uses "Vault" then we need to know what "Vault" consists of. Better than a screenshot would be a sample file. Again, Dropbox, OneDrive, Google.
Dec
18
comment Excel formula to calculate the total time spent on various tasks
Mock up the desired result in your spreadsheet. Enter the numbers manually. Take a screenshot. Upload that to a free file sharing site, since you cannot yet post images. Post the link here.
Dec
12
comment Adding Index to Match formula
The last G:G is the column where the Match function looks for a match to the value of the Max function. Match(what,where,0). The "what" is your Max function. The "Where" is G:G. That will return a number. This number is then fed to Index(A:A, number)
Dec
12
answered How To Autofill (Using VBA) Until Adjacent Cell Equals a Particular Value
Dec
12
answered Adding Index to Match formula
Dec
9
revised Capturing Text from Pivot Table
added 61 characters in body
Dec
9
answered Capturing Text from Pivot Table
Dec
9
answered How can I write-protect a worksheet, while permitting link jumping to another worksheet to enter comments?
Dec
9
comment Capturing Text from Pivot Table
Be creative. Use a file sharing site. Post a link. If the computer says that you can't post a link, just post the url as text. Some people here will be able to copy and paste that into the address bar of their browser.
Dec
9
comment Capturing Text from Pivot Table
Can you mock up what you would like to see and post a screen shot? It is not clear what you want to achieve.