View Full Version : Excel Help
- Sleeper: Copying a Value to an Addess Reference which is Nested in Another Cell (8 replies)
- [SOLVED:] Calculating between 2 worksheets (7 replies)
- [SOLVED:] How to remove rows based on filters? (5 replies)
- Excel VBA problem on application.inputbox that returns range (4 replies)
- [SOLVED:] VBA - hiding column based on value of cell (2 replies)
- [SOLVED:] adjusting code search files into folder and sub folder (22 replies)
- Filter based on two columns (2 replies)
- Total dummy when it comes to VBA, so hoping someone can help! (15 replies)
- Calendar to bring the Leave Type from Leave Data to Calendar (3 replies)
- [SLEEPER:] Last update field formula on Google sheet (1 replies)
- VBA - Count # of cells in Column B that are greater in value than in Column A (2 replies)
- [SOLVED:] Value from UserForm to Worksheet - Accounting format - (How to?) (8 replies)
- find replace (5 replies)
- Hundreds of sheets, trying to loop through and extract specific columns (12 replies)
- Need help to Code VBA using the combination of text and date format (2 replies)
- [SOLVED:] How to copy the most current file from one folder to another (5 replies)
- text in cell in condition (1 replies)
- Put NA on cells with dates before indicated start week (5 replies)
- Insert new row for breakdown detail data (1 replies)
- CommandButton1_automatically update the date in ("A") column (3 replies)
- Finding Keywords from Text String - Formula (3 replies)
- [SOLVED:] if cell value in range = "code" then copy paste value to last used row another sheet (17 replies)
- fixing show message when open workbook from dialog to copy data (6 replies)
- [SOLVED:] VBA error: Run time error "424":Object require(pull data from HTML Element) (2 replies)
- Hilbert Curve VBA (1 replies)
- [SOLVED:] RE: VBA auto filter Iterate through each criteria (1 replies)
- [SOLVED:] Sorting one Column in a Table (9 replies)
- Maximum Limit for MMULT() (4 replies)
- Sum function in other sheet (3 replies)
- How to a reference to a new sheet in same workbook (4 replies)
- Listbox and name manager comparison (2 replies)
- Arrays in VBA errors (2 replies)
- Searching for Macro (5 replies)
- Userform problem : makes excel crash (2 replies)
- [SOLVED:] Userform textbox skipped in tab order after re-enabling - unwanted behaviour (8 replies)
- [SOLVED:] ComboBox Function Lost (6 replies)
- Target cell vs specific cell (1 replies)
- Link organs in an array to shapes as they are created (0 replies)
- [SOLVED:] Loop through UserForm Controls and perform Different actions depending on ... (9 replies)
- vba help - to make sumifs formula dynamic (0 replies)
- Move files from different folders to single folder and delete the original files (5 replies)
- [SOLVED:] Display count of months in year which has 31 days in Message Box (3 replies)
- Excel 2007 VBA: Having trouble ungrouping a newly loaded object (9 replies)
- VBA Code will not update as target cell is updated using a formula (3 replies)
- [SOLVED:] VBA progress bar help (5 replies)
- Set statement (4 replies)
- copy paste the data if condition matches (0 replies)
- Cant get VBA Code to work. Would appreciate help. (7 replies)
- Need help with Objective Type questions (Quiz) (3 replies)
- AutoFill Only Specific Cells (0 replies)
- Select last empty row with header (3 replies)
- split counting (4 replies)
- Using Find function in VBA (7 replies)
- Getting Key value from last occurrence of another table (5 replies)
- Deleting Duplicates based on Active condition (1 replies)
- Copy specific data from a row based on value in column A (6 replies)
- Use VBA code in a locked worksheet (3 replies)
- refreshing sheet "under" modally shown useform (3 replies)
- [SOLVED:] Check if Value Exists in Another Sheet (6 replies)
- [SOLVED:] Formulas: If(AND( , OR(NOT(COUNTIF now working correctly (6 replies)
- inputbox vs excel shift + space shortcut (2 replies)
- [SOLVED:] Clear all items in listbox column (2 replies)
- [SOLVED:] Excel 2007: Trying to change images' rotation after loading without selecting first (4 replies)
- copy and paste value with condition (7 replies)
- Help with vba chart (0 replies)
- [SOLVED:] VBA 2007: How to get object name when inserted in order to delete later (14 replies)
- copy and rename a folder and its contents based on a cell value. (2 replies)
- VBA multiple SQL queries (2 replies)
- Data separation (9 replies)
- [SOLVED:] Excel filter not working due to blank values in the column (3 replies)
- [SOLVED:] COPY/PASTE SPECIFIC DATA INTO GROUPS ON NEW SHEET (4 replies)
- Macro Undo Command (9 replies)
- Chart legend entries delete reappear (0 replies)
- Click Login button using VBA (0 replies)
- Replace kill command with save command and be able to format date (0 replies)
- Import .txt File with normal Space Delimiters (9 replies)
- Filter Specific data (0 replies)
- [SOLVED:] Master file detail list (5 replies)
- Revising A VBA Code (1 replies)
- Generate Condition CSV File (2 replies)
- [SOLVED:] Invalid picture (0 replies)
- Reading text files and assigning values (2 replies)
- [SLEEPER:] VBA Macro to add values by date (2 replies)
- Improve Efficiency of VBA Code (21 replies)
- [SOLVED:] Change Excel's own user forms, is it possible? (2 replies)
- Save multiple ListBoxes to PDF (3 replies)
- [SOLVED:] Automatic Timestamp Insertion Application.Undo (3 replies)
- RC FORMULA HELP (2 replies)
- HELP with Conditional VLOOKUP (1 replies)
- Excel chart links in office 2007 (0 replies)
- Decipher Macro (1 replies)
- Sleeper: Gantt...mouse over (0 replies)
- How to Copy-Paste from a dynamic range to fixed one based on cell value using VBA? (3 replies)
- Making new EXCEL file with value only by copy from other excel (3 replies)
- export and print multipe specific sheets as pdf (15 replies)
- get Sunday's date between 2 dates (2 replies)
- Command button to go to another sheet with drop button click (1 replies)
- [SOLVED:] vba code for an interface (4 replies)
- Applying VBA code written in module to all sheets in workbook (3 replies)
- Computing Monthly Weighted Average (10 replies)
- Header/Footer sticking to other ranges (1 replies)
- Save As function randomly replaces my file path, Error 1004 (4 replies)
- Worksheet Change event not working unless cell is manually changed (1 replies)
- Simple If Statement: Comparing function argument (1 replies)
- Workbook.SaveAs function, appends number to similar named files (1 replies)
- [SOLVED:] error on Password User form by workbook Entry (9 replies)
- Creating a Pivot Table Based on Two Tables (2 replies)
- Return specific cell in that row using row number (3 replies)
- [SOLVED:] loop and sum (8 replies)
- [SOLVED:] Changing Data Layout Excel VBA (2 replies)
- [SOLVED:] Searchable listbox - Multi column - additem to second column only works first time (5 replies)
- PDF Merger Sequence (0 replies)
- Vba, How can code the excel file to save as only and disable to save directly file (2 replies)
- Macro works via step through but does not on button click (2 replies)
- Getting selected items in embedded listbox (3 replies)
- [SOLVED:] Progress Bar VBA (24 replies)
- [SOLVED:] simple password protection with User Form, with possibility user can change Passwort. (0 replies)
- Importing files will format data (5 replies)
- VBA - Search For Value Across Multiple Worksheets (83 replies)
- Using userforms (14 replies)
- [SOLVED:] Delete worksheet activex listbox (12 replies)
- Problem comparing dates in VBA (1 replies)
- Graphical hiearchy (7 replies)
- Calendar with userform input stores irrelevant data to its table (5 replies)
- Sorting Help (2 replies)
- [SOLVED:] Conditional Formatting on a table based on a different table VBA (16 replies)
- [SOLVED:] VBA - Disable/ activate command button depending on Text box value (3 replies)
- [SOLVED:] Delete rows when copying table (7 replies)
- [SOLVED:] Ordering worksheet tabs in a specific order (6 replies)
- VBA to make formula for parent child (7 replies)
- User Form (2 replies)
- Rename the add-in caption on menu bar (0 replies)
- [SOLVED:] Get All Most Recent Dates per Month in a Single Column VBA (16 replies)
- [SOLVED:] Loop through listbox to insert to sheet (6 replies)
- I need help on scrolling down web pages through vba query tables (0 replies)
- [SOLVED:] PIVOT TABLE TROUBLES - Code runs on one workbook but not the other (2 replies)
- Sleeper: Importing multiple files to excel (0 replies)
- VBA Newbie looking for linear or polynomial fit to missing dats (19 replies)
- [SOLVED:] find listbox column Average (2 replies)
- [SOLVED:] sum digits (9 replies)
- [SOLVED:] update listbox (4 replies)
- PDF to excel (1 replies)
- [SOLVED:] Issue creating pivot table from table data (2 replies)
- [SOLVED:] Autofit last column in a table (6 replies)
- VBA Help using value in sheet 1 to hide unhide row in sheet 2 (9 replies)
- [SOLVED:] Excel - Edit contents of a string (7 replies)
- [SOLVED:] Excel - Make user opened file the active workbook (13 replies)
- [SOLVED:] select next emtpy column (10 replies)
- [SOLVED:] Find Last Value (not first) (9 replies)
- [SOLVED:] Hide specific rows in various worksheets depending on Summary worksheet cell value (3 replies)
- Duplicate Values in Data Validation (7 replies)
- VBA Pasting from table to different sheets without using sheets("x").Select HELP!!! (3 replies)
- Building up sentence variable within cells (4 replies)
- [SOLVED:] concatenate variable values (1 replies)
- [SOLVED:] Hide textbox with selected item in combobox (5 replies)
- 3 Reference Formulas Not Returning a Result (14 replies)
- Hyperlink warning message (9 replies)
- [SOLVED:] Complete data of a master table without overwriting given data (12 replies)
- Text in textbox only updates once (1 replies)
- [SOLVED:] How to set currency with different starting values (68 replies)
- Writing array to sheet (10 replies)
- After clicking the linked cell to move back linked cell without using F5+Enter (2 replies)
- Split comma to rows (15 replies)
- [SOLVED:] Insert Picture from Directory on Cell Value Changed by Formula (20 replies)
- VBA script to search a text in google maps (0 replies)
- Add Table to Data Model (Pivot Table) (0 replies)
- Trim rows in multiple sheets (2 replies)
- Conditional Formatting using formula as condition (4 replies)
- [SOLVED:] How to pull XML data into another excel sheet using VBA? (54 replies)
- Cut Data Once It Has Been Selected (3 replies)
- [SOLVED:] index/match based on variable range (2 replies)
- [SOLVED:] Change font size of rows in a range with bold letters (20 replies)
- [SOLVED:] Data Validation based on Condition(s) in Excel VBA (15 replies)
- [SOLVED:] Write part of 2D Array to Sheet (3 replies)
- [SOLVED:] Putting a time limit on QueryTable.Refresh (1 replies)
- [SOLVED:] Part of a string (7 replies)
- [SOLVED:] Formula to fill down used range (5 replies)
- Only the string (3 replies)
- [SOLVED:] Excel Formula to compare between actual values and target values (3 replies)
- sumifs filtered data (4 replies)
- Basic VBA Function to calculate the volume of a cone (5 replies)
- [SOLVED:] Split Cell into multiple column via VBA (8 replies)
- [SOLVED:] Excel keeps calculating (3 replies)
- [SOLVED:] Creating a single Table with different formulas Excel VBA (78 replies)
- [SOLVED:] Copy files by name from a folder to another (5 replies)
- code running on more than 1 sheet (2 replies)
- Copy to new workbook and remove blank rows (1 replies)
- VBA to add numbers in columns from various workbooks (11 replies)
- Macro to autofilter data from several sheets in workbook and copy to new worksheet (1 replies)
- Set Last Modified date & time to preset value on Save or Save As (9 replies)
- VBA MACRO Button click using a class instead of ID (4 replies)
- Creating dynamic List on Workbook Startup (13 replies)
- Run time error '1004' Cannot access 'Macroed-Upload_Temp.xlsx' (0 replies)
- For Each Then Next (5 replies)
- Coming to the dark Side (25 replies)
- [SOLVED:] First Login Last Logout - Formula (2 replies)
- Looping Through Two Columns (9 replies)
- vba find the latest date and a corresponding value (7 replies)
- [SOLVED:] VBA to select cell in active row (14 replies)
- Vba code on looping (0 replies)
- [SOLVED:] Macro Copy & Paste: Numeric to Alphanumeric (3 replies)
- [Beginner] Select and Cut with conditions (1 replies)
- Copy & Paste to the next empy cell. (Vba Code not Working) (1 replies)
- How to get dates of all mondays between 2 dates? (5 replies)
- copy and paste question (46 replies)
- How to copy and insert shapes with increase in series of text inside of shape ie 1,2, (2 replies)
- [SOLVED:] Moving data between two sheets VBA (26 replies)
- When changing the active worksheet - need VBA that will make it's chart display? (5 replies)
- [SOLVED:] Combine countifs & Subtotal (5 replies)
- [SOLVED:] Need help copying cells from one sheet to another.. (41 replies)
- [SOLVED:] notification by vba (4 replies)
- Customer Statement of Account (3 replies)
- VBA for New Format (0 replies)
- [SOLVED:] insert data for open positions (4 replies)
- [SOLVED:] Advance filtering unique records (5 replies)
- VBA for inserting Rows with conditions (4 replies)
- Early vs. Late Binding (4 replies)
- from mastersheet to other sheets (find the last blank raw) (3 replies)
- [SOLVED:] Conditional expression (3 replies)
- Having troubles with XlFillDefault (4 replies)
- [SOLVED:] Create new column (4 replies)
- Help automatically refreshing a year using VBA (7 replies)
- [SOLVED:] Formatting issues (29 replies)
- Consolidate Pivot Table Cache - VBA (1 replies)
- VBA to move JPGs from sub-folders to destination folder using a list (0 replies)
- Copy files from one Location to another (0 replies)
- Creating a Search Concat for Sharepoint files (0 replies)
- populate combo box with conditions (5 replies)
- VBA Code to highlight Odd and Even numbers (18 replies)
- Run macros on whole workbook (2 replies)
- Query (0 replies)
- Cell equal value new value of active cell which is a drop down (2 replies)
- [SOLVED:] Use the same Variable in the module (2 replies)
- On time assistance required (2 replies)
- Stop save if table has empty cells (3 replies)
- Parse text to array (7 replies)
- Sleeper: Keep a timestamped log when any worksheet is unprotected? (1 replies)
- [SOLVED:] Error 13 - Mismatch in UserForm update Application.Match with mixed Data (2 replies)
- [SOLVED:] Copy Workbook Name (7 replies)
- Cell back color (3 replies)
- [SOLVED:] Update Schedule Sheet with Jobs (1 replies)
- [SOLVED:] Named Ranges Error - Please help! (1 replies)
- VBA - Macro to open a file based on part of text in cell (15 replies)
- [SOLVED:] Conditional Format Calendar Events (1 replies)
- Advice on 'OnTime' (4 replies)
- Replace non-contiguous column range with Offset column range in Chart SeriesCollectio (0 replies)
- [SOLVED:] VBA entering a nested formula with text (4 replies)
- [SOLVED:] Calendar Times Not in Order (3 replies)
- Create an array removing duplicates from list but keeping last occurence (10 replies)
- HELP! Cant figure out how to modify code based on new requirement (3 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.