Hi all,
I am looking to solve a problem that I don't think should be that difficult but I am struggling to figure out. I was able to do this pretty easily in Ruby but am looking to keep it to just Excel. I have a list of a few hundred URLs which are formatted the same with one variable. Here is an example of one of them:
[]https://www.tm3.com/tsproxy/servlet/tsmsrb?cmd=MSRB&Cusip=199491DY4&MorePrev=null&MoreNext=null&FirstSeqNo=null&LastSeqNo=null&LastTdate=null&FirstTdate=null&LastTtime=null&FirstTtime=null&startDate=null&endDate=null&startTime=null&endTime=null&minPrice=null&maxPrice=null&minYield=null&maxYield=null&minTradeSize=null&maxTradeSize=null&minSPVsMMD=null&maxSPVsMMD=null&NumberLines=25&TradeType=null
I bolded the part that changes within each URL. This links directly to a table. My goal is to run a macro that will pull all of these tables into a single sheet. Ideally, I would also be able to add that unique indicator (the bolded identifier) to the first or last column in the table that I generate. Any help would be greatly appreciated.
Thank you!
Bookmarks