Adding column to an array

Hello all,

I have got a VBA code which pulls data from a table on website. This data you can find on sheet called Sheet1. But my desired table i want it to look like is visualised in sheet called Desired. Would it be possible to add two variables to an array from website? The variables I want to add are nowDate, nowTime, cat, website.

Please Login or Register  to view this content.

Where are the variables in the URL "http://www.dolphinfitness.co.uk/en/protein-isolate", False?
I could not find them in the website either.
Where exactly do you see these values in the web page? I can only see a table with 3 columns? Could you attach the URL where these data are found?

The website contains table only three columns. I want to add other 4 custom variables defined by user or the time when the macro is ran so i could keep a history on price changes. Does that make a sense?

To increase the size of the array or columns is not an issue, but the value of the category column appears to change (As per the desired output), so I do not know how you are going to get these values?
There are many ways of adjusting the array. Quick and dirty fix which does not require looping, but inflexible is:

Please Login or Register  to view this content.

Another option:

Please Login or Register  to view this content.