How to pick data from cells?

oscarlimerick · #1 10-26-2025, 03:22 PM

Good day learned folks of the microsoft forum, I have attached a spreadsheet that contains 4 tabs. I have most of it figured out except I want to create some data on the sales report tab but I need to have excel search the product list to determine how many units of each product were sold, and then populate that number into the qty sold (column B) field of my sales report tab. I know I can do this manually but I was hoping there's some way to have the excel do this for me. Any ideas? Many thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Filling in cells based on 2 other cells data	Dawindle	Excel	4	11-10-2018 07:40 AM
How do I use date pick from website	gummybear	Excel Programming	4	04-24-2018 02:48 AM
Mail merge doesn't pick up the inserted content after repeated data of last record	d3w	Mail Merge	2	01-18-2018 03:46 PM
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1	bobznkazoo	Excel	2	03-27-2014 11:14 AM
Pick up data from Word documenta	jmarin	Excel	1	12-05-2008 02:31 AM