View Full Version : Excel Help
- How to transfer data from an array to a matrix? (2 replies)
- VBA Code Help Needed (0 replies)
- ".findformat.font.Italic=false" code needed (10 replies)
- VBA Macro Named Pipe IPC (1 replies)
- Insert row with template row of formulas (3 replies)
- Trying to reference a range of cells inside of a table and call a function OnChange (1 replies)
- If conditions are met, copy to new worksheet (4 replies)
- Copy data from one workbook to another using VBA (3 replies)
- Copy Paste Shapes from one worksheet to another using Clipboard - Excel VBA (4 replies)
- Macro toggle button (4 replies)
- Automatically fill calender (1 replies)
- Reveal all matches with FIND function (2 replies)
- [SOLVED:] Applying conditional formatting on range of criteria dependent cells (6 replies)
- [SOLVED:] VBA code for vlookup in multiple worksheets (2 replies)
- [SOLVED:] Week number instead of Day Dates (2 replies)
- List Files (Specific File Type) from Folder & Sub-folders to Excel w/ VBA (0 replies)
- Converting DOS Commands to VBA Function (2 replies)
- Cell Address Goal Seek (0 replies)
- [SOLVED:] Seek matching text in cells and if match found enter info in third cell (2 replies)
- VBA Code needed. if more than 90 days, Message Box Expired, Elseif still valid (0 replies)
- [SOLVED:] VBA code to prompt message " file in use" please wait (5 replies)
- Find and Replace not working (0 replies)
- VBA: Export to PDF combination of cells (0 replies)
- Formula for sale (0 replies)
- I need VBA code (5 replies)
- Lookup a date range by Matching a column data set in a table & fetch respective data (0 replies)
- [SOLVED:] byref argument type mismatch (1 replies)
- Case with boolean (2 replies)
- [SOLVED:] Why does my Array only fill half way? (5 replies)
- Changing first name to initial only, adding second initial and combining repeats (3 replies)
- [SOLVED:] Data type mismatch with VBA Range.Copy & Range.PasteSpecial (2 replies)
- [SOLVED:] Keep 1 Record every 5 duplicate (4 replies)
- [SOLVED:] Use a variable for subroutine name (6 replies)
- Auto copy and paste query table (0 replies)
- VBA macro to copy from various sheet to a new file (1 replies)
- [SOLVED:] Declaring a variable using part of a filepath name (3 replies)
- Noob to vba - loop not looking at all (2 replies)
- Help?! Run-time error 6 overflow (6 replies)
- Speed Up VBA Macro (2 replies)
- [SOLVED:] Modifying existing form - how to add date picker (11 replies)
- Seperate Data by trade ID and Date (0 replies)
- Seeking help to make cell ranges dynamic (4 replies)
- [SOLVED:] VBA function - Inputting multiple cells instead of a complete range of cells? (5 replies)
- VBA Printing only columns with data (0 replies)
- vba excel macro for print button (1 replies)
- Looping Through Pivot Items (0 replies)
- Ensure that only unique values are extracted (2 replies)
- Search and Extract related data from TXT file and append into Excel (3 replies)
- [SOLVED:] Embedded Templates (12 replies)
- [SOLVED:] Editing part of a string (2 replies)
- Combining Multiple Worksheets with Same Table Headers (3 replies)
- Sleeper: Macro to compare two workbook (3 replies)
- EXCEL syntax isue (2 replies)
- Select cells with input box and unlock them in a protected worksheet (15 replies)
- [SOLVED:] Using Structured Cell References (4 replies)
- Selecting Pivot Table Range with Dynamic Data (1 replies)
- Extract Crossing new Sheet (2 replies)
- vba Help - extract Matching value (3 replies)
- Out of memory - find and replace part of hyperlink (0 replies)
- If Pivot Item = "" then skip (0 replies)
- adjusting code calling data in worksheet (3 replies)
- Import data to excel (0 replies)
- URGENT HELP PLEASE Copying same data to multiple rows (0 replies)
- [SOLVED:] Loop a sort function (2 replies)
- VBA to check if cell changed (1 replies)
- [SOLVED:] Single column into matrix (2 replies)
- Resizing a table to size 1 row (7 replies)
- VBA form question (6 replies)
- Sleeper: Trying to Sort "Multiple Rows" together (2 replies)
- Changing column types (1 replies)
- Caculate From One Cell & a Dimension Table (1 replies)
- [SOLVED:] Filling one Cell from another Cell (3 replies)
- [SOLVED:] Merge multiple Excel files into ONE WORKSHEET (14 replies)
- How can I modify this code to use a cell value when naming the new workbooks? (1 replies)
- COUNTIF Column based in VBA (1 replies)
- Automatically updating date cell unless row is blank (2 replies)
- Extract unique values from column based on criteria (0 replies)
- MACRO/VBA - Extract unique values to different worksheet that meets a criteria (0 replies)
- VBA - capacity smoothing (4 replies)
- Using Index Match with an unknown range (5 replies)
- [SOLVED:] A Class Module to store Images from a folder for later reuse in Workbook Excel VBA (31 replies)
- VBA to compare values in 2 cells and post a value in another (1 replies)
- Importing Images/Pictures/Shapes from a Closed Excel Workbook (12 replies)
- Sleeper: Overcoming ADO Recordset 64 Characters limitation for Fields (13 replies)
- VBA Pasting values to different cells in the same named range (7 replies)
- How can I write VBA macro for bchain() and bdh()? (3 replies)
- PDF creating and past copy different folder (0 replies)
- Remove "Filters" from Macro Script (2 replies)
- [SOLVED:] VBA Conditional formatting - multiple adjacent cells if specific text on left (10 replies)
- Parse rows to sheets (1 replies)
- [SOLVED:] AverageIfs to compare AM vs PM hours (4 replies)
- Macro IF statements (1 replies)
- [SOLVED:] IF Statement using VBA (5 replies)
- Copy cell data from one protected file to another (1 replies)
- [SOLVED:] sort data within the same cell (1 replies)
- Setting Linked cell to another work sheet (6 replies)
- VBA userform listbox - hard set range to specific sheet (2 replies)
- Make code more variable (8 replies)
- [SOLVED:] Match Error 2042 (1 replies)
- Export pivot table to individual PDF (2 replies)
- Question about clear, clear contents (11 replies)
- Reference to Lists in another workbook (1 replies)
- [SOLVED:] VBA coding for Excel problem (4 replies)
- [SOLVED:] Worksheet_BeforeDoubleClick (1 replies)
- [SOLVED:] Create a border around a range for specific criteria (3 replies)
- Help reversing calculations. (2 replies)
- Removing parts before each item (4 replies)
- [SOLVED:] VBA Input Box (6 replies)
- how to lookup combo box into textbox in excel VBA (3 replies)
- [SOLVED:] Parent / Child Relationships (7 replies)
- Pasting range from Source ab to Destination tab based on name (4 replies)
- Conditional Outline Borders Based on Criteria (4 replies)
- VLookup Duplicating Data (2 replies)
- vba adding up time with spin control & text box with userfirendly output (4 replies)
- adjusting code search by combobox (3 replies)
- I need VBA for my work. Thanks for all helps (0 replies)
- [SOLVED:] Macro Run-time Error '1004' Application-defined or object-defined error (4 replies)
- when importing data VBA code changes values of the original book (8 replies)
- VBA Looking for a Better solution than iCol for next loop (3 replies)
- If condition is not met, go back to start of code VBA (7 replies)
- Workbook.BeforeSave Event on Mac Office (1 replies)
- Group of Functions (1 replies)
- In VBA transfer data from one spreadsheet to another based on new date (1 replies)
- [SOLVED:] Error: Application-defined or object-defined when trying to hide row (1 replies)
- search by header column in VBA and copy corresponding column (12 replies)
- [SOLVED:] Converting Tables Into ListObject (5 replies)
- VBA for consolidating data without duplicates (0 replies)
- [SOLVED:] Go To Next Filter (13 replies)
- Loop through a collection of controls (6 replies)
- move to end of the procedure (11 replies)
- how to check if already exist in db (1 replies)
- When would you execute doevents more than once? (3 replies)
- [SOLVED:] Formula help (25 replies)
- [SOLVED:] Excel Formula to Link Totals from Newly Created Tabs to Summary Sheet (1 replies)
- Vlookup open file on background (5 replies)
- userform textbox save file path in cell as hyperlink (3 replies)
- [SOLVED:] PivotTable.DrillDown and filtering the output based on target column data type (11 replies)
- [SOLVED:] Pull Latitude from XML and keep Double (3 replies)
- userform comobox question (1 replies)
- Using Solver with a macro (0 replies)
- VBA: search for multiple words (3 replies)
- [SOLVED:] Multiple Filters of Pivot Table (30 replies)
- How to switch between worksheets while VBA is running? (5 replies)
- Issue with VBS - wscript and saving multiple files (0 replies)
- [SOLVED:] VBA code for consolidating/transf data from multiple worksheets in one Template sheet (5 replies)
- Autofilter List Exists (1 replies)
- MACRO filter column based on reference criteria copy, paste and repeat (9 replies)
- Merge cells based on the cell value updated on other column (1 replies)
- Renaming Worksheets Using VBA (3 replies)
- Word recovery and mapping vba (2 replies)
- help with vba loop inside listbox & search value (3 replies)
- excel vba to outlook email (1 replies)
- Adding message and loop to input box password (2 replies)
- Leading zeroes depending on file name (0 replies)
- Fill in the data with date range (0 replies)
- Conditional Format (0 replies)
- Copy certain cells to new sheet based upon a different cell? (4 replies)
- [SOLVED:] Compare 2 columns from separate sheets and create new sheet with data from both (1 replies)
- Finding a value in my table (4 replies)
- [SOLVED:] Auto unformatting of output filename with leading zeroes (1 replies)
- [SOLVED:] Compound interest rate with leap year (16 replies)
- [SLEEPER:] TextBox SetFocus Problem on UserForm (3 replies)
- Page setup when selected items are sent to print Preview (1 replies)
- Live data output (1 replies)
- VBA userform output storing number as text (1 replies)
- [SOLVED:] Flashing cell (5 replies)
- [SOLVED:] Help with Formula (14 replies)
- [SOLVED:] Listbox Selection not working with 1 result (2 replies)
- [SOLVED:] Timestamp difference in Millisecond (3 replies)
- VBA - what is Chr(1) (5 replies)
- Image viewer with images control (4 replies)
- [SOLVED:] Unique values from dynamic list (3 replies)
- DTPicker select date to display in Text box (1 replies)
- [SOLVED:] looping from one worksheet to the next fails (2 replies)
- If condition for check all the rows (3 replies)
- Dashbored where he take stairs (4 replies)
- [SOLVED:] DataPoint = NormInv(rand(), MeanNow, 1#) fails in VBA (4 replies)
- please help in vba macro--Compare and merge data given in parent child hierarchy (1 replies)
- Stuck with block if without end if, totally lost. (3 replies)
- Reverse date Import from .csv file (6 replies)
- [SOLVED:] Find - replace (19 replies)
- Can't open new workbook (3 replies)
- [SOLVED:] Copy userform info to worksheet row based on 2 criteria (2 replies)
- [SOLVED:] Macro to clear data but keep formula (2 replies)
- Using userform VBA to create a list (5 replies)
- Using Hyperlink to open a hidden sheet - not working (0 replies)
- [SOLVED:] Custom Ribbon Add Additional Tab (10 replies)
- Excel VBA - Copying to specific column (1 replies)
- [SOLVED:] Creating Array from cells givin error " Subscript out of range" (3 replies)
- Touch Screen Programming (1 replies)
- [SOLVED:] Range A1 notation (6 replies)
- Excel Hide - Unhide Columns With Userform (0 replies)
- Grouping - VBA (0 replies)
- Variation on dynamic Linked Cells code (2 replies)
- [SOLVED:] Listbox export (8 replies)
- [SOLVED:] VBA loop formula explanation? (1 replies)
- [SOLVED:] Excel VBA MsgBox NOT closing (4 replies)
- 2 different lists (3 replies)
- [SOLVED:] VBA Copy Paste Formula (3 replies)
- Using Excel VBA Get the "Page Number" of Table current cells in Winword. (2 replies)
- [SOLVED:] Help Debugging Short VBA Formula (2 replies)
- Excel vba crashes? (5 replies)
- [SOLVED:] Recalculate the cells in a column to achieve a set SUM value (4 replies)
- [SOLVED:] Extract Multiple Rows into a Limited Template based on Multiple Criterias (3 replies)
- Help with hiding rows based on content of a cell (0 replies)
- VBA help, export from Excel to text file, insert delimiter (17 replies)
- Lock cells and paste values based on a cell value (0 replies)
- [SOLVED:] Moving Rows (4 replies)
- [SOLVED:] Question about excel instances locked down if spreadsheet hidden while using a form (2 replies)
- Get Msgbox in a table (5 replies)
- [SOLVED:] VBA code excel (10 replies)
- Creating Multiple Tables Using Loop in VBA. I still want to add new sheets and add (103 replies)
- Best Approach to Do This Report (10 replies)
- VBA Help - Avoid triggering a Change Event on Delete (2 replies)
- Issue with code to check whether an excel file is open or not (0 replies)
- Data copy from other sheet based on cell value (1 replies)
- Drop down list without blank cell (3 replies)
- Delete the list from UserForm (0 replies)
- [SOLVED:] Export Multiple wbk (10 replies)
- ClearingContents in ranges that don't intersect (10 replies)
- Sleeper: Cascade String concatenation problem (2 replies)
- Batch script for inputting data into cells (5 replies)
- VBA search function (4 replies)
- VBA Replace From Code to Range (7 replies)
- Excel formula help match (4 replies)
- Form Close (1 replies)
- VBA That Will Group Specific Blank Rows (8 replies)
- [SOLVED:] Removing duplicate from keywords (10 replies)
- Change first letter of word to uppercase (4 replies)
- [SOLVED:] Parenting Calendar in excel exported to CSV for import into google calendar (6 replies)
- importing sheet from another file - issue with data validation (1 replies)
- [SOLVED:] VBA to calculate TOTAL based on condition (2 replies)
- [SOLVED:] setting a cell to a formula (3 replies)
- Excel Vlookup and multiple search results (1 replies)
- [SOLVED:] Remove Header / Footer from files in folder (2 replies)
- [SOLVED:] VBA to insert blank rows based on conditions (2 replies)
- [SOLVED:] Get data in various cells based on a cell value from another sheet (2 replies)
- [SOLVED:] struggling with vbYes and vbNo coding (2 replies)
- Store in DataBase (29 replies)
- [SOLVED:] Data uploading from userform to excel when "No" is selected in msgbox (3 replies)
- [SOLVED:] Replacing drop downs by two multichoice listboxes to copy&paste in between sheets (3 replies)
- [SOLVED:] VBA copy / paste to the next specific row (2 replies)
- tracking worksheet changes over multiple columns (1 replies)
- [SOLVED:] CTRL + Shift + Down in a Macro (29 replies)
- [SOLVED:] select data using drop down list (6 replies)
- Fetching data in various cells based on on one cell (2 replies)
- cumulative sum between two dates (1 replies)
- Sleeper: How to calculate Volume Weighted Average Price (VWAP) of all relevant deals (2 replies)
- [SOLVED:] Good way to mark a textbox so users know it is required to fill (5 replies)
- VBA Update from Excel to SQL Table Contents. (3 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.