I have a column of data in a worksheet (50 rows A1:A50). At the moment, the data is hard coded i.e. A1=sheet2!ab1,B1=sheet2!ab2, etc.
Sometimes there is no data in source cells (e.g. ab15 ,ab19 etc), which results in many blank rows in the destination worksheet. At the moment I am hiding the blank rows with code, which now creates a problem for me in extracting data into a Word doc.
Is there a way to populate the destination worksheet sheet such that the rows remain contiguous without any blank rows (i.e. no blank or hidden rows?).
Any help much appreciated, please bear in mind I'm new to VBA!
Cheers,
Peter
Bookmarks