I currently have a spreadsheet which copies a formula, which has been put together using the concatenate function, and 'pastes special' in another cell.
The idea is that the formula ive put together in concatenate will show up in a different cell and the link will be active showing external data.
The problem i have is that the macro will paste the formula but the formula doesnt update so all i have is a list of links, i have to go through each manually, highlight it, press enter and then the link updates with figures (which can take along time with the amount of data)
Is there any VBA which will update the cells? everything ive tried hasnt worked.
Thanks
The idea is that the formula ive put together in concatenate will show up in a different cell and the link will be active showing external data.
The problem i have is that the macro will paste the formula but the formula doesnt update so all i have is a list of links, i have to go through each manually, highlight it, press enter and then the link updates with figures (which can take along time with the amount of data)
Is there any VBA which will update the cells? everything ive tried hasnt worked.
Thanks