My first try at adding html example (hope it works)
I've spent the last hour trying to come up with a solution but nothings working. I have included the simplified example below. I will have up to 30 columns of data on the final version.
On sheet 1 have my data. On sheet 2 B2:B11 should automatically update assuming the value in B1 matches sheet1 B1:D1
So changing the date should return
I'm sure the answer has something to do with Vlookup.
I've spent the last hour trying to come up with a solution but nothings working. I have included the simplified example below. I will have up to 30 columns of data on the final version.
| Excel Workbook | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | pdk | 10/10/2010 | 24/10/2010 | 5/11/2010 | ||
| 2 | 1 | 1423 | 1056 | 6544 | ||
| 3 | 2 | 1678 | 2943 | 2134 | ||
| 4 | 3 | 3809 | 4854 | 9098 | ||
| 5 | 4 | 3287 | 9286 | 5176 | ||
| 6 | 5 | 9024 | 8265 | 8537 | ||
| 7 | 6 | 6497 | 3851 | 9871 | ||
| 8 | 7 | 1408 | 4325 | 5432 | ||
| 9 | 8 | 5490 | 4543 | 3423 | ||
| 10 | 9 | 3247 | 4334 | 5443 | ||
| 11 | 10 | 4317 | 9763 | 4533 | ||
Sheet1 | ||||||
On sheet 1 have my data. On sheet 2 B2:B11 should automatically update assuming the value in B1 matches sheet1 B1:D1
| Excel Workbook | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | pdk | 5/11/2010 | ||
| 2 | 1 | 6544 | ||
| 3 | 2 | 2134 | ||
| 4 | 3 | 9098 | ||
| 5 | 4 | 5176 | ||
| 6 | 5 | 8537 | ||
| 7 | 6 | 9871 | ||
| 8 | 7 | 5432 | ||
| 9 | 8 | 3423 | ||
| 10 | 9 | 5443 | ||
| 11 | 10 | 4533 | ||
Sheet2 | ||||
So changing the date should return
| Excel Workbook | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | pdk | 24/10/2010 | ||
| 2 | 1 | 1056 | ||
| 3 | 2 | 2943 | ||
| 4 | 3 | 4854 | ||
| 5 | 4 | 9286 | ||
| 6 | 5 | 8265 | ||
| 7 | 6 | 3851 | ||
| 8 | 7 | 4325 | ||
| 9 | 8 | 4543 | ||
| 10 | 9 | 4334 | ||
| 11 | 10 | 9763 | ||
Sheet2 | ||||
I'm sure the answer has something to do with Vlookup.
