I hope someone can help, because despite extensive searching and trial and error I am getting nowhere...
My aim is to select a postcode area (eg. BS10, L20, LS9) and radius in miles, and the map visual will show all staff within that radius around the chosen postcode area.
I have two tables of...
strange
in which case maybe
put the sample spreadsheet onto a share
I only tend to goto OneDrive, Dropbox or google docs , as I'm never certain of other random share sites and possible virus.
Please make sure you have a representative data sample and also that the data has been desensitised...
I have tried this code but didn't work.
>>> use code - tags <<<
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)'Author: Jerry Beaucaire, 8/12/2011'Summary: Make choices from DV drop downs into formulas, so any changes' in the source lists will flow out to the...
To see what is possible, you could take a look at Craig Hatmaker's PapaGannt workbook
PapaGantt - The Big Daddy of XL Gantt Charts - Beyond Excel (google.com)
...is as open as "Can you buy a Ferrari with money?"
Tree map is not a standard chart type in Excel 2013. Then again, all charts can be reduced to an X/Y scatter if you know the maths behind.
Example can be found here. https://sites.google.com/site/e90e50fx/home/square-chart-and-treemap-in-excel
Hello Chihiro.
Thank you for your great suggestions.
I have been searching on Google for some ideas.
Do you know of any sites that have example workbooks that i could download and play with?
Cheers.
;-)
On google trends what people care to search for about the word excel
excel 2019
excel calendar 2019
excel mouscron (soccer club)
pdf to excel convertor
Countries that search for the word excel the most =
St. Helena
China
Singapore
Colombia
Guatemala
US is 34th
the least=
South Korea...
...the formulas;
But I have hardly had success!
The most repeated is:
https://arxiv.org/ftp/arxiv/papers/1704/1704.01142.pdf
https://sites.google.com/site/beyondexcel/project-updates/multi-cellarraymodelling
And within the Forum I have only been able to find these three implementations of the...
...but it is not exactly follow along step-by-step training. Again Craig Hatmaker has described some of the methods I use
(https://sites.google.com/site/beyondexcel/project-updates/multi-cellarraymodelling)
and he also has interesting things to say on Names and transparency. I have published a...
@MSC Bobs
If you want an ally, Craig Hatmaker
https://sites.google.com/site/beyondexcel/home
is a strong advocate of the methods you propose, even applying them to financial models as opposed to data analysis.
Some things are on your side in that it is becoming easier to cope with cross-tab...
Azman Ali M.Habib Rahman
Have You checked next links?
>> How to Create QR Code List for MS Excel
https://sites.google.com/site/e90e50fx/home/generate-qrcode-with-excel
>> Or this?
http://www.keepautomation.com/products/excel_barcode/barcodes/qrcode.html
There is also a good discussion about combinatronics at:
https://sites.google.com/site/e90e50fx/home/combinatorics-using-excel-formulas-and-examples
I'm not sure how applicable it is to your problem
...memory, but the girl and guys from The Frankens team*developed a calendar control for all office versions, including 64 bit.
https://sites.google.com/site/e90e50/calendar-control-class.
They updated it in 2017.
* Roberto Mensa, one of the three members, has a user account over here, but...
...that is. Craig is a leader when it comes to Excel, not a follower. To form your own opinion take a look at his blog
https://sites.google.com/site/beyondexcel/home
I could spend months there! It is what happens when an IT professional meets and adopts Excel. A fairly recent and, to me...
...terminology but i tried to explain it as best i could. as i said i have found a solution that i was able to modify from:
https://sites.google.com/a/madrocketscientist.com/jerrybeaucaires-excelassistant/merge-functions/consolidate-wbs-to-one-sheet
i do not know how to correct the table to...
I am trying to get info from online sites automatically and refresh it but it does not work to crash or can not read it. It can reference a blank page perfectly but then that defeats the purpose. LOL
How can I make something work? If it does not wokr on one site maybe another but still I don't...
@torben You might like to have a look at Craig Hatmaker's site for ideas
https://sites.google.com/site/beyondexcel/project-updates/papagantt-thebigdaddyofxlganttcharts
Craig is of the mindset to contribute to the community so would be supportive. Quite a while ago, I set out by placing shapes...
HI Everyone
I have a VBA Code to open and auto login a separate web pages (Nearly 10). i need to open all these macros with single click, so i have call all of these macros by button. the problem is this all are opening with new internet Explorer application.
What i need is when i click the...
...for what are called slope graphs.
See these links for more information :
https://peltiertech.com/slope-graphs-in-excel/
https://sites.google.com/site/e90e50fx/home/Edward-Tufte-slopegraphs-in-excel
http://stephanieevergreen.com/slopegraph/...
Hi ,
All those who use Excel at work can make use of these techniques :
https://sites.google.com/site/beyondexcel/project-updates/multi-cellarraymodelling
Narayan