EasyLifeWithExcel
New Member
- Joined
- Feb 17, 2018
- Messages
- 1
Hei, Im just begin to work with Excel and my english is limited so sorry if this question is answered many times.
I have problem how to update prices. Every year I got price list in excel format with 30 000 lines . I used search and copied data in structure I need but on separate spread sheet . I use only about 3000 lines and in totaly different structure, but line structure is the same:
ID : PRODUCT NAME : PRODUCT DESCRIPTION : UNIT TYPE : AMOU T UNIT : UNIT PRICE : TOTAL PRICE
So I spend months to copy manualy and made structure . How I can update this file UNIT PRICE from another excel file matching ID or PRODUCT NAME ??
I have problem how to update prices. Every year I got price list in excel format with 30 000 lines . I used search and copied data in structure I need but on separate spread sheet . I use only about 3000 lines and in totaly different structure, but line structure is the same:
ID : PRODUCT NAME : PRODUCT DESCRIPTION : UNIT TYPE : AMOU T UNIT : UNIT PRICE : TOTAL PRICE
So I spend months to copy manualy and made structure . How I can update this file UNIT PRICE from another excel file matching ID or PRODUCT NAME ??
