I am trying to develop a macro which easily lets me transfer energy bill data from on workbook to a table in another. I've made the part which simply copys and pastes rows, but now i need to find a way for it to work out which rows need to be copied for itself. This is a problem because my criteria is a bit awkward
i only want rows to be copied if there aren't any duplicates in the destination table (most of the data in the source file will already be in the destination table, so i obviously dont want any duplciates). To avoid copying duplicates, i need to make sure both the date and building aren't found together in a row in the destination table, but i really dont know how im going to write such a calculation in VBA.
Here is the code i currently have, it only copies and pastes a single row into the destination table.
Please Login or Register to view this content.
Bookmarks