View Full Version : Excel Questions
- Unique Values
- Counting problems
- Polynomial estimates
- Replace values in a range dependent on a condition
- Vlookup?
- Joining cells and seperating by a colon
- How to copy summary info from excel into email automatically
- Sumproduct
- Excel to Access Database
- How can i?
- MACRO MAKE HYPERLINK
- Excel clock
- Sorting data with a MACRO
- Another worksheet lookup/sorting question
- Hide columns based on cell contents
- e-mail form excel useing IF formula
- CODE - Nested ifs.
- Ignore a cell/range when doing spell check
- Goal seek and DTPicker
- Data QueryTable question
- odbc...
- Copying cells without changing formulas
- copying conditional formats
- Personal.xls
- VBA Help
- Why isnt my update working?
- Closing a Web Page Using VBA
- Formula Help
- INDEX() function
- how to I use a formula to edit a broken descritption
- Serious Problem when creating hyperlinks
- How to highlight cells tha fit a specific criteria
- Return rightmost cells
- Disabling VBA code when saving workbook copy
- Charts turn grey when not selected
- Count how many times a macro has run?
- Email VBA
- Trouble with VLookUp
- Can this be done with a formula or function?
- Adding time to reflect Days:Hours:Mins
- Return value from sub
- Spell Checking in a Form in a Macro
- Autocalculation keeps flicking to manual
- if there is something in column A, then paste
- Use variable for range name
- Cell Reference
- COUNTIF - multiple conditions
- Fill Color
- Select Every Other Column
- Pivot Table with data coming from Access
- Help with a formula
- ran out of if's
- userform question
- Can you share a workbook using a macro?
- Searching array for value
- Easy question for you pro's
- Open specific worksheet in a workbook
- Hiding all impaired lines
- countif formula not working
- How do you activate a MACRO with a single LEFT_BUTTON click
- followhyperlink issue
- Look Up Rate Increases Based on Position and Service
- Countif two variables are true...
- line chart help
- If block for when filename is not found
- Searching workbooks
- Format imported Date from General to Date
- Resizing Namebox
- Calc Error
- Urgent: Put a specific data on a specific place
- problems with external database query
- If Block: Browse to and Open File
- Long saves
- Referencing every 5th cell in a row
- querying sql from VB - how to include a variable
- excel file stuck in a Find+Replace loop
- This is Perplexing - CONCATENATE Text and Values
- Comparing Mass Amounts of Values
- Problem with too many arguements ?
- save as dialogue form
- Help with Add-In file usage
- Resaving Excel File on Open
- How Can I automatically add a ; after contents in each cell
- Macro to Look For A Certain Value Then Delete Row With Value
- Format a cell when it is selected
- Removing References
- Looping through worksheets
- Autoformat every other row
- I give up and now....
- combining worksheets
- Consolidating timeseries data from sheets using date field
- Time calculation
- run macro w/o openning spread w/ macro
- Text Box reference a cell
- Variable R1C1
- Recover deleted sheet in workbook
- Finding a number within some text
- How to easily save invoices!?
- Advanced filtering buttons
- Help with open another Excel-file when UserForm is running.
- Help with open another Excel-file when UserForm is running.
- Differences in VBA code to control Word
- Ambitious Macro to email part of spreadsheet ???
- pivot table calculation
- Rank Closest to Nil
- disabling macros
- VBA to add word list to Custom Dictionary
- If Statement: Worksheet does not exist
- Set 'Now' in Macro Code to appear in Pacific Time
- Copy to first empty row (if only that easy)
- Problem with cell showing blank
- Problem with cell showing blank
- Help - More Inside
- macro to duplicate cell value with comma separator
- If Function on multiple cells one at a time
- Sorting IP Address's
- 0's
- Strikethrough
- copying certain rows to new worksheets by varied criteria
- Pivot Tables
- Problem with Automatically Updating Cell
- COUNTIF
- DateLastAccessed & DateLastModified
- Column Labels are wrong
- Easy one?
- Putting in a single quote within a string
- SUMPRODUCT Question
- Formatting Cells
- AVERAGE AGE FORMULA
- Bold one cell when another is Active
- Template and macro for merging workbooks?
- VBA- move column Z to column A?
- Having to run macro 2x to get it to complete?
- When I update a cell want to fire macro
- vbLf???????????
- Macro code to call up "Edit Links" Dialog Box
- xlCellTypeVisible not available in functions ??
- enhance Networkdays formula?
- File format is not valid
- pivot table combine data
- No active window appears with opening of file.
- Vlookup and match the last occurence
- Insert Copird Cells
- Data Manipulation of rows between two markers
- calc! function?
- troubleshooting formulas with named ranges
- Conditional formatting question
- Automated letters via excel data?
- Auto insert row
- Align a check box in a cell
- USING A DYNAMIC RANGE FOR RANGES THAT DONT INTERSECT
- Entering numbers into a cel with a formula Pt. 2
- Help with a VBA event
- Link to another workbook and sheet name.
- File saving problem
- vlookup across multiple tabs
- Nested IF
- Formatting Question
- changing cells by pressing F9
- VB
- Filtering
- creating a pop up Disclaimer window when I open a file-how?
- Complex Data Validation For Single Cell
- Please help with solution to this scenerio...
- Ideas to Streamline a Semi-Complex Macro?
- Combining/Merging Workbooks
- Pulling names for a Work Schedule
- Password protect all sheets in workbook, not whole workbook
- Need help modifying a code-DISREGARD,PROBLEM SOLVED
- Transpose
- BeforeClose function
- Automating the ending date
- error in code when dimming :).....solved....thanks :)
- Formula question...
- Shared workbooks
- Another quickie question
- PivotTable Integrity Problems
- Making a recorded macro available for all workbooks
- Macro Print Dialog box Code
- Req sum of values from Col B against multi values in Col A
- forumla question, availablity vs, requirement
- Help needed with macro!
- Download web data from website which contains drop down menu
- Display month i.e March = 3
- Loading custom toolbar, BUT delete it first
- Convert Text to Date
- Saving as CSV file
- Adding dates
- HELP needed for log sheet
- Custom bar chart
- Active Range? for selecting current pivot table
- file size too big with image
- Chart - line on 2 axes
- excel 200-macro for count
- LOOKUP in an un-ordered list
- Cutting, pasting & formatting in VBA via For..Next loop?
- VLOOKUP( - FIND A PARTICULAR CODE - (LARGE...
- Protect PivotTable but allow Filtering
- Retrieve absolute Top and Left of object
- How to count cells that contain part of a phrase
- Help needed - or pointers on how to solve this problem
- Round to nearest Million
- Copy Worksheet From One Workbook To Another Workbook
- Problem with dragging a formula- please help!
- VBa code for a range of commission
- CreateObject
- For Each loop help
- Countif Formula Question
- Macro Help Please
- Searching using multiple search keys
- count and match based on two conditions
- Automated Email based on date criteria
- Delete Entire Rows (with only single non-recurrent numbers)
- fuzzyvlookup/vlookup and Arrays
- 24 hour clock issues
- Edit Links via VBA
- How to Select lowest + highest value from a column of data ?
- Find and replace - * character
- Worksheet_change below seems to stop working
- Passing string variable to Userform button code...
- Creating a macro which searches a table after entering text
- Excel XP problems retaining changes to toolbar and formats
- Vlookup Multiple Data
- Run a query and macro when opening spreadsheet
- Copy contents of certain files from CD to Workbook
- how to populate a combobox?
- Sum Until Total Is Greater Than X, Then Identify Row #
- Need to insert copied line every 9 rows
- How do i type in negative time?
- Selection, conditional sumif? A Reconciliation problem
- Forms Combobox
- What is the difference Between Goal Seek and XIRR
- Excel chart re-size query
- Sumproduct problem...
- A challenge !!!!! This is driving me NUTS.....
- VBA for list of files
- Request- Need help in formatting a description
- Conditional Formatting #N/A
- Macro Help
- Lookup not working
- Userform Textbox validation
- ShowAllData
- Converting to date format
- Check if a cell has a formula.
- Von Pookie plz help, my file too big
- Having a brain cramp, how do I clear the copy scrolling marq
- Subtotal visible cells only with condition
- Where to place *C10 in this code?
- Hyperlinks - returning to originating page
- Asterisks in front of some numbers
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.