I have a data sheet with many entries. In column "E" I have the station name entered. In other columns I have a timestamp, username, and dollars and tickets they are issued (we are selling tickets).
I want my user, on a separate sheet, to be able to select a station name and have a report...
My first worksheet is labeled Spirs 1 and the folowing sheets are labeled A CO, B CO, C CO, D CO, and HHC, all in the same workbook. I want to add the data from B2 on the worksheets and display the results in Spirs 1, B2. I have done all I know and every time I think I have it right it opens up...
Hi Guys,
Hope you can help me out with a problem I am having, still fairly new to VBA!
I have a User form with a ComboBox "SKUNumberComboBox" which has a list of SKU Numbers and I have a Date Picker "DTPicker1" were I can pick a date and I also have a TextBox "ExtraDaysTextBox" were I enter...
Hi
I was wondering if someone could show me how to simplify this code?
I use Excel 2007
I would like to clear the contents of these named cells.
They all share a common prefix.
The code below works, but I have 20 name cells to clear and it would be really messy to type the lot out.
Sub...
Hi,
I am using Excel 2003. I have a coworker (we are all networked) who is using Excel and when she tries to select a cell with her mouse, its selecting four at a time. She only wants one cell.
When I had her try to move around using the arrow keys, not a problem. But try to choose a cell...
Recent issue with Excel, in Windows 7 on an HP laptop purchased late 2011 (so it is compatible with and has appropriate resources to operate Windows 7. Excel, will somewhat randomly, indicate that the Control key is being help down, and function as if you are holding down the Control key (E.g...
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.