Automate Excel Data Retrieval
Budget: ₹100 – ₹400 INR
I keep a simple list of up to ten product codes in Sheet1. Sheet2 already holds every purchase record for those products—description, vendor name, PO number, PO date and unit price. Each time I drop a fresh list of product codes into Sheet1 I want every matching row from Sheet2 to appear automatically beside it, without any manual filters, copy-pasting or one-by-one look-ups.
All data columns from Sheet2 must be returned exactly as they are, and I don’t need totals or summaries—just the raw rows that belong to the products I enter. The solution can be a dynamic array formula set-up (FILTER, XLOOKUP, INDEX/MATCH), Power Query, or a lightweight VBA routine; whatever is fastest and most reliable inside Excel.
Deliverable: the workbook (or template) with the automated pull already wired up and a short note showing where to paste my product list so everything refreshes instantly.
All data columns from Sheet2 must be returned exactly as they are, and I don’t need totals or summaries—just the raw rows that belong to the products I enter. The solution can be a dynamic array formula set-up (FILTER, XLOOKUP, INDEX/MATCH), Power Query, or a lightweight VBA routine; whatever is fastest and most reliable inside Excel.
Deliverable: the workbook (or template) with the automated pull already wired up and a short note showing where to paste my product list so everything refreshes instantly.