Merging data
Answering RichR's question I've made this example.
You choose the person and all data about it from every sheet appears below.
The formula I used is:
=INDIRECT(ADDRESS(The_One+1,COLUMN(),,,$A5))
Attachment | Size |
---|---|
Example mr. AAA.xls | 27 KB |
Recent comments
5 years 27 weeks ago
6 years 13 weeks ago
6 years 25 weeks ago
6 years 28 weeks ago
6 years 29 weeks ago
6 years 34 weeks ago
6 years 43 weeks ago
6 years 43 weeks ago
6 years 43 weeks ago
6 years 43 weeks ago