Pivot Tables and VLOOKUP
I have set up a pivot table to sort similar items of a sheet that constantly
grows and then I enter information next to the pivot table and that information if returned to sheet 1 using VLOOKUP. My problem is if I change something after I've already entered the data next to the pivot table, the sort it had previously changed and the data next to the pivot table is not correct. I use office 2003. Is there a better way at doing this? |
Pivot Tables and VLOOKUP
Where is the source data for the pivot table?
Maybe you could enter the information in a column there, and use Vlookup on that table. Confused5627 wrote: I have set up a pivot table to sort similar items of a sheet that constantly grows and then I enter information next to the pivot table and that information if returned to sheet 1 using VLOOKUP. My problem is if I change something after I've already entered the data next to the pivot table, the sort it had previously changed and the data next to the pivot table is not correct. I use office 2003. Is there a better way at doing this? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 12:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com