Hi. I have a worksheet containing colums of data. I want to copy data from one worksheet to another in order to create a report. One of the columns I wish to copy contains dates. The other contains data. What I want to do is copy the data column so that only the non blanks are copied. I want to copy the dates that correspond to the data extracted from the other column and paste them inside another worksheet on the same row. In otherwords only the cells containing data are copied with there dates.
Is this clear? Could anybody help me out?
Is this clear? Could anybody help me out?