Calculated Column to the report sheets?

Options

Hi

I have a report sheet but that pulls in data from other sheets, I wanted to add another column that does the vlookup and gets the corresponding values from another sheet.


But in the report version, the only way I could add a column is by referencing it to other sheets. Is there any way I could add a column?

I can create another sheet but it won't stay dynamic incase I add more sheets or rows to the connect sheets.


Thank you

Best Answer

Answers