View Full Version : Excel Help
- Help needed for creating Dynamic Oracle Query using Excel VBA and Forms (8 replies)
- [SOLVED:] lookup formula with multiple criteria (2 replies)
- returning value of data validation (6 replies)
- Cell Colouring in VBA (9 replies)
- Convert formula's cell reference into value (5 replies)
- Why cannot run the code (1 replies)
- Identify timezone and convert time to other timezone (19 replies)
- [SOLVED:] Finding a date without a search (13 replies)
- VB looking at excel file to move files (11 replies)
- Folder Access (6 replies)
- Help with Date Picker 6.0?? (3 replies)
- Need help with Loop?? (1 replies)
- Code Security (COM Add-In? .xll? What to do?) (5 replies)
- Excel Timestamp format editing (1 replies)
- [SOLVED:] Insert a Hyphen at two characters from the end of a String (2 replies)
- Vba to move columns with certain headers (6 replies)
- changing Listbox based on an other combobox (12 replies)
- Macro that generates new worksheet with a dependent worksheet name (1 replies)
- [SOLVED:] Transpose data from row into columns based upon certain criteria (15 replies)
- Vlookup Dynamic Criteria (7 replies)
- Shifting and combining columns using VBA (2 replies)
- [SOLVED:] How to replace the FileSearch application in Excel 2010 (3 replies)
- Connect to Oracle with Excel VBA and store results of query? (2 replies)
- conect 3 tabales in Table4 in diferent worckbook (0 replies)
- [SOLVED:] Run-time Error 5 "Invalid Procedure Call or Argument" (4 replies)
- [SOLVED:] Edit Listbox Items (2 replies)
- [SOLVED:] Create copy of WB (2 replies)
- [SOLVED:] Show and Hide a UserForm using a String as the UserForm Name (16 replies)
- vba script to convert datetime string to date format (18 replies)
- Load Formula from another sheet (2 replies)
- [SOLVED:] pass two workbooks into sub module (2 replies)
- VBA Autofill Method of Range Class Failed (3 replies)
- [SOLVED:] Combining multiple range as target cell (3 replies)
- VBA Dynamic Ranges & Sheet Formatting (2 replies)
- Loop through columns and vlookup (1 replies)
- Macro that generates new work sheet with people and tasks they perform (6 replies)
- [SOLVED:] Populate Hyperlinks in ListBox (4 replies)
- [SOLVED:] VBA Paste Cells With Specific Text String to Specific Sheet (11 replies)
- Rolling Calculation (8 replies)
- VBA Dynamic Named Ranges & Page Formatting (4 replies)
- MAX date problem (5 replies)
- Close active workbook if multiple workbooks are open/ close excel if only one open (4 replies)
- Help making my search look in 2 sheets? (1 replies)
- VBA code to open IE in non-protected mode (0 replies)
- VBA Variant Array issues with Excel (2 replies)
- [SOLVED:] Maximum and minimum tide levels for every day (8 replies)
- Macro to paste on a hidden sheet (3 replies)
- [SOLVED:] Query doesn't work in Excel 2010 (13 replies)
- VBA Compile Error: Ambiguous name detected (2 replies)
- Need Help with a Looping Issue (4 replies)
- Setcell to blank if results of a formula are null, based on checkbox conditition (3 replies)
- worksheet function match syntax issue (3 replies)
- vba to run a macro on multiple excel files in a folder (5 replies)
- VBA Copy and Paste data to another sheet(with a date and day)? (3 replies)
- Best Way to Create Options Menu for an add-in? (5 replies)
- time calculation formula (8 replies)
- Sleeper: Save sheet as csv to specific network folder (1 replies)
- Highlighting, freezing and scrolling (1 replies)
- Is there a before_insert_row event? (6 replies)
- Confirm Message Before Deleting Rows (1 replies)
- [SLEEPER:] Need help with Inputbox function and If Statement (7 replies)
- Copy cell contents to another sheet at a particular cell address (0 replies)
- VBA Code to move files to another folder (13 replies)
- [SOLVED:] List cells containing references to files, i.e. containing formulas with broken links (29 replies)
- Insert Rows based on 2 Criteria (1 replies)
- Column headers throws errors (10 replies)
- VBA - MouseMove Event Code to Display Text after Hovering (5 replies)
- VBA: How to search new sheet for a defined variable, then copy values back to sheet (1 replies)
- Help with a VBA macro - merge multiple workbooks in one workbook with source names (2 replies)
- Copy Rows based on 1 criteria showing in Multiple columns (1 replies)
- Move cursor to image named material and then go to sub menu Material AVaialbility (3 replies)
- Highlighting Repeating Number Pairs (20 replies)
- [SOLVED:] Copy Excel range & paste in PPT as [Pastespecial - M.O. Excel Worksheet(Code) Object] (14 replies)
- Deleting Rows using VBA macro (2 replies)
- .xla Add-In Mechanics and Custom Ribbon Creation (3 replies)
- Enter text base on cell value/text referencing a dynamic list (3 replies)
- Pairing Co-ordinates (1 replies)
- Copy cell content and and paste to specific cell as a comment. (2 replies)
- #Value Error Using UDF Within Worksheet (8 replies)
- help to Copy symbols indicators as per range parameter set. (12 replies)
- Custom function help (Probably just me being stupid!) (5 replies)
- VBA Sum If Calculation (19 replies)
- Excel 2010 Print Blank Page (1 replies)
- Open word document (5 replies)
- Alternative to Application.Ontime (3 replies)
- Format from last Row Up (3 replies)
- Printing Embedded PDFs from Excel Workbook (2 replies)
- Asking for a different sheet name if current input already exists (1 replies)
- fill range based on Month (9 replies)
- Active Cell Address move to left when enter key is Enter (0 replies)
- [SOLVED:] Understanding the Syntax of Hyperlinks.Add (6 replies)
- Login into a website through Excel (2 replies)
- clearing ranges from COPIED sheet (2 replies)
- Lotus Notes Mailbox Size/Quota from Excel VBA (1 replies)
- Trouble with calculations in Excel table (3 replies)
- VBA Comparison between 2 sheets that return a 3rd sheet with differences (1 replies)
- xlRepairFile (3 replies)
- Code to unprotect wbaproject (4 replies)
- [SOLVED:] multi-VLOOKUP From an Array in VBA (3 replies)
- Highlight a specfic column when spread sheet opens (5 replies)
- Need Help with calculating an array of numbers... (6 replies)
- Excel Property Window While Saving (6 replies)
- help with complicated formula (60 replies)
- Deselecting a single pivot table item which is referenced in a specific cell (0 replies)
- [SOLVED:] Export worksheet to new workbook and restore original sheet (3 replies)
- Create Unique Values List From Named Range (4 replies)
- [SOLVED:] GoalSeek by VBA (4 replies)
- Duplicate data sets multiple times in VBA (7 replies)
- VBA Set cell value under last row (2 replies)
- looking help (4 replies)
- Date -> numeric translation issue (5 replies)
- Auto Name a workbook (13 replies)
- New to VBA, trouble with an If Else Then statement (4 replies)
- Need Some Change In Count Macro Running Code (3 replies)
- Create sheet if it doesn't exist problem (7 replies)
- Formulate average count of DISTINCT records (4 replies)
- Export array values to Excel (10 replies)
- Refresh data in closed excel workbook (3 replies)
- VBA to auto-add rows to 3 Tables (or one and auto-resize 2) (1 replies)
- Excel VBA macros - webquery (12 replies)
- How to extract filename from a folder which is on a netwrok drive (6 replies)
- VBA code to open folders and pdf file inside the folders (32 replies)
- VBA export of specific rows (4 replies)
- Uncheck Chckbox in Protected Sheet (2 replies)
- Find Duplicates and Highlight Row in Red (4 replies)
- How to best count? (8 replies)
- Operation with dates (6 replies)
- Consolidate Data Using VBA (7 replies)
- Save text file as unicode from Excel VBA (2 replies)
- Check for a condition in a Do Unil Loop (9 replies)
- Cells(x,x) = 1 ? (6 replies)
- VBA Code - Autofill with a Dynamic Range (7 replies)
- SUMPRODUCT double counting (1 replies)
- non vba save as dialogue box (2 replies)
- footer (3 replies)
- Query SQL through VBA (2 replies)
- Initializing a userform from another userform? (8 replies)
- VBA CODE - SEARCH AND COPY (8 replies)
- Add Dynamic Option and loop to my code (1 replies)
- Save Breakpoints (1 replies)
- Solved: Range("FilterArea") (1 replies)
- Any suggestions on making this code faster (1 replies)
- Scrape data from website to excel - VBA (0 replies)
- Solved: Call CMD.EXE and send instructions (5 replies)
- Compare & Fill Data Help Needed ! (27 replies)
- Solved: Help transfer from Multi Column ComboBox to worksheet non ajacent columns (7 replies)
- Excel, VBA, Send Email (1 replies)
- VBA on a MAC (4 replies)
- Macro Speed Up - Help (9 replies)
- Counting Unique Values across multiple rows (2 replies)
- Solved: Save As Web Page plz plz help (2 replies)
- on each page, highlight the first cell on column A (8 replies)
- Application Defined or Object Defined Error (3 replies)
- VBA OF EMAIL FROM EXCEL (2 replies)
- Compare, Match And Copy Data Row (23 replies)
- Solved: Learning! (2 replies)
- Solved: Automatically Open Files On Folder Select (8 replies)
- Autimatize worksheet names (3 replies)
- vba code import table excel to mysql (51 replies)
- Hostname to IP (1 replies)
- Sorting an array from small to large with an error twist! (5 replies)
- Conditionally Format cells in a row based on the sum of the previous nth cells. (15 replies)
- Automated Macros (5 replies)
- [SOLVED:] Need Help About Check Boxes (8 replies)
- Check SharePoint if file exists (2 replies)
- Lost on VBA HELP! (1 replies)
- Compile Error Variable Not Defined (2 replies)
- Import several text files into an excel file with macro (6 replies)
- Need to create VBA to transfer data in between workbooks (1 replies)
- Using Excel Solver (0 replies)
- Histogram help (1 replies)
- Split worksheet into multiple tabs (10 replies)
- [SLEEPER:] Pasting data from Excel into multiple Notepad Sessions (6 replies)
- Working with three workbooks (4 replies)
- Solved: Overflow Error in Code (3 replies)
- Solved: Finding a variable cell on another sheet for a formula (12 replies)
- Help transfer from ListBox to worksheet non ajacent columns (5 replies)
- Help Building A Fully Functioning Excel Add-In (1 replies)
- Solved: Code for Protecting a Specific Sheet in a Workbook with a Password on Exit (4 replies)
- Solved: Cut data before first space (13 replies)
- [SOLVED:] Export to PP (3 replies)
- Trying to copy paste and delete a row (20 replies)
- VBA to extract data from file in use (5 replies)
- Problem in replacing macro (5 replies)
- Importing data from a website into Excel (1 replies)
- pulling data from multiple sheet on to one sheet with specific value (3 replies)
- Solved: can I change some options when using PrintForm !!!! (6 replies)
- Solved: Rainflow Three-Point Algorithm (10 replies)
- Solved: Using Statemant CASE to delete rows in multiple sheets (15 replies)
- Problems with merge fields (8 replies)
- Solved: Skip cells (4 replies)
- Solved: VBA, checkbox, reporting and sum (5 replies)
- Extract Data From Alibaba Website (4 replies)
- by click on cell of column a the color of row change (3 replies)
- Solved: Change/Update Defined Names 'Ranges' (multiple) in Name Manager (9 replies)
- graph /objects protection/unprotect (3 replies)
- Worksheet entry help (3 replies)
- time and date in the excel cell (5 replies)
- Using Index Match, adding to the bottom of the row those that are missing (1 replies)
- Solved: Option to extend trend line on graph (1 replies)
- Solved: Inserting cell value in formula (6 replies)
- Solved: VBA issue (2 replies)
- Solved: Date Format (4 replies)
- Retrieve data from Access (1 replies)
- Manipilating an ASCII string in VBA (1 replies)
- Solved: Using VBA to Log In Members with a Username and Password stored within the Workbook. (10 replies)
- Download Data From Internet using Excel macro (5 replies)
- Value field appearing above row labels pivot table (2 replies)
- book (4 replies)
- Histograms in excel 2013 (1 replies)
- Code to automatically add new email address to a table (1 replies)
- Save Excel to PDF one page wide (4 replies)
- VBA export of cells with variable range (1 replies)
- Solved: Sum unique values in a range (9 replies)
- Code for not add the data in Sheet2 if all cells in range in Sheet1 are not filled (1 replies)
- Working with text for a report (5 replies)
- animated chart (1 replies)
- Who has a file open on SharePoint (0 replies)
- [SOLVED:] Check for presence of VBA Procedure in all modules (4 replies)
- VBA - PIVOT RELATIONSHIPS (1 replies)
- Cashflow Present Value Calculation (2 replies)
- Two doubts on some (i think) simple codes (10 replies)
- Solved: Delete a six-row block which occurs every n rows (5 replies)
- Solved: Continue Macro after Error Handler (4 replies)
- Help - Automate Pivot Filter Changes (2 replies)
- [SLEEPER:] Pulling custom footer from another sheet, to only appear on *final* page (8 replies)
- Solved: Lock Cells (Excel 2010) (5 replies)
- Solved: Pull data from other sheets (6 replies)
- Solved: Storing Values/Data beyond a subroutine (13 replies)
- Solved: Removing a item from a listbox (5 replies)
- Solved: Send Data to different workbook (2 replies)
- Finding data in a range (6 replies)
- Problem with IE automation - getElementsByTagName (0 replies)
- Function to Return an Array (8 replies)
- Loop to combine data in 2 columns and insert string every 145 combinations (1 replies)
- SUM variable range LOOP (9 replies)
- Load text files to ONE sheet (1 replies)
- How to write a vba code (9 replies)
- Conditional Paste (2 replies)
- Solved: Help Importing multiple XML files - VBA (9 replies)
- How to find exact substring within a cell (2 replies)
- Loop through files in a directory and delete if not currently in use (19 replies)
- Solved: Use Index, Match, and Max VBA (1 replies)
- How to count number of red color in a row (32 replies)
- Axis Rounding (decimals, tens, hundreds, etc.) (0 replies)
- Solved: match 2 columns and display 3rd column value (2 replies)
- Solved: Dir function skipping the first file (4 replies)
- HELP! (11 replies)
- WHATS IT TAKE TO GET A ANSWER (5 replies)
- Solved: Sum a column B where column A is the same in two different sheets (8 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.