Microsoft Office Questions? Ask a IT Expert for Support ASAP
Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question
is this all to be done in excel?
Yes, this would all be done in excel. I can send you sample files to give you an idea of what I am looking for in terms of functionality if that would help. Basically, one file would be the master and would have two columns, one with ASIN identifiers and one with the associated UPC code. Then I would have a second file that would have multiple columns of various bits of data including ASINs and an empty UPC column. I want to push a button (macro?) and initiate a query that would populate the empty column with the appropriate UPC code.
sure I can do this
it would be best to get the sample files
do you have a paperclip icon at the top of your chat window?
my responses are not going through
do you see what I am typing?
ok, I am not getting your responses
we seam to have lost chat connection
Here are the sample files.
I can't attach files, only pictures. What is the way around this?
what is the file extension
you can attach
i have the first one
is there another file?
i have the first file
Here is the other file
No, sorry, here is the other
The UPC-ASIN master list would be updated by me regularly so it will change. Does that impact which option would work? And keep in mind it will be 60,000 or more queries time I run the matching process.
Ok, I guess do it with a formula and directions on how to us, send me the file and I will populate with the full 60K plus of UPC codes and run a full query and if it all goes as it should we can conclude. Also, I notice that the codes in the yellow code are missing the 0's in front. Can this be fixed?
OK, give me a few hours. I am getting a big mailing out the door. Then will play around with and make sure it works fully.
Sorry, I had to get through my work day, then time with family, then bed, then up early to get to an airport to get on a flight. I am in route now and looking at it. Looks like the ASIN UPC master file that is linked to the file that you sent me is missing. I take it I can just create my own look up directory and link in the edit function, yes?
I have updated the link to a xls file with ASIN and UPC header files. I am unclear on how to initiate the query process so that the empty column in the JA MOD file. i tried closing and saving the JA MOD file and then re opening it but nothing happens.
That was my expectation but it appears not to be doing anything. I have opened both files made sure that the file with resource file (with ASIN and UPC columns complete with 60,000+ entries is linked to the JA MOD file via edit links. I have tried the "check status" button in the edit links window. That changes the status from "unknown" to "source is open" but still nothing happens and the empty column does not populate. I tried removing and readding the link to the resource file and still nothing happens. What next?
no idea where the formula is, how to copy it and where to copy it to. that was not discussed. i am a bit frustrated by this now. Can you please do this as a macro instead? Macros have execute buttons.
Set up as one macro enable excel file with two tabs. First tab will be for the ASIN UPC library and second tab will be where I load in the various columns of data with black UPC column at end. Then I can just push the macro button to initiate the process of getting the corresponding UPC code for each ASIN on the second sheet.
All of your replies have gone through. Please keep in mind, I was traveling all weekend, doing some work from the air, but did not have space to work on the computer on the flight home last night and did not get home til after 9pm then had to spend some time with my family, get a bite to eat and go to bed early so I could be up this morning working at 7am.
Attached are two screen grabs of the the tabs in the macro enable excel file that show how I would like this set up. Just Answers is now not allowing the transfer of any non image files.
Here is the problem. That library will constantly change with new UPCs added and others removed, so I need a process that works regardless of the number of UPC/ASINs on the library page.
Yes, definitely. That is what I was planning.
http://wikisend.com/download/916308/UPC LOOK UP MACRO.xlsm
It works! Strangely it take 95% of system resources over about a 10 minute period to populate the UPCs but it does work. Not sure why it saps so much computing power (I have 8 gigs of ram and a 1.6 ghz processor) but it does. Any thoughts on that? Regardless, I will complete the transaction so you can get paid. Appreciate your help!
I am running it on an Intel Core i5-4200U 1.6 ghz with turbo boost up to 2.6 ghz.
Most definitely I expect it to take longer with a 59K row query, but it took about 10+ minutes and almost all my system resources which was a surprise. I have a couple of computers that I don't use much so I think I will just farm this function out to them if needed but will try your revised version and report back. Regardless, I am happy with you work. I don't see how to conclude the matter so you get paid or is that already done? It has been a while since I used Just Answers.