JacobBarton
New Member
- Joined
- Oct 2, 2014
- Messages
- 11
I have 5 columns of hyperlinks (A,B,C,D,E). Each column has 650 rows. The URLs contain xml data. Currently if I import a single URL From Web manually it creates a table with headers. I'd like to import the xml data from each column into it's own table on separate sheets. I'd like one table with a single header and all the data from each URL.
Column A to Sheet1, A1 import data to rows 1-10 (row one is the header), A2 rows 11-19 (no new header), A3 rows 20-28 (no new header), etc...
Column B to Sheet2...
What would be the most effective VBA approach?
Column A to Sheet1, A1 import data to rows 1-10 (row one is the header), A2 rows 11-19 (no new header), A3 rows 20-28 (no new header), etc...
Column B to Sheet2...
What would be the most effective VBA approach?