View Full Version : Excel Questions
- Excel: VBA: Format Group of textboxes on forms
- Tax Brackets
- Automatically Run Macros Using Task Scheduler
- Perspective Projection & Excel / VBA
- Intersecting Named Ranges - One Common Range
- Hide Command Button based on value in range
- Add total in row
- Macro to manage data from import
- Random dinner party assignments
- VBA - Addressing Workbooks, sheets and ranges when stored as objects
- Cell value to begin a macro !!!
- Slicing A Dynamic Array
- Extracting the number of seconds from a variable text string
- an excel formula
- Associated drop-down list in form of ActiveX with OFFSET ()
- range selection using VBA
- V Lookup
- Display Link and reordering text?
- Get uppercase lastname from string
- Text to column
- Array Worksheet Formulas
- Total treeview node children
- find the text from the entire column and mark it in red colour
- Small Macro
- Please Help Me
- COUNT without counting the duplicates and skip the errors
- LEN of Words before Comma in a cell
- How to express a column
- proper formula
- vlookup issue
- Name Col B with its Number in Col A
- i need quick help plz.
- Excel VBA Code isn't working but does in Debug
- Loop code
- Values from one column against all the occurances from 2nd column
- Today date
- linking workbooks
- Next open line
- userform with txtbox and option combination
- Occurances Formula
- Col B: name Col A: number
- Lookup result from Date Range
- How to add a task item to an outlook public folder with vba macro / vbscript?
- Macro help for a novice - combining worksheets
- VBA Program for check updated values and subtract with ather values
- Show product selection only if there is stock?
- Autofilter by a certain Date Range?
- Convert Base 58 to Base 10 and vice versa
- Close linked imported text file
- Reference Activce X commandbutton from within Userform
- next open row
- Deleting Blank Rows..Consolidating Data
- Close linked imported text file
- Additional Delete Sheet Warning.
- copy cell if value equals to
- Converting Nested Excel Formula (SUM, IF, FREQUENCY) into VBA
- Place Value
- Golf Scorecard - Populating scorecard with "pops"
- Please help!
- Help with nested if function
- If Statement with Vlookup Match
- formating and limiting number of duplicates to less than 3
- countifs
- using excel cell as pointer in a directory path
- Excel:Mac 2011 Keyboard Shortcuts
- Max and Array Formula
- Weighted Average Help!
- Excel Formula or VBA: how can i find a word from the column
- Find Loop?
- Finding the lowest value
- Loop printing
- Formula to divide proportionally?
- How to Name Each Individual Sheet/Tab Within Excel Workbook
- Subtract minutes in 15 min. increments
- Countifs with different results
- cost according to square foot ????
- Microsoft Excel Training
- Excel Training
- Wrong Code????
- Need to calculate an average, in a vba generated subtotal
- If statements based around Find results
- Capturing changes in reference cell value
- Exclude column G
- Challenge - Capturing all randbetween values in different cells
- Averaging dynamic rows from bottom up
- Need major help adding values to a Cell
- Sum product based on 2 values
- Cell color change based on values
- Copy and paste range count into tab
- Need help reading 2 columns and extracting data under certain conditions
- convert $A$12 to a value
- trifecta output
- VBA - Copy Values and Enter in next blank Row
- Error 13 Type mismatch help please
- Cell data on one sheet as variable for use on another
- Sumproduct weighted average with one condition
- Using two userforms
- Add data to pivot table
- Calculations based on consecutive rows
- Job and Availability Match
- Using Multiple printers
- Alternate Looping method
- Any code to validate external hyperlinks?
- Deleting range of cells in other worksheet
- Remove False
- if-or-and question
- Deleting range of cell in other worksheet
- Sumifs
- Userform - Data Check
- VBA: Count Not Null
- Using two userforms
- Help in IF formula
- Hacked and cheesy code - fix if you want a challenge
- add rows to spreadsheet
- VBA: Copy & Insert a row x times
- Copy and paste loop between sheets
- Date Question
- Generate all possible combination list
- adjustment to this vba code
- URGENT Question about Data fields in Pivot Table
- How to get rid of -100% values in pivot chart/table using % difference from
- Password protect worksheet for multiple users
- Addition to macro code
- Connection With Excel Data base Workbook by VBA
- Calculated Field/Item - Need to Add a Sum Column into Pivot Table
- Establish New Connections from External LInk
- How to call a file (.txt file) and paste it on the same WORKBOOK.
- i need help plz.
- Pivot Tables - limiting columns in drill down
- Weekday(VBA.Date)
- find the referece of data
- Show last working day.
- Need to convert the values
- Short key/ hot key for CommandButton
- Excel 2007 error: Method 'Delete' of object 'Range' failed
- Split Cell into 2
- Possible Macro?
- how to share....
- $ Total column formula with slight twist
- Count Conditioned Color Cells
- Left side subtotal column in pivot
- Datepart alternative
- Punctuation in VBA calculations
- VBA Code previously working okay but not now, works relatively okay in Debug though??!
- Splitting Text String Across Rows
- Create validation data list that can add a user's unique data
- Formula to remove last digit if it's a number
- Link Data
- Compare Cell Value between 2 range of cells
- Need to Pull a number...
- Countifs statement checking for number of red cells under 2 conditions
- Mail a single sheet wo code
- Running Total Formula
- change zero
- Delete sheet based on cell value
- Sports Ladder tiebreaker
- Code or macro required
- It is possible?
- i need a quick help plz.
- SUMIF in VBA
- Dynamic chart ranges
- Building a Summary Table From Another Worksheet
- Please Help - Sorting data???
- VBA Drawing Help
- Identify Duplicates
- Delete Entire Row upon deleting a cel
- Does VBA programmer need to know VBScript?
- VBA Excel Thinks Number is Lower Than Another
- Excel Columns became numbers instead of letters
- Formatting font colour of entire row (or just A:J) depending on content of two cells in the same row...
- IF or LOOKUP function issues
- Format function not working
- Formula Help to find x between date range
- quotes problem using variable in concatenate function R1C1 notation
- GMT conversion help
- Formula help - wildcard?
- Capping result from vba calculation
- MODI to Word
- Error with 64 bit system
- Formula Help
- Excel basic macro help
- Populate excel spreadsheet with email tracking results
- Matching 2 datas (vlookup?)
- finding text that matches format criteria in string,
- Is it possible to filter on all colors?
- Error I don't understand
- Problem w/ file save macro fileformat:=52
- Finding out Printers
- Help with count formula
- Disable Menu Item Based on ActiveCell Formula
- Error on trying to return value
- Difference between start and end rows of consecutive data
- Macro to reformat sheet
- Interior.Color not working
- launch on double click - macro help!
- find and replace
- Pulling info from one sheet to another
- Hide zero or error values in radar chart
- datepart function in SQLServer vs Excel
- Static data for directory
- Adding "st, nd, rd" to a number
- how to count only visible cells
- Efficient coding: Deleting lines
- Making VBA select rows that have desired paramters
- Sort by difference between values in a pivot table
- VBA: refreshing query table w/ ms sql
- Auto generate and name worksheets
- VBA Loop Help
- Saving Currency In CSV
- Find Text
- Printing Duplex both sides of paper
- Numerical Order
- Can VBA do this?
- Put "tab" name in cell
- Min, Max and Average
- Pivot Tables - limiting columns displayed in drill down
- Combo Box question?
- If(B2 (text is not in a list),0:0:0, (Time from column A))
- Error in Vlookup
- VBA Loop / Sort question
- Year to date formula, need assistance.
- Excel 2010 - Last Row in a Table
- Code tweaking
- Comparison between two numbers
- Run Time Error 1004 in Query To SQL Db
- How to find last specific number in row
- Array transpose formula
- Macro/Formula for which value occurs first?
- Display advice
- Nested "sumif" statements?
- Need Help with AutoFill
- Need to make new column with quarter based on date in anothe column
- Help with Complex IF Statement
- Select Contents of Cell With Macro
- Grouping Excel data during a mail merge for individual recipients by data in specific column
- Dynamic Weekly Graph to run from Monday to Sunday?
- VBA to insert picture
- Simple: IF statement with current ranges
- Copy and paste from column to row
- Fill Handle Settings/Issue
- VLOOKUP Circular Reference
- Sum cells visible after autofilter
- conditional formating with IF values
- Is there anyway to see what color (code) I’ve used for a border?
- match/look up????
- Delete duplicates
- Change File Name On Network Drive
- Slow VBA/Excel Problems
- IF Stmt Translation:
- Help with function
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.