Using the ODDFPRICE Function in Excel http://excelmooc.com/using-the-oddfprice-function-in-excel/ Create Excel UserForms For Data Entry In 6 Easy Steps: Tutorial And Practical Example https://powerspreadsheets.com/create-excel-userforms/ What is Break-Even Point (BEP)? https://exceldatapro.com/break-even-point/ How to Use Excel Wildcard Characters in Formulas http://excelitch.com/how-to-use-excel-wildcard-characters-in-formulas/ See New and Exciting Excel Content at: https://dhexcel1.wordpress.com/
One of the commonest tasks that we accounting professionals are required to undertake frequently is getting information from a website into excel. Here is a video that explains the basic concepts quite succinctly.
However, I will still like to explain the basic and fundamentals of the same here. in my own words. The first limitation that requires understanding is that the data on the web has necessarily to be in a preformatted tabular format, to be correctly retrieved and displayed in Excel. This Office Article explains that, so I won’t go in depth into that.
CA Vikram S. Mathur
22-Feb-2017 | 11:13 Hours IST
INRODUCTION TO THE AUTHOR
The author is not very well known at the time of starting this blog, as a VBA Professional. In truth, he has been a VBA Professional since the early 2000’s. It was around 1995, when the author, a qualified Chartered Accountant, first began dabbling with the Visual Basic for Applications (VBA) interface available in the MSOffice’95 software. He had also been dabbling with the Microsoft Access 3.0 programming since about the same time. But at this time, it was merely a hobby, to be indulged in whenever the author got time off from his professional assignments, which basically boiled down to sitting on his computer only at night, say after 10:00 pm, qualifying the author to be called a ‘Night-Bird’ by friends and family alike.
So, that is about the author, now you ought to know that this blog is being managed by the DeadlyVBAProgrammer and there is a facebook group also associated with this wordpress site at DeadlyVBAProgrammer-FBGroup which is a closed group so the Group Admin (me, in this case) will have to approve your membership. Only those people who are serious about their VBA Programming skills should apply, else the Group Admin reserves the right to eject anyone who by any means, fair or foul, enters the group, but fails to present his credentials as a valid VBA Programmer.
CIAO for now,
CA Vikram Shankar Mathur