Copy real time data from p-drive

[Stephanie1122]

[FONT=&quot] I am new to VBA programming I know how to copy data from a range and paste it on another range. But I can’t figure out how to copy real time data (the data changes everyday) in a workbook located on a p-drive to another workbook that I created. Some of the cells on the real time data are blank and I only need to copy cells with values (some are in form of text). Can this be possible? Thank you[/FONT]

 

[oldbrewer]

2	3	4
	red	7
	1
				so in this 3 x 3 array
				you only want to copy
				2,3,4,7,1

<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>