Changing all formulas in sheet

[Himesh1]

Hi,

Would it be possible to change all the formulas in a spreadsheet when changing a cell from the drop down list.

For example, I have a formula that copy data from another spreadsheet for one person on the drop-down list, but when I choose another person from the drop down list I want the formulas to change. Is this possible to do?

[Glenn Kennedy]

Yes. Probably.

BUT...

We need to see a sample excel sheet showing what you're trying to do. The yellow banner (top) provides guidelines.

[Pete_UK]

The short answer is yes, but if you need to know how to then you should attach a sample Excel workbook, as detailed in the yellow banner at the top of the screen.

We have no idea from your description how your data is laid out, so it is impossible to suggest formulae to help you achieve the outcome that you want.

Pete