View Full Version : Excel Questions
- Changing Label Captions with VBA in Excel
- Sorting the content when using Data Validation
- Macros: Range & RoundUp
- Coutdown timer
- Days before and after a listed holiday
- Timer function
- VBA to clear cells in xl2003 and 2010
- Last Sunday of year
- named ranges
- Coloring a row of cells black
- Macro to paste unique formatting into word
- Edit a formula ONCE
- Currency to words conversion
- Selecting a range using VBA
- VBA: Use cell value as range
- comparing two sheets using match formula
- how do I search for the first space between words within vba
- Formula Help Please
- please HELP! Need to match up/lookup data in different columns in my spreadsheet!
- Suggestions needed for Excel Tips and Tricks Class
- VBA Copy Paste Special Slowing Code?
- Making change in Macro..
- Calculate Date for Wednesday of This Week (Solution!)
- Seperate Names
- Formula change because of 2007
- Find and Replace across a folder
- Formula to Find the First Blank Cell In a Column Across Multiple Sheets
- Is there code to convert Vcard to excel
- Merging or matching data
- Extracting Web Query Data
- Multiple cells are highlighted when clicking on one cell
- How to Pull Data from Two Spreadsheets?
- Restore Default Excel 2003 PivotTable Colors
- Lookup Trouble
- Footer seperator
- Depreciation formula
- Conditional Format w/ VBA (Excel 2007): does this make sense?
- VBA Print Macro
- Suming multiple values in a row based on criteria for 2 other rows?
- Need a Quick Macro
- Macro to Filter Data Based on a Given Criteria
- Search Column
- Removing a space
- Create a list based on a value in VBA
- Macro Help!
- Protecting Sheets
- Issue copying filtered only visible data to another worksheet
- excel 2007 on cell click copy cells to worksheet
- Cap a subtraction for example, 60-20 = max (12)?
- data entry and record keeping
- Adding a loop to existing code
- How to display numbers only? Text & numbers in the same cell (Excel 2007)
- Help with multiple IF and OR statements
- vba formula
- Call procedure from a cell.
- How do I autofill formulas to the last row
- Counting inside a cell
- SaveAs in Either 2003 or 2010
- MS Excel VBA - Call procedure with variable
- Nested IF and ISBLANK formula needs work...
- Stuck on a Nested if statement
- Troubleshooting SumProduct #VALUE error
- Insert Comment Hotkey - Excel 2007
- Capital Reinvestment Formula
- Extract groups of data from a table into different .txt files
- Need help with this string...
- Evaluate The results from 2 cells
- "Convert" regular formula to array formula
- Help needed to calculate unit cost
- Quick VBA Question
- VBA equivalent of VLOOKUP
- Convert text to dates, help
- Text To Column For Indivdual Cells Based Upon Value In Col B
- Cell to call different Worksheets
- Command Button In Front of Web Browser
- Form label with updating ledger??
- Prevent Deletion
- Combobox autowordselect problems
- Count cells in one sheet and then produce a new list in another
- Populating ComboBox with Worksheet_Open event
- Web Query Parameters
- Run Specific Macro
- Auto.Filter Criteria
- Copy, insert and paste VBA-code
- Upload File to Oracle Blob
- How to include tables in Mail Merge using hyperlinks
- Freeze selected cells or "floating" range
- Auotfilter not counting # of records correctly...
- Flummoxed!
- Extracting data from a range
- Please help with Pivot Table
- Combining two columns data into one
- Question on Cell Color Based On Input
- Conditional Formating
- record navigation control
- Copy & Paste to Master worksheet (VBA)
- Automatically Posting Static Time and Date
- Creating a daily moving average over past year
- Define a name range - Refers to - Scope.
- Urgent Help - Number range divided into 3 buckets
- Change Icon in Taskbar 2007
- Simple calculation when criteria is blank or not
- AutoOpen newly created PDF then email it
- offset function help
- Creating report by merging to sets of data using excel?
- Variable to store the filtered values
- Formula to find value greater then 1 and position of found value.
- sorting two columns and write the sorted values on two columns in a different sheet
- Number Format
- Using Defined Ranges in VBA
- Timesheet Summary
- VLOOKUP with text, numbers, and characters in string
- UP UP and away
- Excel Sort and Cells with Errors
- standard deviation with multiple criteria
- Type-ahead function
- concatenate like-cells in column B
- refrehsing the textbox value
- VBA Combobox Add Items Without Duplicates
- Lookup 2 values formula
- Copy data from Inspection form into Database
- Like formulas
- macro to clear cells based on condition
- Template Wizard File Save Issue
- Copying unique Data and Inserting New Row
- Need help in vba hyperlink
- Drop-down list: value display different from value selected
- replace one comma and not another one
- What doe sthis refer to?
- Macro code help
- Error in “If Else” code when deleting cell contents
- Popup calendar problem
- Popup calendar problem
- Run macro on cell entry
- Macro Transpose Help Required - 1
- Adding Spaces
- A global variable... i think thats what its called.
- Changing Datase to transactional data
- Dynamic Combo Loading
- Excel status bar option toggling shortcut
- Substitute using arrays for old_text & new_text
- Macro 2007 vs Macro 2010
- Code for transfer rows from worksheet to another worksheet.
- Password Protection help
- ribbon 2007, radio button
- sum figures with 2 criteria
- Dynamic Autofill issue.....
- Excel macro - activecell in range
- Lookup facility
- dummy variable
- Add image in mailbody(Outlook'2003).
- Insert row and move data depending on the date
- Macro to copy one cell and paste to another
- Color coding excel cells using VBA
- Excel 2010 freezing on Save As
- Update Properties
- Using Last Row
- Closest to 50%
- Macro creating pathfolder when not exist
- how to insert dynamic variable in a range
- Can't navigate worksheet using arrow keys.
- Unprotecting A Excell sheet
- Calculation of number of persons working in each shift
- conditional formatting formula
- Excel 2007 Data Validation
- When using and IF and an AND combined formula
- VBA update a mastersheet
- can my code be made smarter ??
- Can =CELL also pull in the color?
- Breaking up a cell into multiples
- Manipulate IE With VBA
- Formulae - can you help
- Can you use the Sum formula but get it to ignore any #N/A
- Set text month
- Extracting information
- How To Copy Data From One Worksheet to Another
- Conditional Formatting and blank cells
- SUMPRODUCT bet 2 dates
- Lost VBA Library References when you move from One Computer to Next
- Set select cell values to 0 when opening sheet.
- Worksheets to emails
- Make some sheets read only
- Another syntax question please
- Clear All TextBox, ComboBox, CheckBox Fields Without Identifying Each Control
- Formula problem
- Start Time, End time and the Difference
- Need to hide few textBoxes in excel using Vba
- Copying data
- Matching Numbers
- Reference Single Cell within a Named Range
- Stop Calculating when filtering
- Trying to enter weight, Excel converting to time
- sending email from an excel spreadsheet
- split entries separated by comma
- Dynamic chart as a template or How to copy a dynamic chart
- Excel Book Question
- Macro Help
- Sumproduct where criteria cell is blank
- Complex Lookup within table
- cut sort & paste
- Automatically hiding rows based on specific value...VBA?
- Macro for Conditional Formatting
- Need to test if number is integer in VBA
- Last Item
- PutInClipboard Function
- VLookup Question
- Copy hidden columns-VBA
- Date
- Drop down to change "values" in pivot table
- Silly Indirect query
- Vlookup and Date problem
- Show all Autofilter Macro
- Date, Time & User Stamp with cell protection
- Chart Question: 2 "levels" of data per time period
- Duplicate Entries
- Run Time 1004 Merged Cells Error
- formula to input either Up or Down
- Formula help needed please
- Adding Up Formulae
- "SOLVED" How to get excel ignore a value and treat it as a zero
- USING =WEEKNUM ( Excel 2000 )
- text box w/scroll bar protection
- Can't Execute Code To Change Website
- Toolbars
- Creating a word document from Excel
- Sheet Name to Use in Macro
- Excel 2010 on windows 7 vs. Excel 2007 on Vista compatability issues?
- Doing a vlookup with a date
- Plz help me to creat a login form in excel
- Link a field in one worksheet to another
- How to close down workbooks after using them for merging
- Combining Documents
- update chart range with a macro
- Stacked / unstacked combined column chart
- Delete row if data in column B is in column A
- Macro Calculation
- Simple for you, difficult for me
- automaticly add date
- Cash flow analysis formula
- Formula Related Help
- Create new sheet..vba
- Delete Row if cell above is the same
- Testing whether today matches criteria
- Index Match Explanantion please
- Non Zero Rows...Excel out of resources
- Can't type text in a text box
- If statement help
- AVERAGE with MULTIPLE CONDITIONS
- Copying Data Validation Lists.
- My date converts to a number
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.