Import a text file via macro, then select and import certain data.

Hi all,

Macro noob here, would love some help.

I have a simple Excel table where I would like to import a .txt file via the button on the spreadsheet and auto populate the cells 'calibration flashed'.

So UNIT 1 would populate cells C8 and C9 with the info contained in the UNIT 1 section of the .txt file and so on.

The reason this is difficult is there is a set .txt format, so some bits of info will need to be ignored in the txt file.

Documents are attached as is a screen shot of the sheet and the text file.

EXAMPLE.PNG

This is a simple version of what I'd like in the end, but this will help me with some starter macros.

Thanks for any help!
James