I capture a value from
sqlcheck= "select mobile_num from requests_detail where req_id = " & a &" "
How can i write this value Wire_Num to the data Global sheet. And later use this in another script that i run.
You didn't specify a column name so this places it in first column. Remember, once your script ends, these values are lost. You also must have created the column prior to running the test.
A good rule of thumb is to never measure with your thumb.