dynamic variable

  1. M

    dynamic formula using date range of TODAY and Today+90

    I am looking to SUMIFS the costs in Column I when the values in Column H are ,<=TODAY() and >=TODAY()+90, and value in column M is "DTB" (with DTB to be able to change based on the individual members of team). I also do not want to have to keep going back and changing cell range to include all...
  2. B

    Quick help needed: variable within a variable...

    Hi Guys! I would like to declare a variable that uses a value from another variable. (is this known as dynamic variables?) The offending line is: Wbq = ThisWorkbook.Sheets("Sheet 1").Cells(NumEntry, 2).Value where NumEntry is the variable within another variable, Wbq. It looks like this...

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