In support of this Thread
https://www.ozgrid.com/forum/index.p...23#post1241623

Before
_____ Workbook: Sample excel file.xls ( Using Excel 2007 32 bit )
Row\Col A B P Q R S T U V W X Y
2 15 16 17 18 19 20 21 27
3 SLA Su M T W Th F S Su M T
4 RunbookBCompletionTime 6:00AM
5 ActiveProducts N/A
6 ActiveSKUs N/A
7 Pending N/A
8 Completed N/A
9 CompletedOrderCount N/A
10 PendingOrderCount N/A
11
12
13 Active
14
Worksheet: Sheet1
http://i.imgur.com/jrBBlXT.jpg

text file: Sample.txt
Code:
---------------------------------------------------- 
This is a  report for last week 
---------------------------------------------------- 
 
Date,RunbookBCompletionTime 
20201116,05:44 AM
20201117,05:47 AM
20201118,05:39 AM
20201119,06:10 AM
20201120,05:49 AM
20201121,07:13 AM
20201122,06:01 AM
 
Date,ActiveProducts 
20201116,24
20201117,244
20201118,245 
20201119,24 
20201120,249 
20201121,250 
20201122,250 
 
Date,ActiveSKUs  
20201116,137
20201117,13
20201118,13
20201119,1368
20201120,13
20201121,1381
20201122,13
 
Date,CompletedOrderCount 
20201116,24
20201117,24
20201118,3
20201119,24
20201120,63
20201121,69
20201122,8
20201123,9
 
Date,PendingOrderCount 
20201116,18
20201117,5405
20201118,6114
20201119,6
20201120,6482
20201121,74
20201122,128
20201123,4

After runningSub LookInAndImportTextStringSample()
https://i.imgur.com/0m881xs.jpg
_____ Workbook: Sample excel file.xls ( Using Excel 2007 32 bit )
Row\Col P Q R S T U V W X Y
2 15 16 17 18 19 20 21 27
3 Su M T W Th F S Su M T
4 05:44 05:47 05:39 06:10 05:49 07:13 06:01
5 24 244 245 24 249 250 250
6 137 13 13 1368 13 1381 13
7
8
9 24 24 3 24 63 69 8 9
10 18 5405 6114 6 6482 74 128 4
11
12
Worksheet: Sheet1





Share ‘Sample excel file.xls’ : https://app.box.com/s/hw4uxwjlm8t8zty17kc07xihq0bfhifs
Share ‘Sample excel file.xlsm’ : https://app.box.com/s/ccmk5sgazueejb4dc0eqw6yex0zhjar2