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.
Highlighted

@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
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies