View Full Version : Excel Questions
- Changing Column widths using formulas or VBA
- How to change numbers into time format
- import list of filenames
- I'm getting run-time error 91; what is wrong with my code?
- Sort syntax wrong?
- "Activate" box in 2007
- How to display value in a formula
- Offset/Match With Only 1 Row?
- How to update depenent cells mid-loop
- VBA Input box
- Mobile Phone Bill Template
- update from 2 workbooks
- Inserting Missing Rows in range
- If then and/or do loop help
- Help Needed
- Stepping Through Columns as Number
- Macro will not execute but will if I step through with F8
- Copy rows to another worksheet based on condition
- Need Help to Count and apply to Macro
- finding a value from an array, returning the name at the header of that column.
- User Form
- Why am I getting more then one number after decimal
- Validating Variable List
- Opening Access from Excel...
- Sorting an Array Formula
- Send Info from a moving cell to other pages?
- Problem with Use of LIST & pivot tables
- macro in excel 2007
- Copy Worksheet to an existing workbook
- How to create dynamic comment in a cell in excel
- How do I change the values along the x axis?
- Reading attached notes in cells
- Interactively Filter Chart (Pivot Chart?)
- Add 6.25 for every "Y" value?
- VBA matching >1 value in a loop?
- remove unwanted code?
- Comparing 2 columns in excel
- How to change number to dates
- How to sort alpha-numeric & numeric data in a sequence?
- If formula for filling blank cells
- Viewing workbook online
- Bill of materials
- Converting numbers as text
- Default Pivot Design Layout
- Creating Numbering System Containing Letters
- "sumif" function
- Monitoring CPU useage of a process
- VBA code to remove end character from a word...
- Link to powerpoint
- Excel file suddenly slow calculation on opening
- Please help me.
- Please help me, I have wanted a one formula for separate text & numbers by comma within one cell. e.g. Sunny9766305101 Sunny,9766305101
- Auto input a cell when I enter a data on another cell
- Randomize List for Competition Draw
- Fill MS Word From Excel?
- Naming a sheet/tab by refering to a cell
- Many duplicate numbers in a row, how to determine what numbers are there
- "Drop Here" areas missing when creating Pivot Table
- Conditional Sum
- directly quit excel upon pushing x-close button
- Create folders based on filename
- hyperlinks
- Formating fractions in Excel
- Borders in userform listbox?
- Formatting cells
- Using value from a cell that has formula
- Variable Print Area?
- Save Custom Lists
- change cell's text colour
- How to compare two columns and enter 3rd value if matched
- Listbox values to populate textboxes?
- second() rounding errors
- Named Dynamic Range??
- Priority Drop Down List
- Need help with a macro
- Using a calendar to schedule time in excel
- joining to cells
- Look up table according to a criteria.
- Backing up(Saving) the active workbook...
- Compile Data from multiple spreadsheets
- Any way to reset lookup range in a macro?
- Copying selective data from one sheet to other sheets
- Shared opening as read only
- VB and Picture help needed!
- Ensure scroll bars left horizontally and top vertically
- Better tool for drawing forms in Excel instead of Excel vba
- Minimum greater than [Cell]
- Cell reference in Indirect function
- Extract Text to Cell
- Add x number of columns begining with col 3
- Excel to Access Query Issue [Office 2007]
- VLOOKUP does not work when lookup #N/A
- PasteSpecial Function that pastes the visible format. Has anyone seen any code out there that does this before I write it myself?
- Submitted earlier, no replies....
- Sumproduct and Indirect work together?
- Need Formula
- Byref and Byval
- Formula quandry
- Calculator: Given 3 variables, find 4th
- Pivot Table Subtotals are Wrong - Instead of Zero, tiny amounts are displayed
- Using VBA to change the Font color in a cell...
- Pivot Table Subtotals are Wrong - Instead of Zero, tiny amounts are displayed
- Retrieving Data From Word Doc
- Change the name of a command button on a user form after saving the form data
- Drop down of several horizonal cells
- Different scales on chart
- MACRO - combine data onto 1 sheet
- COUNTIF in a Pivot Table
- zip files and make exe
- Drop Down Box
- Copy i excel
- Enter an array formula in VBA
- hyperlink replication
- Read only, but still single user.
- Formula With Criteria
- count visible sheet
- HELP!! linking workbooks!
- Copying Data Seperated by Commas
- Selecting data without using filter
- Auto value for coloured cell
- Area of shape
- Can it be done - Cut and paste rows based on color????
- My Excel File shows error
- How to paste screenshots present in word doc to excel
- Excel Chart inversion
- get address with match criteria
- Fill Cell With Text From 2 Other Cells
- Excel to Word Conversion
- Can I display and count the number of times an id number appears in column K?
- Highlighting Dates Based on Table
- Excel 2007 save as dbf4 (dbfIV)
- Fill between two values but a differing column.
- VBA listbox issue
- Post userform data to workbooks on A Network
- Selection.QueryTable
- Add to a custom ribbon tab
- Code for simple task is needed
- Double Pull Down Menu
- Unhide Sheet Named In Cell
- Changing the Text Size of the Combo Box
- Can we compress the list of Excel files by group through VBA
- Save as
- SaveAs
- Ban External Links
- Sorting year of birth out
- Merge all files in a folder
- Ctrl+arrow key error
- When closing Workbook VBAProject Password box Pops-up 4 times
- UserForms & Calendars
- VLOOKUP strange data
- Formatting
- Compare worksheets from two workbooks
- Compare 2 worksheets and see what has been updated
- code to open and close w/bs
- Using VBA to Define a variable number of named ranges for use in a Pivot Table
- Formula for Date & Time Stamp a Change in Value in a Column
- VLOOKUP with separate worksheet
- SumIf question
- match data
- Formatting code A3
- Switch to Worksheet Using Macro
- Eliminate Blank Row in Code Creation
- vba code
- e-mailing worksheet
- #ref!
- Change the color of a command button back to Grey
- Status Bar
- Help with formula in advanced filter
- semicolon
- 7 conditional formats
- Can I attach a file to this message board
- replace help
- Screen becomes garbled
- AND is WAY too long
- Simple create range question
- Collecting data by date
- Ignore commas in new Excel sheet?
- Finding atribute LastAccessedDate of a file and make it a Excel range value
- Concatenate cells but with spaces between data
- INDEX Question
- Help with Dynamic Totals
- Convert Columns to Rows with formulas
- application.match with multiple matches
- Preventing info from being deleted
- Macro to autofit
- Please Help with my College Football Picks Spreadsheet (Comparing correct answers)
- macro help: Inserting a row and adding a formula (several times)
- Userform on the internet
- Need of Vba Code
- Copy Text Using Loop?
- How can I import data automatically from SAP to Excel?
- formula created Charting/progress bar
- Link MultiPage Tabs from in UserForm to an individual Worksheet
- Macro To Report Active Cell
- Formula Result does not Equal cell value
- Problem with formula and vlookup
- file size issue
- Text In A Messaage Box
- Macro to - paste special - values
- Loop within a loop
- Need code for a macro to delete all others and then itself
- Adding character ";" to the end of cells
- Look before you paste
- Prevent Macro Working if cells are incomplete
- Subcolumns in pivot table
- Validation Lists question?
- Lookup using row and column names
- change international format for Date
- Using a variable in FormulaR1C1
- Import or open text file and directly transpose the data
- AUTO COLOR ROW help please
- Hide / Unhide Sheets Macro
- Help so MultiPage in UserForm points to the last number of a named worksheet
- VBA copy data between "non-static" workbooks
- Matching two lists. Many duplicates that only need to be matched once.
- add hyperlinks faster - code efficency advice required
- Inputting Password Visibility
- How do you add cells while excluding values??
- Date Question
- Date Question
- Easy way to chang color of a cell?
- If statement needing 12 arguments - possible?
- Textbox
- need macro to look for numbers in a column
- Enter SUM formula using VBA
- Hide Zero Values EXCEPT in one cell
- Paramarray to write records to access
- Summarize Data in Pivot Table
- error 1004 using match
- Auto complete issue
- Excel or Access
- Multiple condition IF statements
- Using Text in Excel
- range().Find() Break issue
- Yet another "run a macro when a condition is met" question
- Anyone know an easy way to concatenate this?
- Calendar - Shading Time on Calendar
- Excel calculator conversion
- Still Fuzzy Lookup Probelms, Need Help!
- Auto Fill Code
- Data validation drop down box
- Code Is Crashing Excel
- Unprotect a chart/graph in Excel 2007
- Excel not prompting that a spreadsheet is read only
- Measure object in Excel
- Extract specific cells from workbooks
- I need some help modifing my macro please
- Pivot table sorting
- Best way to sum up YTD data in rows?
- Highliting a "found" cell
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.