View Full Version : Excel Questions
- Chart with 2 X Axis
- how to label a row?
- How to ignore space?
- Pasting a range into a sheet
- Hiding Sheets
- why it doesn't start from row 1
- Selecting a range using variables
- Filter according to color
- find first and last element of a column?
- Help with Count function
- how to compose a variable name?
- Automatically find, cut and paste
- Grouping by Date in Pivot Tables. Confused.
- Help with email code
- Formula changing when inserting/deleting cells
- Extraxt Name and hours from one sheet to another
- IF Formula
- Dates need to be end of the month
- Using different values for a cell
- Data Validation
- Stopping 'new sheets' tab
- Append data in access with VBA
- How to display linked values
- Problem in Average and Sum
- Putting together two blocks of data
- VLookup Table Array using variables?
- Problems with Excel .csv files
- Copying to a new worksheet
- add to previous row value
- IF Formula
- 1004 Paste Special of Worksheet Class failed
- Using Match to bring up user form
- 5.6 MB file, users having difficulties
- Dynamic Range Based On Column Header
- Extract Part of A Text String
- drop down list
- Displaying different worksheet using the timer
- Cell location, offset
- Webpage
- change the shape of cell?
- Count if using two variables
- Ctrl+X Not Cutting?
- Personal.xls not working????
- Work shift allocation
- SL Date
- Userform Command buttons
- Inconsistent behaviour opening csv files
- Invoice Formula.
- convert variable types in VBA
- Some questions
- Brain Teaser!!!! Need Help
- {Sum(if(... )} applied to whole columns
- Hiding Rows with Check box macro
- SUMPRODUCT Help
- Pivot table sort order incorrect
- Horizontal Scroll Bar Not Working?
- Excel 2007
- Assigning & Formatting via V/B. (Excel 2003)
- Another SumIF() question
- Copying/pasting a link in a hyperlink
- Drop down list for the criteria range of the filter function
- Help me pls
- Transposing a list
- If statement with Concatenate
- Non-Linear Trending
- Realtime sums on a user form.
- Modify my code to grab source formatting?
- auto date to prior friday
- Problem with vba if statement
- VBA Coding
- Automatic Cell Population
- Speeding up Page Setup
- Full Screen View Problem
- Counting Unique entries with a condition
- Need help with text lookup between two lists
- Getting a max date if it isnt realy the max
- Can't open password-protected Excel 2003 spreadsheet in Excel 2000
- How to find the closest date
- .showseriesname equivelant for xl2000 (VBA)
- vba code to ask for registration
- Bubble chart with pie charts for bubbles
- Copy & Paste Question
- Help needed with Excel-to-Word automation (VB)
- Formula needed
- Compare, add, and highlight
- Changing Merging Multiple Workbooks into one Master Workbook
- Macro help
- Weeks of Supply
- Is it possible to create a spreadsheet with values that automatically reset every day?
- How to loop variant fields?
- VB Problem with COUNTIF
- How to change code to reflect 2 digit year?
- Need some help to create a formula
- Print to PDF issue
- using a variable to enter cell value
- Forms in Excel
- getting a Const by its name
- Validation
- Select group of Objects - Macro
- Choose Currency Format from Dropdown
- Run Command Button IN Macro?
- Divide by zero and get 2 different answers
- Use VBA to conditionally hide rows
- Using vlookup to paste in corresponding row
- Using ROUND instead of MROUND
- Help on Checkbox Macro
- Problem with repeating rows ....help !
- not working at all
- Test results analysis
- First
- Code To Print . .
- Alphanumerals
- minimize/maximize
- VBA: Error 1004: Select Method of Range class failed
- conditional formating slows down calculation
- Hyperlink using "current" file name
- finding the function
- Create array of varying length?
- Difficult Cell Reference?! Maybe not for you!
- Help with CountIF
- inches and decimal fraction
- How to know what has changed when Worksheet_Change
- Macro to copy, paste transpose extract at each change in contract num into new format and sheet/file
- VBA- How to enter this formula???
- File System Object
- need help with a formula
- pasting in order: 1, 2, 3 not 1, 9, 17
- override passcode files
- Rounding Pro rata calculations question
- Zero a column
- Lookup & Match Functions in Excel
- Countif Functions with OR
- Not a clue...
- How to easy add and subtract to and from a list of numbers?
- Formula to add total about of T's
- Macro to copy and paste result of formula
- Strange error with Save Macro - Excel 2007
- Filling Formulas Down within Variable-Length Sub-Totals
- VBA Wierdness using Mid to dice a string in an array.
- Group Values into Multiples of 100 (?)
- Excel/Access query not running correctly
- Formula for adding current value to referenced cells from other worksheets.
- First and last value in a range (row)
- lock checkbox control
- Formual for a calendar to day of the week
- Macro Not Grouping in Pivot when Rows in SS change
- Multiple Records (Rows) from 1 Text Box, Userform
- Difference between VBA and VB
- Sum Data
- VBA code to facilitate ease of use
- Dinamic Sheet refrence outside the working Workbook
- Looping through text box controls on User Form
- Macro help please
- Multiple Criteria IF Statement
- Daily Reminder Message
- Excel Error Help
- Remove rows with the same # in column B whose row's amounts in column M total to 0.
- Finding Last "P"
- Conditional Look Up Function
- Excel Macro Works if condition is true.
- Drop downs & lists
- how to conditionally 'freeze' the value in a cell?
- how to conditionally 'freeze' the value in a cell?
- Highlighting active rows
- Count
- Macro to transfer cells in one col to diff cols
- Chart Graphics
- Offset Problem
- Help in removing certain words in a cell
- Reduce Stock After Making Invoice
- Count With Address
- Delete row based on value in column
- Extracting certain values in a Column
- Finding last row - non-VBA
- Searching through cells and extracting a value
- Is it possible to do ?
- Excel Version Check
- Conditional Formatting
- Sum #n/a
- Opening Excel using VBA
- Better coding for 3 If arguements
- Cleaning address data
- Change date range cells to contractor cell colour.
- Time Range From - To
- =NETWORKDAYS() for 6 working days (MO-SA)
- VBA to Open and SaveAs
- Conditional Formatting - more than 3 levels?
- Save a file based on filename
- Multi Page Default Page
- Function for summing just positive resp. negative values in a column
- Changing formats and viewing numbers
- List results
- Filters and different excell sheets
- Setfocus not focusing
- Rounding percentages in calculations
- VBA in Outlook.
- VBA Text Input Box Pop UP
- VLOOKUP & ROUND DOWN outlined numbers
- Validation
- Problem with Trace Dependents
- Lookup calculation
- Formatting problem
- Stop Combobox defaulting to blank
- Odd error message on opening workbooks
- Inculde a cell value in a formula link
- 3 Questions
- Reset New Worksheet to Sheet1
- VBA help in Excel
- formatting cells to 2 decimal places
- Conditional Lookup
- Copy and paste VBA
- Populate "Save As..." Dialog box
- find, copy and paste function
- VLOOKUP / INDEX&MATCH / Other?????
- Need formula or macro help
- Forms: Text Box displayed text varies in size
- CELLS.FIND doesn't find date in list
- Multipage on Userforms
- Hiding cells with a formula
- Send multiply values to the same cell
- Daily entries automatically cut+paste to month worksheet
- Freeze Decimal places for % Column in Pivot Table
- Comments
- Four column VBA combo box?
- Progress Bar Issues
- Code to open a workbook with a date
- Indirect function
- Data Extraction
- SUM_with_OFFSET (& Condition)
- Consolidate multiple order lines
- Stopping duplicate worksheets from being created
- COUNTIF - What am I doing wrong?
- Combine 13+ spreadsheets onto one Master Sheet
- looking through list of numbers and sorting
- Formula for a cell
- Execute macro on receipt of email
- Mapping Formulas to another sheet
- Vba Code Protection
- Help Copying Certain Cells
- if function - limit to the number of if/then inputs??? HELP!
- Combining columns in multiple rows
- VLOOKUP VBA code results in #NAME?
- Overtime
- Help Worksheet Change Code
- Macro To Run Until A Specific Date
- Jump code in VBA based on contents of Cell
- Troubleshoot function
- VLOOKUP and SUMing a column based on it
- Vlook up with no exact match
- Breaking down a date format
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.