Hi All,
I'm new to using macros etc and have no experience in how to use VBA but believe this is the way forward for what I'm looking to do (if it is even possible!!)
Essentially, what I want to do, is to have a macro that looks at a particular cell and then opens a file (which is in a specific folder), sorts the data, copies some of the data and then pastes it into a table the original spreadhseet. It then repeats this for a different file in a different folder.
It would then need to do this for several cells within the original spreadsheet.
Can anyone help??
Cheers
Bookmarks