View Full Version : Excel Help
- EXPORTING DATA TO MS ACCESS FOR SIMULTANEOUS MULTI USER
- [SOLVED:] Part of a string
- [SOLVED:] Delete text line with specific word from multiline cell
- Search for a string in text files.
- Publish to Sharepoint
- [SOLVED:] Transferring selected cells to a new sheet
- Sleeper: AdvancedFilter - Unique Column 1, Greater than 0 Column 3
- Replacing Date with Period Based on Matrix
- auto fit cell height for merged cells in sheet that has protected (locked) cells
- Convert Binary to decimal on and vice versa on VBA
- Solver in Userform Linked in Excel
- Using non-contiguous ranges in Solver VBA
- Help VBA search
- [SOLVED:] Finding cells formatted with colour gradients of various colours
- Like expression with AND or OR
- Formula/vba - Summary Report without Pivot
- [SOLVED:] VBA - Filling Master Template
- Room Booking System
- [SLEEPER:] Combine multiple txt files
- [SOLVED:] How to Add Different Texts to End of Excel Cells Macro
- VBA - Collection help..
- Date Picker VBA that will work on all versions of excel
- Copying multiple text files into one excel but different tabs
- MISSING DATA IN EXPORTING CALCULATED QUERYTable FROM ACCESS TO EXCEL USING EXCEL ADO
- [SOLVED:] Pull rows from array given two conditions
- [SOLVED:] Run-time error '424': Object Required
- simple copy-past
- Subscript out of range error in VBA code
- Replacing multiple numerical values
- Insert a line break after word wrap
- newbie vba questions & help with posible loop for multiple cell values to sheet
- [SOLVED:] VBA- Variable declaration help
- VBA Array Help in filtering data with logic
- [SOLVED:] Combo Box Index select
- [SOLVED:] Combine common worksheet names when splitting a file
- [SOLVED:] Turning off alerts issue
- [SOLVED:] How to Copy Paste Symbols-Phonetics Data to Excel sheet?
- Range.Find Issues
- [SOLVED:] When you have one workbook, two windows, does any event happen closing second window?
- Is there any event allowing Cancel of closing a Window (not closing a Workbook)?
- Apply AutoFilter based on selected cell in another sheet
- Declared public variables have ceased to pick up values
- [SOLVED:] Copy and rename multiple sheets
- Excel 2016 Open Read Only file
- [SOLVED:] Interactive Way to Search Based on First Few Characters Typed
- [SOLVED:] Between two numbers
- [SOLVED:] Clear all textboxes except 1
- [SOLVED:] Copy value - Another Excel
- Splitting up a String
- Delete certain rows and highlight certain cells
- How to remove [TAG 001], [TAG 002], [TAG 003], etc from string
- Prepare hierarchical and non-numeric pivot tables in Excel
- Search string if it contains words from a range then replace with adjacent cell
- Inserting Recordeset into Access DB via VBE - Error operation must be an updatable...
- [SOLVED:] Sum values vba code
- Running macro on files in a folder: impossibly hard!
- Count only visible data after filtering
- VBA to perform lookup for individual lookup range
- [SOLVED:] Cannot show merged cells
- copy and change date
- [SOLVED:] Copy Data from worksheet to another one with VBA
- [SLEEPER:] Bad file name or number - Runtime Error 52
- [SOLVED:] Changing Column Headers
- VBA code: copy data from sheet and paste values onto another specidied workbook
- Get first and last dates (dd/mm/jj) from year range
- vba - Extract Unique values from Single Column via Colllection and Dictionary
- [SOLVED:] Data Conversion using Dynamic Multi-Dimensional Array
- [SOLVED:] Linking a commandbar button to a macro in an addin
- Macro for sorting by lot number, splitting table w/new header, then sort by due date
- [SOLVED:] Fill Column
- Array only returning first column of values
- [SOLVED:] Pass Params on Activate event
- easy VBA seek for help!
- Help with random selection and variable criteria
- Multiple Rowsource in combo box?
- pick a new interior color from an array when next color is needed
- [SOLVED:] How to fetch data from a excel table with multiple rows.
- [SOLVED:] Match FileNames and then Merge those PDFs
- Userform with listbox and checkboxes that finds values on a worksheet
- counting number of occurrence of a value and depositing that number in another column
- [SOLVED:] Refer to range in cell formula
- PLEASE HELP ME!!!
- Select Random cells from range
- Get name of procedure
- Reconciliation based on recurring values
- [SOLVED:] [R1C1] Formula with a loop index in VBA
- [SOLVED:] VBA code to set print preferences
- [SOLVED:] How to Selection.Insert Shift:=xlDown with keep destination formatting?
- [SOLVED:] SAVING RANGE AS PDF FOR MULTIPLE FILES
- [SOLVED:] Problem with hiding rows
- Multiple dropdown list
- Excel Sumproduct Count Blank Cell as well...
- Caption label
- Modify macro to output to Combobox
- Extract Items from String and then Sort
- Matching data from columns with offset multiple row data in other worksheet
- Cell content as part of filename
- Count colored cells in a range using columns and rows, output result
- VBA scrip to sort data inside sheet
- Number help
- [SOLVED:] Copy / Paste data ranges to specific locations
- application.run - return value byRef
- Control Tip Text
- [SOLVED:] How to get the first & last range value for this type of data...?
- Updating a Chart while VBA is running
- Copy Multiple Files from Absolute Paths to SharePoint with Same File Names
- VBA problem
- [SOLVED:] Copy and paste VBA
- [SOLVED:] VBA code for selecting data from statement to output sheet
- [SOLVED:] VBA Code to remove Data embedded in the "Pick From Drop Down List"
- [SOLVED:] Userform open from one worksheet and referencing another worksheet
- VBA code not working in 365
- Error Handling for InputBoxes
- Run-time error 438: Object doesn't support this property or method
- [SOLVED:] Copy .pdf files from one location to a new folder based on a list of cell
- [SOLVED:] VBA Code to add groupings to subtotals
- [SOLVED:] Need help with logic
- VBA Advanced filter help..... Criteria excluding a list
- [SOLVED:] BeforeSave and Userform: Issues with saving the excel file
- [SOLVED:] Multiple selections from drop down list
- On editing protected view programmatically , display setting are getting changed .
- VBA filter and cell formatting
- Copy data from one sheet to another sheet where the values are matching
- [SOLVED:] Help import from csv file
- Search data using Userform and then scroll through matching records
- VBA how to superscript characters in a string following an apostrophe?
- [SOLVED:] Declaring Variable Type - Excel 2013
- Export as CSV file
- User Form - Many Text Boxes - Restrict One Text Box with Password for Editing
- Loop through a folder and copy data from files to another WB
- Word file - filled using excel and send by email as attachment
- Why is my code showing error??
- [SOLVED:] VBA to replace previous table and check if one cells value is equal to the previous o
- Print to PDF file
- [SOLVED:] VBA Code to Run Code Across Multiple Worksheets at One Time
- Array issues - one vs two dimensional
- [SOLVED:] Excel VBA code to Delete 'Heading 1' from Word Document
- Excel to JSON -- bracketing
- Findvalue from 2 searchstrings
- VLOOKUP not working properly
- [SOLVED:] Use .Range("A1:A10000") to end of records?
- How can I control when and if my chart updates and not updates?
- My chart "hides" from view sometimes after running or when idle.
- Two userforms in one sheet
- [SOLVED:] Create a File list with metadata
- Filepath to reference cell value
- [SOLVED:] VLOOKUP Not Updating when Data Repeated
- Userform - Compile Error: Invalid qualifier
- [SOLVED:] Format transfer to sheet 2 after match in sheet1
- Creation of File list in a new Workbook
- [SOLVED:] Printout VBA
- [SOLVED:] VBA Code to stop loop if cell / range is blank
- Crank Nicholson
- Crank Nicholson Method
- [SOLVED:] 2 separate change events code issue (Floating Cmd Button & List box selection)
- Input user form to change cell value
- Excel help copy and paste from sheets then move to next row
- Formulas NameManager
- Excel vba merge cells based on duplicate cell data
- Transform data type in column
- VBA to Recalculate Grand Total
- Application.Match gives 'Type Mismatch' only on descending date values, match type=-1
- VBA Code to edit and update existing data
- [SOLVED:] Rename New Sheet?
- Macro to clear hidden contents based off other cell values
- Update Shared Spreadsheets
- Active X Textbox Content to Userform Textbox
- [SOLVED:] Button click to change shape color
- adjusted code show the data in listbox on userform
- VBA pivot table error 5
- Making 2 Dependent drop downs
- Skip blank from Auto Filter
- Runtime Error 438
- [SOLVED:] Excel Macro help - If target cell in range of cells.
- Code that detects data in cells and pastes data into the next cells
- User defined directory not working
- Flags on birthday calendar
- [SOLVED:] Produce parts list from breakdown
- VBA: Filtering for a date range from 2 ComboBoxes for dates
- [SOLVED:] Hyperlinks with changing Sheet Names
- Set Range Using a Function
- Importing pictures by directory string
- Debug stops running macro and will only continue in step mode
- autofit cell height for merged cells
- Search with Table
- Yearly Calendar Project
- Application.FileDialog clean up
- VBA Code to Loop and Calculate Subtotals with blank rows
- Backtesting futures using VBA
- conditional formatting help
- Filling ComboBox?
- [SOLVED:] VBA newcomer - help with IF to determine whether to run code
- Procedure too large error
- Data migration between tabs using VBA
- Search and Fill Listbox
- vba excel function return #VALUE!
- Copy Data from one Worksheet to Another
- Convert from range to tables and code support?
- [SOLVED:] Find and replace module help
- VBA Error When Add / Delete a Row
- How to Calculate Standard Dev without using the worksheet function in VBA
- [SOLVED:] Abbreviate the next succeeding instances of scientific names
- type mismatch error that i didn't get before
- subtract today's date from a date in another column
- Find cell matching text then get last row before blank
- [SLEEPER:] Case issue
- [SOLVED:] VBA macro code to expand a certain column
- [SOLVED:] Transfer data from Excel to double column of information in Word
- [SOLVED:] Vba Custom Format "0000" in File Name
- [SOLVED:] Excel VBA to read txt file, input all data into one cell
- VBA Update from Excel to SQL Table Contents.
- [SOLVED:] Good way to mark a textbox so users know it is required to fill
- Sleeper: How to calculate Volume Weighted Average Price (VWAP) of all relevant deals
- cumulative sum between two dates
- Fetching data in various cells based on on one cell
- [SOLVED:] select data using drop down list
- [SOLVED:] CTRL + Shift + Down in a Macro
- tracking worksheet changes over multiple columns
- [SOLVED:] VBA copy / paste to the next specific row
- [SOLVED:] Replacing drop downs by two multichoice listboxes to copy&paste in between sheets
- [SOLVED:] Data uploading from userform to excel when "No" is selected in msgbox
- Store in DataBase
- [SOLVED:] struggling with vbYes and vbNo coding
- [SOLVED:] Get data in various cells based on a cell value from another sheet
- [SOLVED:] VBA to insert blank rows based on conditions
- [SOLVED:] Remove Header / Footer from files in folder
- Excel Vlookup and multiple search results
- [SOLVED:] setting a cell to a formula
- [SOLVED:] VBA to calculate TOTAL based on condition
- importing sheet from another file - issue with data validation
- [SOLVED:] Parenting Calendar in excel exported to CSV for import into google calendar
- Change first letter of word to uppercase
- [SOLVED:] Removing duplicate from keywords
- VBA That Will Group Specific Blank Rows
- Form Close
- Excel formula help match
- VBA Replace From Code to Range
- VBA search function
- Batch script for inputting data into cells
- Sleeper: Cascade String concatenation problem
- ClearingContents in ranges that don't intersect
- [SOLVED:] Export Multiple wbk
- Delete the list from UserForm
- Drop down list without blank cell
- Data copy from other sheet based on cell value
- Issue with code to check whether an excel file is open or not
- VBA Help - Avoid triggering a Change Event on Delete
- Best Approach to Do This Report
- Creating Multiple Tables Using Loop in VBA. I still want to add new sheets and add
- [SOLVED:] VBA code excel
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.