This seems like it should be really simple but I can't figure it out. The format of the report that I receive has the date in one cell at the top and the remainder of the data in another place so I would like to grab that date and store it to a variable to that when I import the data to my table I can add the date to all the records. I've always used the transferspreadsheet which doesn't seem like it would work in this situation. Any ideas? Thanks!