Hi Friends,
I did check other posts on Mrexcel forum but did not find suitable to my needs.
Right now I am doing this manually.
I have Name folder with workbooks names like names1(ColumnA:Adata), names2(ColumnA:A data) and so on. And another workbook on desktop with name Strings(with data in ColumnA1 and ColumnB1).
I need to combine ColumnA1(stringsworkbook) and ColumnA:A(names1) and ColumnB1(Stringsworkbook).
I need to do this for all workbooks in that Names folder and output results in Namesoutput folder
Note: &qs=&format=rss&count=50 in this string, ending number does not change.
Workbooks and sample final out attached to look into.
I did check other posts on Mrexcel forum but did not find suitable to my needs.
Right now I am doing this manually.
I have Name folder with workbooks names like names1(ColumnA:Adata), names2(ColumnA:A data) and so on. And another workbook on desktop with name Strings(with data in ColumnA1 and ColumnB1).
I need to combine ColumnA1(stringsworkbook) and ColumnA:A(names1) and ColumnB1(Stringsworkbook).
I need to do this for all workbooks in that Names folder and output results in Namesoutput folder
Note: &qs=&format=rss&count=50 in this string, ending number does not change.
Workbooks and sample final out attached to look into.
Hightail Spaces
Hightail Spaces lets you send unlimited files, of any size, to anyone. Collaborate with your team and evolve your work.
spaces.hightail.com