Forum Discussion
Need help autofilling.
Good morning all,
Thought I posted this but I am not seeing it anywhere so I apologize if this is a repeat.
I was tasked with filling in a spreadsheet with data including; Our part number, our description, supplier name, supplier number assigned by us, and supplier part number.
I noticed that a lot of the part numbers repeat so I am trying to find a way so that when the column with our part number repeats it will auto fill the columns with
the supplier name, supplier number and supplier part number automatically when I enter a repeating part number if possible. I am very much not excel savvy but I am pretty computer literate.
I have attached the document I am working on, there is no customer data what so ever and all part numbers are internal so are not proprietary.
https://gpcompinc-my.sharepoint.com/:x:/g/personal/zachv_gpcompanies_com/IQCj4grl62sHQYohshZJ9Mb2AX7_MknXYW1QiMk8wv2sdfQ?e=duyOxL
That is perfect,
Thank you for your help!
3 Replies
I use Microsoft® Excel® for Microsoft 365 MSO (Version 2603 Build 16.0.19822.20012) 64-bit. I am entering a large amount of personal addresses into EXCEL. The EXCEL autofill (I think that is the correct term) is not working for me as it has done for me in the past.
Many of the entries I am making are to enter “Boston” into a column I have named “Address City.” Normally, when I have done this in EXCEL, after I enter “Boston” as the “Address City” for George Washington and Thomas Jefferson, if I try to enter “Boston” as the Address City for Franklin Roosevelt, I just type “B” and EXCEL with automatically fill the cell with “Boston.” Unfortunately, EXCEL is not doing that for me now. I have to type out the whole word “Boston” into each cell where I want “Boston” to appear. I will be entering hundreds of rows. I would like to get EXCEL to use “autofill” as it has for me in the past.
I have checked the two boxes in EXCEL Options/Advanced: 1. Enable fill handle and cell drag-and drop AND 2. Alert before overwriting cells. I would appreciate suggestions to help me get this good EXCEL function working for me again. Thank you for your attention.
I created a lookup table (called PartNumbers) from the available information in your sheet containing all details for each unique part number. Then used XLOOKUP to retrieve the supplier name, supplier number and supplier part number from that PartNumbers table. Many part numbers have no (or incomplete details). That you'll need to fix yourself (if needed).
See attached.
That is perfect,
Thank you for your help!
