MattKatz Posted January 21, 2015 Report Share Posted January 21, 2015 I am building a spreadsheet for some items we purchase that are bought in GBP and the dollar value changes daily. Is there a way to make a Cell multiply against a value that changes daily like by getting the info automatically when opened from a website? What I want to see is what my USDM cost is at the moment I look at the spreadsheet so I don't have to do manual calculations. Any info and help would be awesome. Quote Link to comment Share on other sites More sharing options...
90G60 Posted January 21, 2015 Report Share Posted January 21, 2015 Macro or VB. Both I suck at, so I will move on. Quote Link to comment Share on other sites More sharing options...
MattKatz Posted January 21, 2015 Author Report Share Posted January 21, 2015 Yeah you just spoke like portugermanexico to me. Quote Link to comment Share on other sites More sharing options...
DavidBaustert Posted January 21, 2015 Report Share Posted January 21, 2015 This should help you: http://www.howtogeek.com/howto/24285/use-online-data-in-excel-2010-spreadsheets/ Quote Link to comment Share on other sites More sharing options...
unfunnyryan Posted January 21, 2015 Report Share Posted January 21, 2015 Google Docs has a function to do this automatically. Quote Link to comment Share on other sites More sharing options...
MattKatz Posted January 22, 2015 Author Report Share Posted January 22, 2015 Ive been googling how to do it but damn it looks like its above my head and excel knowledge skills. Quote Link to comment Share on other sites More sharing options...
MattKatz Posted January 22, 2015 Author Report Share Posted January 22, 2015 That actually looks like I can understand that....Ill try it after dinner and see if it works....Thanks Quote Link to comment Share on other sites More sharing options...
DavidBaustert Posted January 22, 2015 Report Share Posted January 22, 2015 That actually looks like I can understand that....Ill try it after dinner and see if it works....Thanks Should be pretty Straight forward. I've done it with some of our non-domestic equipment quoting spreadsheets to convert Yen to USD. I would even use that same site if you can. Quote Link to comment Share on other sites More sharing options...
Berto Posted January 22, 2015 Report Share Posted January 22, 2015 Gray out the cell with GBP and put no content. When someone clicks on it to try to see the content have a pop up box that says 'This is 'merica' Quote Link to comment Share on other sites More sharing options...
Gergwheel1647545492 Posted January 22, 2015 Report Share Posted January 22, 2015 Very easy step by step guide. I got this to work for me in Excel 2007: http://www.howtogeek.com/howto/24285/use-online-data-in-excel-2010-spreadsheets/ Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.