I have two worksheets that I'm working with. The first, "Raw_Data", contains the data and ranges that I need for a formula used in the second worksheet, "Cover Page". The following code successfully retrieves the range based on column header:
The problem I'm having is that I'm using the variable csCol (along with other variables not listed in the sample code) in the formula =countifs(csCol,"Open",lvl2Col,"International") that populates on the worksheet "Cover Page". Because the range does not include the "Raw_Data" worksheet name, the countifs formula does not work.Please Login or Register to view this content.
So, I need assistance to include the worksheet name in the range address. Thanks in advance.
Bookmarks