dynamic ranges and sheets

  1. G

    Subtracting Dynamic Ranges

    Hi, I am currently working on a VBA code for share analysis and I have found a very useful spreadsheet that takes stock data from yahoo finance based on your ticker list and start and end dates that you set. When you click 'get bulk quotes' command it retrieves date, open, high, low, close...
  2. C

    Excel Help - Setting Dynamic Ranges

    Hello, Is it possible to set dynamic ranges? What I want to do is paste raw data, and be able to search within it. However, I want to separate the raw data into its own unique range, so that each search does not cross over into the next range. The data pasted is dynamic and therefore the...
  3. C

    copy and pasting dynamic ranges from dynamic number of worksheets

    Hi All, I am trying to copy 4 columns A, D, E, Z with dynamic ranges (I the last row number varies by sheet) of all the sheets in a workbook ( the number of sheets in the workbook also varies) into a new sheet in the same workbook. The copied information needs to be stacked (on top of each...

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