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

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...