Hi all bit stuck on this one,
I have pulled data from the web (multiple pages) using a macro. Whilst it works to an extent that is to say all the data is there the tables from each link appear all over the sheet. For example the first piece of content appears in column GE the following below that as desired but in column DB and so on the only content that appears in column A as desired is the final link. the data from each link is in tact but this is a fishing expedition. Could someone help me with a macro that will pull all the content to begin in column A whilst maintaining the order of appearance(row). If that didn't make any sense the only thing i want to change is the start column for each piece of content to column A. Thanks in advance for your help
Regards
Dan
I have pulled data from the web (multiple pages) using a macro. Whilst it works to an extent that is to say all the data is there the tables from each link appear all over the sheet. For example the first piece of content appears in column GE the following below that as desired but in column DB and so on the only content that appears in column A as desired is the final link. the data from each link is in tact but this is a fishing expedition. Could someone help me with a macro that will pull all the content to begin in column A whilst maintaining the order of appearance(row). If that didn't make any sense the only thing i want to change is the start column for each piece of content to column A. Thanks in advance for your help
Regards
Dan
