Home

Autofilling adjacent data into specific cells HELP

%3CLINGO-SUB%20id%3D%22lingo-sub-808753%22%20slang%3D%22en-US%22%3EAutofilling%20adjacent%20data%20into%20specific%20cells%20HELP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-808753%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20guys!%20I%20have%20a%20monthly%20usage%20report%20I%20run%20through%20excel.%20I%20create%20this%20by%20exporting%202%20different%20reports%20from%20quickbooks.%20an%20inventory%20report%20and%20a%20sales%20report.%20I%20have%20to%20combine%20these%20reports%20to%20make%20the%20usage%20report.%20We%20have%20thousands%20of%20items%20so%20this%20gets%20very%20tedious.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20a%20basic%20sample%20of%20what%20I%20am%20dealing%20with.%20I%20was%20wondering%20if%20there%20would%20be%20a%20way%20for%20cell%20d3%20to%20autofill%20with%20the%20data%20from%20j3.%20It%20sounds%20super%20easy%2C%20however%20i%20need%20it%20to%20be%20based%20of%20the%20item%20name.%20For%20Example%3A%20If%20cell%20A3%20displays%20the%20same%20item%20as%20any%20of%20the%20cells%20I3-I6%2C%20then%20display%20the%20corresponding%20value%20(J3-J6)%20into%20cell%20D3.%20The%20same%20would%20need%20to%20be%20done%20for%20Quarter2%20when%20working%20with%20columns%20E%2CL%2C%20and%20M.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20biggest%20issue%20is%20when%20I%20pull%20an%20sales%20report%20(Columns%20I%2C%20J)%2C%20if%20item%20b%20was%20not%20sold%20during%20that%20period%20of%20time%2C%20it%20will%20not%20appear%20on%20the%20report.%20This%20means%20that%20column%20A%20and%20I%20will%20never%20match.%20Quickbooks%20inventory%20reporting%20is%20not%20very%20good....%20So%20I%20need%20excel%20to%20search%20column%20I%20to%20find%20the%20value%20displayed%20in%20column%20A%20and%20put%20the%20corresponding%20value%20(column%20J)%20into%20the%20corresponding%20quarter%20(column%20D).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20that%20make%20sense%3F%20Any%20ideas%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20945px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127275iF711E46313039639%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Quickbooks%20Question.PNG%22%20title%3D%22Quickbooks%20Question.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-808753%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
ztlokey
Occasional Visitor

Hey guys! I have a monthly usage report I run through excel. I create this by exporting 2 different reports from quickbooks. an inventory report and a sales report. I have to combine these reports to make the usage report. We have thousands of items so this gets very tedious.

 

 

I have attached a basic sample of what I am dealing with. I was wondering if there would be a way for cell d3 to autofill with the data from j3. It sounds super easy, however i need it to be based of the item name. For Example: If cell A3 displays the same item as any of the cells I3-I6, then display the corresponding value (J3-J6) into cell D3. The same would need to be done for Quarter2 when working with columns E,L, and M. 

 

The biggest issue is when I pull an sales report (Columns I, J), if item b was not sold during that period of time, it will not appear on the report. This means that column A and I will never match. Quickbooks inventory reporting is not very good.... So I need excel to search column I to find the value displayed in column A and put the corresponding value (column J) into the corresponding quarter (column D).

 

Does that make sense? Any ideas?

Quickbooks Question.PNG

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies