Hello

I was reviewing the forum for a solution to my thought and came accross the thread 'UK Companies House API' a chap named Kyle123 developed a spreadsheet which linked up to companies house via a spreadsheet and pulled particular information.

I am learning on excel and trying to learn code.

I am unfortunately too much of a novice to understand the code on the spreadsheet.

What i am trying to achieve is a link to Companies house via an API which would pull the following data from Companies house based up a the 'company registration number'
I would like to see the following results 'Next Accounts', 'Next Accounts Due By', 'Confirmation Due by', Registered Office'

Here is an example of the spreadsheet i would like to show:

Company Name Company Number Next Accounts Next Accounts Due By Confirmation Statement Due By Registered Office Addres
A Limited 1234567 (Date) (Date) (Date)
B Limited 1234567 (Date) (Date) (Date)
C Limited 1234567 (Date) (Date) (Date)
D Limited 1234567 (Date) (Date) (Date)


Thank you

Marc