pasterow

Hi all, I am writing a macro which does the following: Looks through a set range by name of the header to the bottom row of the table For each cell in that range if the value is nil, it cuts that row It then pastes that row somewhere else in the sheet - in the next blank row at the bottom...

Hi all, My basic requirement is this: I have a table of data that has been through some processing already. In it, there will be rows where a certain column, labelled "Invoice" will be blank. In those cases, I want to cut the whole row, and then paste it underneath the table in a new row. I...

Hey guys, I have found some different VBA codes and pieced it together to my current status. I do have some problems. The row is moving based on the value of column G where "GODKENDT" will move the row. The problem is that not all rows work and sometimes I can close the file, reopen and then...

Hi All I have a piece of code which simply copies data from all cells in one workbook and pastes it into a table in another. However I am finding that one column (Column N) which is in a "MMM-YY" format keeps changing the Year part from 17 to 18 when it paste values over. On the raw file all of...