Not sure if that's what I'm looking for.

The Name "Guest-DB" was an error.
The worksheet sheet name is "Guest-DB", but
The range I want it to add to is located on worksheet "Guest-DB" range name is "GuestData".


GuestIP is a single row where I manually enter some of the information, other parts of the row calculate information. Once the information has been verified I add the values to the "GuestData" range.

I don't want the calculation "formulas" from the input range "GuestIP" in the output range "GuestData",
just the values.
I want each record in that, ("GuestData"), range unchanged after it's been added.

vlookup formulas else where in the workbook look up "GuestData" for information about a guest.

If the line you show just changed "GuestData" by one line and that all it does, I could use it.

Thank you
JWD