View Full Version : Excel Questions
- Assigning the cell link to a dropdown menu using a macro
- Copy Files & Directories from server
- Help with Links in a macro!
- Insert Single Row
- Averaging Formula
- Dynamic Pick List
- Loading a combo box
- creating functions
- dates
- More Mode
- Display Out worksheets in the form
- Assigned macros become 'corrupted'
- Switch between userform and spreadsheet
- Creating a conditional formula
- Sorting
- Word/Excel question
- importing selected data from 3 html tables
- Timer for timed exams (more than a simple countdown timer)
- Select case between
- Vlookup with duplicates
- Mass Replacement
- Watch out for that DAYS360() formula
- Counting the number of days...
- Conditional Formulas for 2nd and 3rd highest value in range
- Verifiying linked files using VBA
- YTD totals using multiple criteria
- How do I express these formulas
- Formula???
- find a row, delete a row and shift up
- I am using macros for too much?
- neat and tidy sheet ?
- Usine two Countif's
- Date search
- sorry
- Pivot Question
- sort by color
- Sheet Protection
- Activecell reference
- Make Excel Cells read-only
- saving in csv
- Create Bowling Triangle with Radio Buttons
- Controls come to front when clicked
- check double entries per column in vba
- MoreFunc error
- Creating 500 worksheets
- Comparing 2 Workbooks - matching data from Source to Output
- Issue of MultiSelect of FileDialog
- click and move
- Links - spreadsheet links2another SS - but it doesn't
- Urgent VBA help
- Extra commas in csv
- Help To Correct Code
- Open, Read and Close an Excel Workbook
- sumproduct and using OR
- vlookup error
- Combo Box Link
- Pivot table truncates text data fields to 255 characters
- Date from weeknum + weekday
- Extract file list with Date Modified
- Cell formatting
- Printing several Worksheets
- Subscript out of range
- View linked picture in Irfan viewer
- Active Range grabbing, how???
- another conditional formatting question
- Changing Values in One column, Changes Values in Next Column
- hoiw to save CSV as XML?
- X In Message Box
- Un-protecting sheets?
- Multiplying Columns
- lookup formula help needed
- auto adjust security setting for shared macro
- Help with some VB code -please!!
- Remove Duplicate Entries
- AddIns - detecting how Excel opened?
- Getting a macro to search and change values
- Date Sorting
- Filling in blank cells with condition
- Help with variable declaration
- Copy Label to Cilipboard
- Wildcards in sumproducts???
- after using if formula, have problem with sum
- Making an "L" into a value (.5), then add/subtract
- Formula help
- Comparing workbook names
- Easy way to print several sheets?
- Need a difficult formula
- Help with pick from list
- Intersect, not intersect, etc....
- Need a difficult formula
- Search and replace Macro
- Two types of conditional formatting
- winning amount
- Populating combo/list boxes
- Help on my excel order form.
- Solver Constraint Issues
- Please help with a formula
- Pasting format and content of one cell onto a range of cells
- Can I reference a cell to a worksheet title?
- VBA Query
- How to remove memory when vba code ends
- protecting
- Workbook not Opening?
- Help on Excel Average Formula
- Visual Basic translation
- finding a value in a range.....
- Data validation on entry
- countif not counting properly, help
- Add a year to a date
- how do i only run the formula if a certain cell is blank
- Pasting problems
- Conditional Formating for an Entire Row
- data - filter selecting, copy pasting etc
- Spread $ Monthly Across Date Ranges
- More Countif Help
- Using a list of defined names in a formula
- SUMIF Formula does not Expand correctly to adjacent cells
- General Question...
- Excel 2003 Values wont Paste
- Using the SetSourceData method without Activating the Chart?
- Updating with dates and Data Validation..
- Excel Mail Merge and attachments
- vlookup is fun
- nested vlookup
- Input Mask with a form
- offsetting data points in line charts
- How to make sure this macro is executed?
- VLOOKUP & HLOOKUP IN SAME FORMULA
- Tab Order?
- Command Button
- PC file won't work on Mac
- Trim between Parenthesis
- Macro, Value from a different workbook
- Running a Macro on Specific Worksheets Only
- Can I get a pivot table to select the CurrentRegion?
- custom formatting cells
- Redefine Vertical Scrollers
- Userform Mismatch error
- VLOOKUP for matching fields
- Alternative to FInd/Replace
- cell color change from default
- countif #value error
- Complicated IF()
- easy one
- Importing a csv text file
- Protect fill and line formating?
- Determining which object launched macro
- Splitting a Single Cell into many
- update functions
- Simple (But urgent!) question
- Age Years Months
- Hyperlinking to a specific Cell in Excel
- Found a cool trick!!!
- Pulling Info from Excel into a UserForm
- VB to find dates
- Clear cell contents
- Cell Value = to Sheet Name?
- Creating code to count the matching records in each column
- Locking rows
- Present value of $$ function?
- cutting the end of the string off
- Dynamic Hyperlinks i.e. a formula in the location feild
- Hide Rows using conditional/Macro w XL2000
- Remove #DIV/0! error from cell
- Insert a row with formulas
- Calculate Percentage Help
- Getting macro to work with Excel 2003 PivotTable
- Concatenating text with a function
- Adding Character to Existing Data
- Forbid Range Macro Problem
- If/Then/Else macro needed?
- Sort by color
- Making the results of a function a reference
- Combobox Problem
- Conditional Format Formula
- multiple worksheets to new workbook
- time stamp help
- Adding code to already installed add-in, copying to XLSTART
- Quesiton Box Code
- "average" question
- Delete Non-Numeric Rows
- Converting a formula
- Excel Questions
- Save File into Array
- sumproduct with multiple conditions
- Area under a curve
- Need to write macro that presses the command buttons. HELP??
- Comment
- 2 in 1 'SaveAs' issues using Cell values & 'Replace' cod
- parse cell (numbers vs Letters)
- Can I change an entire workbook to Lowercase ?
- Data vaildation
- Macro to help with GPS Data
- How do I make a...
- linking excel file to csv file.
- Automatic Deletion of Charts
- Simple (??) Copy/paste??
- Msg box dependent on cell value
- Sort Labels
- extracting/hilighting duplicate information...
- need help on delivery calendar PLEASE HELP
- going in circles
- creating worksheets
- Help Please
- Building a schedule...
- formula help
- Rank with multi records
- Creating a formula using two different worksheets
- Moving Information Between Worksheets
- Workbook Name that changes
- Need help with conditional formula
- converting lastname, firstname to
- =IF Formula Help
- Numbers right of decimal
- Mystery error while doing vlookup
- Custom Button Face ID's when coding Buttons
- removing rows that have a blank column B only
- array
- VBA - Testing process that presses buttons automatically???
- Calculating number of days in a year between 2 dates
- Change Value in Same Cell in All XLS Files in Folder C:\Test
- Macro to Hide Rows in XL2000
- Dollars $ and Cents ¢ How do I ?
- Runtime Error -1004 - Readonly File?
- DELETE UNNCESSARY ROWS
- Can anyone help?
- Reverse Hourly Salary
- Columns("B").Cells.SpecialCells(xlCellTypeConstant
- How to copy only the cells that have data
- Macro Question
- Hyperlink to chart ...
- Save Formula
- Autocomplete within a drop down list.
- Clear other cells in validation
- MRP schedule, formulas
- Problem posting code
- Posting a value in cell X based upon a list box choice
- PDF to Excel?
- Time formatting problem
- Lookup Formula?
- Cell Formula
- Using If / Then within a Macro
- Need modification on listbox to listbox
- Limiting the number of allowed characters in a field
- Tiered Discounts
- Fill down formula next to query table
- VBA macro query
- i don't want mixed data !
- Locking down a worksheet
- Index Matching Error
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.