I have a big table that from row 5 to row 4934, and goes from columns A to O. I created a macro to create a new worksheet with three columns to copy the data over from the other worksheet. Values from columns A,D,G,J and M in the original worksheet need to go in the first column of my new worksheet. The problem is that I need to the data to be copied row by row. For example, if cell A5=245 and cell D5=16, I would need 245 to be inserted first into my first column on my new worksheet and 16 right under it in the same column.