So I have a program that exports a calendar in HTM, for multiple rate types.
I can import individual pages data as if it was another workbook (scraping from locally generated htm files)
I want to do so elegantly. I have a top row of header information
the link for the scrape looks like this in cell a2, then repeats across and down and works
ufo is specific, there are others, I would copy worksheets and have it pull the code
I want to, in my scraping workbook, have UFO be on my top row (cell a1)
and have what file is scraped be contained in a formula, I thought it would be
but no good.
I've tried every text connector I can think of such as