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...

Some videos you may like

This Week's Hot Topics