Calculate Summary dynamic name range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Name range like following

MyName
OFFSET($B$12,0,0, COUNTA($B$12:$B$65000), SHEETS("MYSHEETS").RANGE($D$12))


Because the name range is changed base on ($B$12:$B$65000),
SHEETS("MYSHEETS").RANGE($D$12) values.

I need calculate the summary like average, total per row and per column.

Are there any way to access dynamic range relative cells?

Like MyName.cells(1,1) can reference cell "MYSHEET"!$B$12.

Thanks millions for any information,
 
Thanks for the information,
Since the name range is dynamic, are there any way to calculate the total
and average of one row or column.

Thanks again,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

InputBox to name a range 2
Named Range maker code 9
Slow Macro 7
Dynamic Name Range using VBA 1
Copy and paste Named Ranges 6
Generate Subtotal Summary from Sheet1 into Sheet2 16
Macro for Multiple Worksheets 6
Copying same data range to a summary sheet 8

Back
Top