Hi Guys I need some help with following situation,
I got this list from a Excel Data and need to do following.
Column A, B, C, H & I, is data relavant to the "Product"
Column D:G is relavant to the "Prices" "PreisNational" or PreisPartner are in the picture not but can vary from different "PriceLists"
Now I like to update that data so I get a ID number in Column "A" so add new column to the table in Column A so it is unique to each "Material" then I need to create two new lists.
One list ID; Material; Materialkurztext; Gruppe; Materialstatus; Vertriebstatus;
Another list with ID; Preis; Preisliste;
On the second list I need to get all data for each Preislist below eachother
So every List gets its ID number and all the relavant Data below each other when done then go to the next "Preislist" so the next column and add it below the secont list,
I would need that so I can then transfer the Data easily to Access
Hope I did explain it good enough?
Could someone please help me with this.
Many thanks in advance!!