Thanks, I can see why it isn't working. It's really too bad this program doesn't have more Excel functionality for referencing cells - ie moving a referenced cell changes the reference on the the Query page. I know I could export this to Excel with the formatting etc., but that is not a viable option in this instance where I am consolidating several companies in different currencies.