Home

Help updating and comparing priclist

%3CLINGO-SUB%20id%3D%22lingo-sub-544147%22%20slang%3D%22en-US%22%3EHelp%20updating%20and%20comparing%20priclist%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-544147%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello%2C%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20was%20hoping%20someone%20here%20could%20help%20me%20out.%20I%20have%20looked%20on%20the%20web%2C%20but%20do%20not%20seem%20to%20know%20what%20I%20should%20exactly%20be%20looking%20for.%20So%20here%20goes%3A%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20have%20a%20pricelist%20with%20part%20numbers%20that%20I%20receive%20an%20update%20to%20quarterly.%20sometimes%20price%20will%20be%20updated%2C%20and%20sometimes%20new%20products%20are%20introduced%20in%20the%20new%20sheet.%20What%20I%20would%20like%20to%20be%20able%20to%20do%20is%20have%20the%20quarterly%20update%20the%20new%20pricing%20and%20possible%20put%20any%20new%20parts%20at%20the%20bottom%20of%20the%20list.%20the%20reason%20I%20would%20like%20to%20have%20anything%20new%20at%20the%20bottom%20of%20the%20list%2C%20is%20that%20way%20I%20wouldn't%20have%20to%20go%20through%20it%20line%20by%20line%20and%20match%20everything%20up%2C%20all%20the%20new%20parts%20would%20show%20at%20the%20bottom%20of%20the%20list%20where%20I%20can%20add%20them.%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EIs%20this%20possible%3F%20it%20seems%20like%20it%20would%20be%20relatively%20easy%2C%20but%20I%20just%20can't%20seem%20to%20search%20for%20the%20right%20information.%20%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EAny%20help%20would%20be%20greatly%20appreciated.%20%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-544147%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EComparing%20pricelist%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-545329%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20updating%20and%20comparing%20priclist%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-545329%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F337575%22%20target%3D%22_blank%22%3E%40Dmanic%3C%2FA%3E%26nbsp%3BI%20agree%20with%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20post%20a%20sample%20file.%20We%20only%20need%20a%20few%20dozen%20rows%2C%20NOT%20your%20whole%20data%20set.%20Just%20enough%20data%20so%20you%20can%20explain%20what%20happens%20right%20now%20and%20what%20you%20would%20like%20to%20happen%20instead.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-544770%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20updating%20and%20comparing%20priclist%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-544770%22%20slang%3D%22en-US%22%3EPlease%20attach%20your%20sample%20file.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-548941%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20updating%20and%20comparing%20priclist%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-548941%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20part%20of%20the%20original.%20I%20would%20like%20to%20add%20the%20updated%20pricing%20per%20part%20number%20and%20any%20new%20part%20numbers%20to%20the%20bottom%20of%20the%20list.%3C%2FP%3E%3CP%3EI%20will%20add%20the%20update%20partial%20to%20the%20second%20post.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-548946%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20updating%20and%20comparing%20priclist%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-548946%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20a%20partial%20list%20of%20price%20update%20and%20some%20new%20parts.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-550017%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20updating%20and%20comparing%20priclist%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-550017%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F337575%22%20target%3D%22_blank%22%3E%40Dmanic%3C%2FA%3E%26nbsp%3BThis%20is%20actually%20very%20far%20from%20%22relatively%20easy%22.%20This%20will%20most%20likely%20require%20VBA%20code.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EConceptually%2C%20the%20code%20would%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E-%20open%20the%20original%20file%20(which%2C%20btw%2C%20is%20a%20CSV%20file%2C%20not%20a%20spreadsheet%2C%20are%20you%20aware%20of%20that%3F)%3C%2FP%3E%0A%3CP%3E-%20open%20the%20update%20file%3C%2FP%3E%0A%3CP%3E-%20loop%20through%20all%20rows%20in%20the%20update%20file%20and%20for%20each%20row%3C%2FP%3E%0A%3CP%3E-%20find%20the%20Part%20number%20in%20the%20original%20file%20(in%20which%20column%3F%20There%20are%20two%20for%20part%20number%20in%20the%20original)%3C%2FP%3E%0A%3CP%3E-%20if%20the%20part%20number%20is%20found%2C%20write%20the%20NET.PRICE%20into%20the%20(which%20%3F%3F)%20price%20column%3C%2FP%3E%0A%3CP%3E-%20if%20the%20part%20number%20is%20not%20found%2C%20add%20the%20data%20from%20that%20row%20at%20the%20bottom%20of%20the%20original%20list.%3C%2FP%3E%0A%3CP%3E-%20close%20the%20update%20file%3C%2FP%3E%0A%3CP%3E-%20save%20and%20close%20the%20original%20file.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWriting%20that%20kind%20of%20code%20is%20totally%20possible%2C%20but%20it%20needs%20a%20bit%20of%20experience.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Dmanic
New Contributor

Hello,

I was hoping someone here could help me out. I have looked on the web, but do not seem to know what I should exactly be looking for. So here goes:

I have a pricelist with part numbers that I receive an update to quarterly. sometimes price will be updated, and sometimes new products are introduced in the new sheet. What I would like to be able to do is have the quarterly update the new pricing and possible put any new parts at the bottom of the list. the reason I would like to have anything new at the bottom of the list, is that way I wouldn't have to go through it line by line and match everything up, all the new parts would show at the bottom of the list where I can add them.
Is this possible? it seems like it would be relatively easy, but I just can't seem to search for the right information.

Any help would be greatly appreciated.

5 Replies
Please attach your sample file.

@Dmanic I agree with @Twifoo 

 

Please post a sample file. We only need a few dozen rows, NOT your whole data set. Just enough data so you can explain what happens right now and what you would like to happen instead.

 

@Ingeborg Hawighorst

 

Here is part of the original. I would like to add the updated pricing per part number and any new part numbers to the bottom of the list.

I will add the update partial to the second post.

 

Thank you,  

@Ingeborg Hawighorst 

 

Here is a partial list of price update and some new parts.

 

Thank you, 

@Dmanic This is actually very far from "relatively easy". This will most likely require VBA code.

 

Conceptually, the code would

 

- open the original file (which, btw, is a CSV file, not a spreadsheet, are you aware of that?)

- open the update file

- loop through all rows in the update file and for each row

- find the Part number in the original file (in which column? There are two for part number in the original)

- if the part number is found, write the NET.PRICE into the (which ??) price column

- if the part number is not found, add the data from that row at the bottom of the original list.

- close the update file

- save and close the original file.

 

Writing that kind of code is totally possible, but it needs a bit of experience.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
9 Replies