Hi All,
I have been asked to automate a task which takes someone hours to do on a daily basis, due to the amount of data.
Attached is a spread sheet (nothing confidential as ran a dummy quote through a website).
Basically, column A contains the data I get from a website, in the format it is in. I want to extract the name which always starts with "1.", "2." etc, the next line which is the cost and then the line which says "Total:###", so long as the previous line starts with the word compulsory, as there are multiple totals on some data sets.
I want the data to be copied and pasted/transposed as they look in F1:H6.
I don't even know where to start with this, any help is greatly appreciated.
Thanks
Dustin
Bookmarks