View Full Version : Excel Help
- [SOLVED] How to define range based on the value of another cell
- Check if labels are visible
- [SOLVED] copy multiple rows of numbers to new location on same sheet.
- 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
- 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
- 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
- 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
- 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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.