Results 1 to 7 of 7

Possible to find a cell based on a row header (col A) then a sub-row header (col B)

Threaded View

  1. #1
    Registered User
    Join Date
    12-10-2011
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    10

    Possible to find a cell based on a row header (col A) then a sub-row header (col B)

    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.
    Last edited by lifeboat; 12-14-2011 at 09:04 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1