data sorting and manipulating in Excel
Budget: €30 – €250 EUR
I would need some help to sort out data in excel
Its Urgent and hopefully it would be nice if it could be ready by midday CET Tomorrow Monday
Data is found in two text files
A) Text based files sorted in columns, containing stock movements. 1150 rowsB) Products with variable value in text file
B) CSV text file with 166 rows and the following columns (Artikel,Benämning,Antal i lager,Enhet,Snittkost/st SEK,Värde)
Mission is to combine the two files into one excel file with Sheet A and Sheet B (and also Sheet C and Sheet D)
minor complications: 1) Sheet A only contains product names not the sku while file file B contains both but automatic mapping may probably not be done because its very important its the correct sku and only the sku used in the resulting file.2) Out/In and amount is only noted as "Inleverans av 1" = 1 pcs and "Utleverans av 2" = -2pcs . Also here no errors are acceptable
What is to be done is :
Each row in sheet A is taken from file A and are noted on with the following
ver nr(N xxx found in file A) ; Date ; Amount ; sku ; Value(fetched from sheetB) ; Debit(calculate if positive amount its Amount*Value) ; Kredit(calculate if negative amount its Amount*Value); Debit from file A ; Kredit from file A
Last row none; none ; None; none; none ; Debit sum ; Kredit sum
In Sheet B we have the following data from file B (file B is commaseparated) we findArtikel,Benämning,Antal i lager,Enhet,Snittkost/st SEK,Värde
But in Sheet B we only use the list of "Artikel (which is another word for sku)" with Values("snittkost/st") this last "values" should have the a column next to it with the initial value showing
Remember Sheet A will fetch the editable "Value"
The we have Sheet C which would contain a copy of File B in total
Sheet D will calculate and display final end sum of each skuInitial amount in stock found in sheet C then minus and plus all the movements per product found in sheet A
Sheet D has an almost identical layout as sheet C but it is the result of start values in C and then added and subtracted all the movements in sheet A
Its Urgent and hopefully it would be nice if it could be ready by midday CET Tomorrow Monday
Data is found in two text files
A) Text based files sorted in columns, containing stock movements. 1150 rowsB) Products with variable value in text file
B) CSV text file with 166 rows and the following columns (Artikel,Benämning,Antal i lager,Enhet,Snittkost/st SEK,Värde)
Mission is to combine the two files into one excel file with Sheet A and Sheet B (and also Sheet C and Sheet D)
minor complications: 1) Sheet A only contains product names not the sku while file file B contains both but automatic mapping may probably not be done because its very important its the correct sku and only the sku used in the resulting file.2) Out/In and amount is only noted as "Inleverans av 1" = 1 pcs and "Utleverans av 2" = -2pcs . Also here no errors are acceptable
What is to be done is :
Each row in sheet A is taken from file A and are noted on with the following
ver nr(N xxx found in file A) ; Date ; Amount ; sku ; Value(fetched from sheetB) ; Debit(calculate if positive amount its Amount*Value) ; Kredit(calculate if negative amount its Amount*Value); Debit from file A ; Kredit from file A
Last row none; none ; None; none; none ; Debit sum ; Kredit sum
In Sheet B we have the following data from file B (file B is commaseparated) we findArtikel,Benämning,Antal i lager,Enhet,Snittkost/st SEK,Värde
But in Sheet B we only use the list of "Artikel (which is another word for sku)" with Values("snittkost/st") this last "values" should have the a column next to it with the initial value showing
Remember Sheet A will fetch the editable "Value"
The we have Sheet C which would contain a copy of File B in total
Sheet D will calculate and display final end sum of each skuInitial amount in stock found in sheet C then minus and plus all the movements per product found in sheet A
Sheet D has an almost identical layout as sheet C but it is the result of start values in C and then added and subtracted all the movements in sheet A