selecting data

  1. S

    Filters/Drop down on sales data with multiple selections

    I want to be able to select all of these options on a cover sheet which i have created with data validation so that when a combination of these 8 elements are selected it spits out the data i need: <tbody> Date Total Market All Major Categories All Brands All Categories All...
  2. A

    Selecting data based on some conditons

    Hi, i have this data A B 0.4 0.2 0.5 0.7 0.84 0.61 0.92 0.23 and so on Now i want to select and separate data based on following two conditions (to be done one by one) 1. A>0.80 when B>0.60 2. A<0.90 when B<0.20 How to do these two
  3. already

    macro selecting data in a row with empty cells

    Hi, I have to select and cut a column with on several lines empty cells. I use the following code 'Range("c2", Range("c2").End(xlDown)).Cut' but this code select only the data till the first empty cell. How can I select the whole column till the last cell. The column B is filled with data on...
  4. K

    Macro to subsetting tables

    <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:HyphenationZone>21</w:HyphenationZone> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>...
  5. D

    Selecting Data

    Hello, I have a Spreadsheet where: Column B = Project Number Column C = Project Title Column D = Workstage Column E = Workstage Description I have code that will sort what can appear in workstage(D) depending on whats selected in Column A. this is done using the active cell at the time...

This Week's Hot Topics

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
Top