Excel question

Cheensbo

Hi folks,

Sincere apologies if I'm not in the right place,

Might have trouble articulating what I'm trying to do so bare with me.

I have a request for help, basically I am filling data from multiple sheets to a master sheet, simples.

The sheets I am working from are protected so cannot be directly copied over, so ive found myself manually putting in the links.

Now, all of the satellite sheets are the same, i.e. data is in the same location in each, only the name differs for example:

=SUM('[Rates Evaluation Section 1.xlsx]Level 1A'!$D$19)

=SUM('[Rates Evaluation Section 2.xlsx]Level 1A'!$D$19)

Is there any way I can change the directory to pickup the entire column at its new name, rather than changing each individual cell to the new name?


Sorry if I'm making no sense at all

Viscosity1

do a ctrl + h on the columns and replace "section 1" with "section 2"

Cheensbo

Viscosity1 wrote: »

do a ctrl + h on the columns and replace "section 1" with "section 2"

Thanks a million, jeez im stupid

You have no idea how long ive been manually inputting these :pac: