Hello,
I' really lost and unsure how to proceed. I think I need to use VBA to accomplish this, but I am open to suggestions. I have a complicated situation. I have 2 sheets in two different workbooks and the data in each sheet is arranged differently. On sheet 1, I have this:
HotelID Tax...