I have been searching and searching for a macro to move data into an existing worksheet and now humbly bow to the Guru Team.
My workbook consists of sheets named eMailThis, Results, Banks, Landlords and seven sheets (CopyHere_1 - CopyHere_7 each with 13 columns). From column 5 and 13 it has to filter and remove rows to the sheets named Landlord and Bank based on text values of (from column 5) rnt or RNT to Landlords; and from column 13 values of BANK, TRUST, MORTGAGE, LLC, LOANS, LOAN, MAE, INVESTMENT and/or ESTATE to the Bank sheet. The next step is have the remaining data rows in the seven CopyHere sheets move to the Results and the data from the Banks sheet be at the end of the data copied from the CopyHere sheets, the eMailThis sheet uses formulas (Proper, Right, Left and Copy) to sort the data from the Results page to send into Publisher as a data source to populate emails.
Thus far all the macros I've attempted to use/alter create a new sheet "Summary/Master' and this results in #REF errors on the eMailThis sheet, (and with my extremely limited VBA knowledge,) a huge headache! I've done the recording but Oiy! that was a mess to look at...
From an extremely grateful fan of my saviours! (btw, Your answers will fill my Christmas sock this year.)