View Full Version : Excel Help
- [SOLVED:] Delete rows ONLY IF duplicate value in column A + cell is highlighted Specific Color.
- [SOLVED:] Count Cells by Color
- Maintain index table to show allocated numbers
- VBA substitute on Office RT?
- Data Picking and placing to appropriate cell
- [SOLVED:] Clean and Trim Text from Download
- Split cell contents
- Skipping Over If Statement
- xlSheetVeryHidden Does Not Work on Mac?
- Trouble with swimming time grading in excel
- Need help with creating references from one sheet to another in a more efficient way.
- Compare two columns varying in number of rows on different sheets
- Excell
- [SOLVED:] Find Hidden cells in array and enable "Calculate used range" on all non hidden cells
- Excel Formula to determine winning teams
- Two Sheets Exported to One File
- [SOLVED:] Pre Typed Text Box Appear After Macro is Executed
- Consolidating data
- Macro to save a readonly copy of file with todays date
- Click in Image with iframe
- Ranking and declaring winner and runner up
- Workday Friday changed to a Thursday
- Delete table rows from different worksheets in excel
- Date Data Tracking
- Tab behavior in user forms
- Macro Inserts Lines, but disturbs referencing cells
- run-time error 91
- Date Tracking NEW
- Is it possible to Insert Array into Excel Table
- How do I handle missing XML attributes?
- Calculate BOM levels with target price
- [SOLVED:] Selecting numeric data in range if they start with 2 specified numbers
- [SOLVED:] Entering a value to a range of cells which are -1 column from cells selected
- [SOLVED:] Select Cell X, Filter cell Y, if cell Y meets condition Z -> Input into cell X
- Excel traversing Array Uses lots of Memory
- Excel to Memories
- [SOLVED:] ADO Query of Excel Table is returning with incorrect Field Type
- [SOLVED:] Find text in Row and use as criteria for search in column where text is found
- vba to terminate Chrome Browser
- Run-time error 13 - type mismatch- simple price time series calc not working on array
- [SOLVED:] Cond Formatting
- [SOLVED:] code executing too fast?
- Export All Pictures in Spreadsheet as Filename in Cell Range
- [SOLVED:] Coordinate based query and data copy/paste/clear
- [SOLVED:] Run-time error '1004': Application-defined or object-defined error
- Combining duplicates based on several conditions
- Date Picker Issue
- Problem to calculate target price according to tree levels
- [SOLVED:] EOF question
- COUNTIF (unique values only)
- copying Data from multiple tabs of multiple files in master file
- [SLEEPER:] Keyboard shortcut to refresh the data in auto-filter column
- [SOLVED:] Mininum Maximum
- If then Else to fill blank cells
- Copy & Paste Based on Column Criteria
- VBA - Search Loop Help
- Code for linking multiple check boxes with If then statements
- How to generate Crystal Report (SAP BO BI) using Excel VBA?
- AHT Calculation
- Identify cell formula changes in VBA
- Loop through and ignore hidden rows
- VBA - struggling to calc and write StDev data into an array with a For Next loop
- Save/Retrieve Image from database using excel vba
- Fetching datas from different sheets onto one sheet
- Colour visible cells in a loop VBA
- [SOLVED:] Formula to return value in months in date range match
- VBA separate range of dates in cells with duration
- Return Color of Individual Characters in Cell
- [SOLVED:] Insert Row with formula on double click & delete last row within a defined Range
- Type Mismatch error because macro only applicable to .xls - files and not .csv
- How to bypass security warning sending emails from outlook using Excel VBA Code sampl
- [SOLVED:] Help to modify this lookup function
- [SOLVED:] Copy only borders of a range to new range
- VBA to send Email from other users on shared WB
- [SOLVED:] New Issue with SaveAs
- Amendment (With exception) on the the created vendor macro file
- VBA to change cell font if then not working
- [SOLVED:] PivotTable copy certain sections and paste to another sheet
- Error 438 in VBA
- [SOLVED:] Copy Paste Formula in alternate Rows without breaking link
- Completing Data / Interpolation
- Problem with conditional selection
- 3D garph help
- Why so hard to get a cell's formula dependents/precedents
- VBA Sharepoint Check out & Check in - Please help a newbie!!
- VBA - Hiding rows in worksheets with comments
- Filter/Sort looping issue
- [SOLVED:] Add "Print" button to my msg box
- Exit MsgBox If MsgBoxResult = Cancel
- VBA_ How to download .xls file (which is created from javascript) from website
- [SOLVED:] Lock sheet-macro
- Sine using Taylor Series
- [SOLVED:] VBA to select first cell with data in a row
- Double numbers
- Double Click to insert Row
- Index function skips value in table.
- [SOLVED:] Tricky COUNT(IF(S)) problem
- [SOLVED:] VBA creating, activating command buttons
- Mail Merge VBA + Excel + Word!?
- VBA help request: copy a range, add new data within the range and paste beneath data
- Get browser to update after changing drop down box value
- Menu shortcuts
- error msg box
- Loop Case Statement
- [SOLVED:] Time Format in a cell
- Adding Columns into Excel with a Macro
- [SOLVED:] VBA - Random Comparison Columns
- Finding the greater text value from several cells
- VBA Excel: How to create file which will be crashed on precise date
- Userform or InputBox appearing on screen connected via network
- can't find my mistake to calculate target price
- [SOLVED:] VBA Excel: Error 424 in "For Each" caused by FireEvent ("onchange")
- ByVal vs ByRef Question
- Convert excel data to fixed width text file
- [SOLVED:] VBA CheckBox issues
- [SOLVED:] Delete Rows Based ColA (multiple criteria)-Delete Rows based ColB (multiple criteria)
- [SOLVED:] VBA check box used to change color of a cell not working
- [SOLVED:] Extracting Last name, First Name and sometimes Middle Name
- click a button in a dropdown menu on webpage to download sth using vba
- Workbook open fail problem
- [SOLVED:] clear contents of adjacent cell(s) on change
- VBA macro to create pdf and folder based on cell values
- [SOLVED:] Macro that to transfer information sheets by product
- right-Click on image
- [SOLVED:] Array
- [SOLVED:] excel functions regarding text entries
- IF Statement that will assign account types based on "account number"
- [SOLVED:] VBA code to initiate search button on website
- Get all data from word table into excel
- [SOLVED:] Formula help please
- Insert file name and loop
- Looking to create a Outlook Task. Need VBA Template
- Sleeper: Select Case Statement Problem
- Remove line breaks
- Assign each trade a Trade ID
- [SOLVED:] How to make Excel file only open in Excel 2007
- [SOLVED:] I'm having trouble removing some shapes from my worksheet
- Using VBA to paste an Excel sheet as an image and keep conditional formatting
- [SOLVED:] VBA code to quickly change dates and times in comments
- Copy paste filtered range with criteria using VBA
- vba for when data is changed to remove item from data validation list in another wksh
- Error 13: Type Mismatch Row Limit Restriction?
- Insert Copied does not work when selecting Visible Cells Only
- [SOLVED:] COUNTIF - Alternate to count values in every third cell rather than full range.
- Duplicate Entire Row where Comma Exists
- HTTTP Post Request Help Needed
- Tracking tasks.
- [SOLVED:] Adding Sheets from array
- Toggle autofilter while sheet is protected
- VDA structure creating
- Saving Using Path Definition
- vba to send email at the end of the day.
- Get container and/or parent of dynamically created control (checkbox)
- Paste Excel Picture from Cell in to Word - Error 438
- Export Data from another program to excel
- Match duplicates and copy updated cells from one worksheet to another
- [SOLVED:] Merging PDFs Based on Checklist Selection in Excel
- Transferring Data from one Workbook to Another based on whether or not the cell is em
- Macro to Create Multiple Pivot Tables in Multiple Sheets with Dynamic Data Filter
- [SOLVED:] Avoiding run time error '424': object required
- [SOLVED:] How to add table in the outlook via excel.
- [SOLVED:] Excel 2010 Weekly Update Breaks Excel
- [SOLVED:] Custom Ribbon XML - Create a Dropdown with Additional SubMenu
- [SOLVED:] Shape selection based on user input
- Adding a common value to a column using VBA
- [SOLVED:] ActiveX button VBA references contents of button sheet even after activating new one
- [SOLVED:] Little help with VBA please and programming search in VBA
- [SOLVED:] Paste copied info one row down daily
- Create Check Box before running Macros
- [SOLVED:] Colours based on drop down
- [SOLVED:] Excel VBA to What If Test
- Sleeper: Excel SQL Query
- Sleeper: VBA assistance
- Excel VBA help! Duplicate orders with same customer ID totals?
- [SOLVED:] Access array between different modules
- Search column for text match, if found add text into row
- Consolidating Workbooks
- [SOLVED:] Copy all text on Sheet2 and paste to the Last unused row on Sheet1
- Show Item on special cell when click on each cell on column E
- Using ShowDetail Causes Un-Grouping
- Date type changing when moving cells from one sheet to another
- Which is the best tool to repair Excel?
- Shared workbook with specific sheets being read only if in use?
- Stop button from moving
- [SOLVED:] Run-time error '70': Permission denied ->when i run code
- [SOLVED:] Compare comma separated numbers
- VBA to Format Charts
- Automatic row addition
- Count button clicks and write them to a file or sheet with time and date index
- Special Characters
- Subtitle problem in embedded WMP control
- [SOLVED:] Object doesn't support this property or method
- Worksheet Sheet ActiveX Controls Command Buttons Stopped Don't Work Working
- Run-time error '5' : From Excel Macro to AutoCad
- [SOLVED:] Sorting by number of character in cell
- Running a Database Query
- [SOLVED:] Types of Data Distributions
- [SOLVED:] Need Code to copy Data to other sheets on condition
- [SOLVED:] Operation must use an updateable query
- vbCrLf and vbLf
- Ifs, ors, and nots
- A few questions about DoEvents
- [SOLVED:] Inserting a Row based on two conditions
- [SOLVED:] Run-time error 424 issue
- VBA Date Match Error
- [SOLVED:] Copy Table from one Sheet to Another
- [SOLVED:] Function that finds number of Fridays in a particular interval date
- Excel VBA to select first value in Validation list
- vba to send appointment from excel to outlook
- Runtime Errror 9 Subscript out of range
- [SOLVED:] Change tab color based on cell contents
- How to set 2 condition in VBA
- Customize Error bars individually in a dynamic timeline chart
- [SOLVED:] Problem with Deleting Select Legend Keys
- Line intersection - with a difference
- [SOLVED:] horizantal total
- How to add date column in workbook files
- DAYS360 in VBA
- VBA script to extract/reduce data to certain parameters(columns)
- Downlaod URL Data on disk based on criteria
- [SOLVED:] Copy & Paste Variable Range By Table Header
- [SOLVED:] Modify Code to Include More Columns
- [SOLVED:] Copying Row Above Results In Zero Instead of Blank
- [SOLVED:] Update data fill down dynamically
- [SOLVED:] Compile Errror: Can't Find Project or Library
- [SOLVED:] Sum if
- VBA for Row Difference
- How to use the path of an excel filevariable in a formula?
- Sleeper: Combo boxes stopped working
- follow hyperlink to location then delete linked file
- Use check button enable/disable code lines
- [SOLVED:] Sort blocks independently
- Create sheets using data shown in filter
- [SOLVED:] Improve Performance of Insert
- [SOLVED:] Change Cells color based on cell and other cells value.
- How to do web scraping from java based website
- How to save excel file in CSV with Comma delimited (*.csv)
- [SOLVED:] Checking cell format
- Uploading not working
- Freeze panes shifting on worksheet
- Copy row to a new sheet if a cell in the row meets criteria
- Unhide and Activate a Worksheet using Radio Button on UserFrom
- [SOLVED:] Need help removing unwanted commas that sometimes appear in rows in csv files
- Need to standardize 100s of excel files that have columns in the wrong order
- Just Hallo
- [SOLVED:] Random numbers with specific outcome
- [SOLVED:] Need Help on ADODB Query, need to convert field to int and order on it
- what's wrong with this code?
- Excel IF formula for birth date range
- [SOLVED:] Macro to take data from a file other than the current
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.