I am looking to be able to have Excel delete duplicate cells from the next 2 rows after i have pasted in data.
I have a spreadsheet that 3 rows of data about a race. When I paste the whole list of races into the spreadsheet, I have to go and manually delete the duplicated race time and event location, before other calculations on the spreadsheet can work properly. Is there an If statement i can put in a cell for instance, that will check the cell above for duplicate data and then empty the cell if it is. Or is there a more efficient way to do that with VB, with only selected rows of data please? I can be pasting 60+ lines in a day, and deleting this extra data manually is inefficient.
This is currently how the data looks when I paste the race data into the appropriate columns in a single paste.
|3||14:00||Bang||Beat The Tide|
|3||14:00||Bang||What A Scorcher|
As the duplicate lines are deleted it allows other data to change on the spreadsheet.
This is how I want it to automatically look after pasting the data in.
|1||14:00||Bang||Beat The Tide|
|3||What A Scorcher|
As you can see, the number to the left, (as well as other things not shown here) change automatically.
I just can't figure out how to do an If statement for this for each cell.
Thanks for your help in advance.