K
Kashgarinn
Thanks alot for your reply 
It sadly didn't help. I didn't really get what pivottable you wer
referring to with "sheet2" abc columns.
Here is an example how this looks like:
Type | Price | Profit
100mm Reinforced Steel Plates I | 49987 | 15648,1
100MN Afterburner I | 298870 | (blank)
| 398987 131490,8
| 208638,63
100MN Microwarpdrive I | 998870| (blank)
| 998987 | 14702,04
| | 93881,96
As you know, pivottables grouping together means that if there are
rows with the same item, then it puts an empy cell instead of repeatin
the name of teh item.
This is a quandary.. I've no idea how to solve it.. I'd love to b
able to do a doublevlookup somehow, but that doesn't sound like th
solution.
Could I do this at the access database level with the right query? ca
that work from one access table to another?
No idea how to do this, any help really appreciated
Regards,
K
It sadly didn't help. I didn't really get what pivottable you wer
referring to with "sheet2" abc columns.
Here is an example how this looks like:
Type | Price | Profit
100mm Reinforced Steel Plates I | 49987 | 15648,1
100MN Afterburner I | 298870 | (blank)
| 398987 131490,8
| 208638,63
100MN Microwarpdrive I | 998870| (blank)
| 998987 | 14702,04
| | 93881,96
As you know, pivottables grouping together means that if there are
rows with the same item, then it puts an empy cell instead of repeatin
the name of teh item.
This is a quandary.. I've no idea how to solve it.. I'd love to b
able to do a doublevlookup somehow, but that doesn't sound like th
solution.
Could I do this at the access database level with the right query? ca
that work from one access table to another?
No idea how to do this, any help really appreciated
Regards,
K