I have created a cell that concatenates mult cells to create one formula. I
have copied this cell and past special into another cell to try and activate
the formula. I can select the data in the cell and press enter, This means
(I think) I can not create a maco to automate this (when I created the macro,
the select will hold the amount in the macro insted of making it dynamic)?

I want to change the date and have the formula look into a different file
and update for a vlookup.