Hello,
I am attempting to create a macro that deletes a wide range of data in a table and copies and pastes new information in to that area that is taken from a source file. However, I am having trouble adjusting both more and less data. I first figured out various test with the lastrow/Range. option but all I could get is a count of rows, I have added another prompt that was more successful as it adding/deleted rows however I had a problem keeping it from deleting the last line which would have the formulas summing the numbers. Could anyone please assists with figuring out this problem?
I am attempting to create a macro that deletes a wide range of data in a table and copies and pastes new information in to that area that is taken from a source file. However, I am having trouble adjusting both more and less data. I first figured out various test with the lastrow/Range. option but all I could get is a count of rows, I have added another prompt that was more successful as it adding/deleted rows however I had a problem keeping it from deleting the last line which would have the formulas summing the numbers. Could anyone please assists with figuring out this problem?
