Hay Guys
So I need some help with moving some data around.
Currently all the data I have is sitting in 1 column.
All of that data is being taken from another sheet so =location name of sheet cell reference
I need to move that data to another column BUT if I try to copy it then it will be x number of rows out depending on how far I copy it.
what I think I need to do is lock the cells using $$ but I want to do this all in one go rather than one cell at a time manually.
Is there a simple way to do this?
I am reasonably good with excel but not doing VB lookup things.
Thanks for the assistance!
Bookmarks