dyanmic range

  1. S

    Find next date in series

    I have a data set that could be used for a pivot table. I need to be able to know what the current rotation is. The number of employees and length of time of each rotation is different. For example today = 12/18/16 The three rotation dates are: 11/1/16 1/9/17 3/6/17 Since today is > 11/1 but...
  2. A

    VBA- Refer to a dynamic named range

    Hi All, I currently have a dynamic named range that i created using the Name Manager in excel. My question is, can i refer to that named range in VBA for a macro i'm creating? And if so, how do i do that? If i am not able to use the named range, how do i create a dynamic range in VBA then...
  3. L

    Dynamic Chart of fixed number on one axis

    I am trying to make a dashboard. I need a chart that on the x-axis maintains a fixed number of values like 20. Let me explain. The source data will be a table in another separate spreadsheet_1 file. What I am trying to do is have only the last 20 values get charted on spreadsheet_2. For...
  4. M

    VBA creating dynamic sort list

    Hi, I have read a lot on this topic, but I am still stumped. What I need is a dynamic range for both columns and rows (I.e. the number of columns and number of rows will change). The entire selection will need to be sorted by the last column with data. Below is the VBA code I get from the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top