Hi all,
Sorry for my English - it is not my mother tongue.
My question is maybe rather simple, but it is challenging me and driving me crazy when trying it for over a week now:
What I aim for:
In 'Tab 1' I have all kind of information:
Object No. - Price - Costs - Inventory
1 - 30 - 10 - 5
2 - 40 - 20 - 6
3 - 50 - 30 - 7
4 - 60 - 40 - 8
5 - 70 - 50 - 9
In 'Tab 2' I would like to make a sheet that does the following:
When I enter in cell A1 the object number (e.g.: 1).
I want to see in a few other cells (e.g. B2, C3, D4) the other information to appear (thus: B2 is Price says 30; C3 is Costs says 10; D4 is Inventory says 5).
When changing the object number in cell A1 from '1' to '3', the information in B2, C3 and D4 needs to be changed subsequently according the object no. information in Tab 1.
Thus: When '5' in Tab 2 cell A1 - then look for '5' in Tab 1 column 1 (Object No.), refresh in 'Tab 2' the price, the costs and inventory.
Do you have any idea how to proceed?
Best and cheers,
Kirsten
Bookmarks