extracting and sorting

  1. A

    Extracting Specific Info from cells and making a new sheet/chart using VB

    Hi all, Here's the information I'm using in Excel 2010: edit: the first upgrade2 should read upgrade 1 I need/want to look for the year (2015-2050), and extract the relevant information to each year on a separate sheet or chart, so that each year has all of its information in one place, or...
  2. J

    Extracting data onto summary page and sorting by expiry date

    Hello out there, I have two sheets. The first sheet is list of all tenants in a portfolio of a hundred properties (thousands of tenants). Each line has Name of Property (column A), tenant name (B), square footage of tenant (C), rent and expiry date (D). The second sheet is a summary page that...
    • jiggaman84
    • Thread
    • extracting and sorting extracting data no filtering no pivot tables sorting by date
    • Replies: 1
    • Forum: Excel Questions

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