dynamic name range

How can I name a range which changes. Range is 2-dimensional. Last row and column are as shown. I used something like this in the past for a single column. =Sheet1!$G$1:INDEX(Sheet1!$G:$G,COUNTA(Sheet1!$G:$G))

Hi Everyone, I would be glad if you can help me regarding this please. I have an Excel sheet in which I have a graph which uses dynamic name range. The dynamic name range is, Trial=INDEX(Sheet1!$C:$C,MATCH(Sheet1!$G$3,Sheet1!$B:$B,0)):INDEX(Sheet1!$C:$C,MATCH(Sheet1!$G$4,Sheet1!$B:$B,0))...

HI, Newbie to excel here. I am trying to use code to take a named range on an invoice and add it to a database in a separate sheet. The code I am using is below but need it to not pull any blank cells that contain functions in them. Code I was previously told to use but has an error...

Good afternoonall, First off, apologies in advance for the long post and maybe long windedexplanation. I have asummary which was created using a combination of SUMPRODUCT, MATCH & ROWfunctions with the good help of Marcelo Branco - This works fine and theresults are as expected. However, I...

Hi All, Is there a formula that if the last cell in a range is A6545, that it can return 6545 as a value in another cell. Secondly, if that is possible, can I link that cell value, which in the above example would be 6545 to a named range. So, the range always starts from A1 and ends in A...

Hi, I have created a spreadsheet in excel. It will contain the following columns: Date Performed Employee # Last Name First Name Temp Y/N Dept # Dept Name Position I would like to eventually convert this spreadsheet to a table, but for now it is...

I will try to explain. First to let everyone know, I search the WEB for an answer and nothing seems close. I have a SHEET. First couple of columns is data on Left side and right side is drop downs to drive different answers. It is working but each day I get different data and would like to...

Hi, i am working on a user defined function. The function has 2 tasks: 1st to identify the name range out of 21 name ranges basis user input (user input 1) and use it in set range = variable (this is where i need help) I think here directly referring to the range name also will need indirect...