View Full Version : Excel Questions
- Printing Multiple Named Worksheets
- Is this possible?
- List Box Help Required
- Date format Excel - should be easy
- how to find the saturday of a week for any given date
- Arbitrary name of new workbook - solution
- Macro to go to the cell with the error
- Cell cannot be blank
- Simple one.....Please help....
- Group Pivot by Text
- Using selection to feed list
- Calculating totals based on critera
- Locking a range of cells
- Macro to be created in Excel
- Excel 2003 - outlook 2003 change appointment
- Highest Value In Previous 12 Months
- Countif nonblank lines
- Macro to XML Coding...
- Help With Paste Problem
- AutoFilter Performance issue
- Lookup with multiple results
- Populate a master sheet from other tabs - Macro
- Run a macro if a cell chnages value
- code execution has been interupted
- Is it possible to convert a datevalue into txt?
- Macro to find cell, varying postions
- IF Statement
- Rows to Columns
- Help needed
- date question
- linest and a conditional array
- Easy Question - Splitting Content in Columns
- Using ADO to Add a Recordset to Access
- Cell formatting randomly changes when opening excel files
- Getting a number to the right of 'total' text in various worksheets
- A simple question...
- Quickie #2 VBA code
- IF statements in VBA
- R/T error 1004
- how to get the correlation of any two variables
- Help........plz.....This thing is driving me Crazy !! VBA code for Imagebox stuff
- loop with a find next??? help please
- Error when copying a formula
- Tab on OptionButton
- Vlookup
- A tech question...
- Counting Months in a range
- Method 'Range' of object '_Global' failed
- VBA - Copy Range, Paste, Next Row
- What do I 'Dim' this as??
- Parameters for database connections
- Search for value in table using row and column headings
- help with macro to paste values automatically
- Lookup value on partial text string
- Userform Command Button
- Percent to Goal Formula - Help Please
- Percent to Goal Formula - Help Please
- Further to Wizardry or other
- Entering data in tabular format
- Lifo, fifo, weighted average
- VBA to Create New WorkSheets
- Excel data as Querying
- Further to Wizardry or other
- Complicated Macro Help!
- Match function with Indirect
- Matching 2 sheets with a macro
- Right INSTR
- Compile error in VBA for Same Day last year code.
- 3 consecutive home matches
- Colour columns based on set criteria
- Automatically update pivot table based on cell formula value
- Excel 2003 - The start of it all...
- Converting Excel to PDF
- Adding to a Sub Mail code
- Highlighting cells in UPPERCASE
- Multiple entries from Form to Sheet
- Custom Toolbar Buttons - Excel 2007
- VBA Importing EASY question process
- Cumipmt
- Remembering Values like MS function on a calculator
- need this short code to be more efficient
- Lookup Match with multiple results
- Number conversion
- vba loop through selection of worksheets
- A trivial macro that recursively moves cells in a row.
- out of memory
- Formatting when Referencing...
- Hide columns with no data
- VBA help with code please - Probably simple !
- Save current WorkBook, Open Template and close saved Workbook at midnight
- Stupid user form tricks? ...I can't find this in search...
- Sending Commands to a DOS app opened with CreateProcess()
- Vlookup vs If Statements?
- If result of cell is true then
- Sending Commands to a DOS app opened with CreateProcess()
- If result of cell is true then
- Custom Formatting
- Need Help With a Conditional Formula
- Fixing the size of pictures
- Macro to "find"
- need help with multiple lookups
- How to apply a formula to an entire column
- need some ideas
- Excel Chart Question
- finding last usefull row using macro
- Why doesn't my date sort work?
- Help on formula
- Updating Defined Name Range
- Copying VLOOKUP Formula Across Columns
- If and For statements (first available cell) in VBE
- Named range as data dropdown
- misplaced negative symbol
- If Statement, What am I missing?
- Text and Formula in the Same Cell
- Need Macro to keep certain rows and Delete rest
- almost there... Justt one bit of info..
- Want to do take an inventory spreadsheet to the next level
- Debug Macro on Protect Option ---
- VB to expand/contract "Grouped" rows
- Need some help...
- Comparing a range
- Help on Macro
- Code not picking up numbers
- Formula in Header or Footer
- Is there a better way to do this formula?
- Conditional Insert Row Macro?
- Formula help (timesheet)
- Vlookup formula help
- Merging Daily Reports into a Montlhy or Yearly Report..
- Inputting a VBA variable into a .Formula
- Conditional Formula
- Counting unique text values based on a criteria
- Splitting a column into 2
- Combine two columns
- SumIf in VBA with Table Ranges
- Vba coding help-image
- Increasing by 1 after a /(Divide) - How?
- Aggregate Columns into Rows with Commas
- I need to change "Jane S-Doe" to "S-Doe, Jane" in the same cell. Help appreciated.
- vba, loop,
- Return unique list, sorted
- serial inport in excel...
- Run Time Error 1004
- Date formatting
- count subfolders
- Conditional Format and Formulas on Paper
- Find, copy selected cell, paste in another sheet all with a macro.
- Difference between LARGE() and RANK()
- Calculating business days only
- Iserror
- Countif problems - multiples
- Data in unrelated cells disappears when paste function used.
- script/formula that recognizes formatting of cell contents
- A Formula Question
- Frame a Picture
- count if with two criteria, including number within a range
- Issue while using J-Walk Chart Tools
- How do I extract data from multiple workbooks using VBA
- '2 in a row' Too Complicated For Me!
- Need formula to determine time to reach a certain value
- Remove part of string
- Cannot open excel 2000
- If problem
- Removing dashes from a Social Security number
- Cannot Redim this Array
- I cannot change value of cell in another (non-active) sheet
- Appending numbers to text macro.
- compare dates in VBA
- If Statement for 17 diferent values
- IF Statement + Determine 1st Duplicate?
- #value!
- Sum Visible Cells Name Error
- Need help with keyword search function using SUMPRODUCT
- Excel formula referencing row and column from another cell
- Need help in Macro
- Data Validation
- CountIF Business Day Against Specific Date
- Copying range of cells from one workbook to another.
- Those #### boogars
- returning all values in a column
- Generate a list of names, excluding the entered name?
- Autofilter macro problem
- Looping & Value Matching
- Is there a way to print hidden cells?
- Create a Copy of worksheet to new book minus macro buttons.
- Need Help: Executing Access Macro from VBA Excel
- Possible to combine into a shorter formula?
- Help with extracting text from a string
- vba code to rename a named range
- Subtracting & Adding Percentage
- Conditional Formatting based on Vlookup
- Calculate only working hours between two dates excluding weekends
- Modify a custom toolbar button
- Nested For Next Loop w/ multipule Arrays sequence
- too many worksheets
- Displaying data in correct format
- SUM INDEX instead of OFFSET
- Macro Help
- Input past end of file error 62
- rolling 12 month average
- How to Detect Tampering with the Date
- Find multiple text phrases
- value of cell
- time Formula
- Printing Ranges
- Speed issue with autofilter
- mai merge
- if font black delete row
- Countif function
- Excel to access
- insert or delete row using macro
- Preserving Superscript when using CONCATENATE
- Lookup, help me!
- Dynamic sum
- Simple Code to find text......Please help.....
- Macro to Scan Directory
- Advanced filter; mulitple rows needed in criteria section
- Networkdays and multiple holiday ranges
- collecting data out opf several workbooks
- Pivot charts in Excel
- find in range defind by cells does not work?
- Formula help
- number selection
- Date Formula..
- Row number of the last instance of a specific value - non sorted
- Calculate Attack Time
- Adding Minutes in a formula
- Formula required
- converting to a range. This must be simple!!
- List every combination
- extact number from number and text value
- Password protection-specific
- conditional formatting help
- VBA to Open File to Directory
- Change path of source file for pivot ?
- User Form: text box value problem
- If,and statment help
- Entering data in tabular form
- Turning Off 'Save as Webpage'
- UserForm Label colour
- Copy Data by Latest Date
- Formulas Across Tabs & Percentages
- Remove ListBox item, delete cell, move cells up?
- Center Across Selection & Merge and Center
- Turn of Alerts and Screen Updating
- Excel 2007 Pivot Tables problem
- Macro for Consolidation
- VBA - cell with DDE link
- Macro crashes too many records?
- Excel 2003 menu in 2007
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.