Good day all - I'm wondering if it is possible to find a cell based on a row header (Column A), and then a sub-row header (Column B).
Column A lists a company's name, grouped in twelves because Column B lists the 12 months of the year (so Company ACME is A:1-A-12, Company XYZ, A:13-A:24, and so on)). With VBA, is it possible, for example, to find the cell in Column E, where Column A = ACME Company and Column B = March?
Ultimately, I'd like to write a sub that automatically pastes data from another sheet to these cells if this is possible.
Thank you for the time.
Bookmarks