Excel spreadsheets

Copper Contributor

I have a spreadsheet with a list of club members data Names, address phone etc.

Can I easily have a couple of those details automatically transfer to another sheet and remain constant even if main sheet is resorted by different category?

1 Reply
Yes, you can do that by VLOOKUP or INDEX-MATCH.