select data

  1. S

    Row select not selecting all data

    I'm using a row counter to select all data in a column, but it's dropping a number of rows at the end. When I run the below macro, it returns the correct number: Sub Count_Rows() Range("b4").Select lastrow = ActiveCell.CurrentRegion.Rows.Count MsgBox (lastrow) End Sub However, when I run...
  2. D

    Conditional Chart Data Range

    Hey guys, I have a workbook that charts data for various dates. I want the chart (called "Chart 6") to display different ranges of data as the years go on. When I select my chart and go to Select Data, then the Select Data Source window pops up. Currently, the chart is displaying data from the...
  3. R

    Select data based on cell value

    Hi All, I have an excel workbook with 2 sheets named "Info" and the other "Newcastle". Info sheet consists of 100's of rows of data, see below: <colgroup><col><col><col><col><col></colgroup><tbody> PartNumber QTA B3_Free B3_Locn Branch BC2020 2 0 0 Birmingham_Branch BC2051R 1 43...
    • rovert
    • Thread
    • birmingham_branch data newcastle_branch select data sheet
    • Replies: 3
    • Forum: Excel Questions
  4. M

    Copy 2 columns of data from a text file using criteria for listbox

    Hi all I have had a try with this and it's beaten me too. i'm trying to display 2 columns from a text file. Row 1 are headings and the environ$"username" will be the column name I wish to use and contains annual leave type data going down. And i would like to display column 1 which will have...
  5. J

    How to select specific data from workbook based on value

    HI Everyone, I need to select the past 12 months of data from the H column in a workbook. A new row of data gets added every month. I need code that recognizes the most recent input and also selects the first 11 cells above containing data. Thanks for any help
  6. J

    Combo Box question?

    I have a combo box with a Row Source of =(J3:J6). J3:J6 contains the names I want the user to see and use as there selection however would like the combo box to use K3:K6 as the actual data. I'm using this combo box on a form. Thanks..

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