View Full Version : Excel Help
- Replacing Text evenly from 1 sheet to another sheet
- Formatting table in worksheet
- [SOLVED:] Bold First Name in a VBA generated Email
- [SOLVED:] Convert text in alphanumeric string to lower case
- [SOLVED:] Returning an element from an array of subclasses
- Control Panel using a userfom and hide workbook
- How to rename a bunch of files in the same folder using an Excel VBA code?
- Import HTML Data into excel
- [SOLVED:] COUNTIF code then insert copied cells
- [SOLVED:] listbox1 to listbox2
- [SOLVED:] Issue with button
- [SOLVED:] Why are my formulas changing automatically?
- [SOLVED:] Non Regular Sequential Numbering
- [SOLVED:] Outcome is not as expected - code might be wrong
- VBA To search for a WorksheetSheet and a Column in that sheet.
- Excel charts as jpgs to specific powerpoint
- help creating a repricing tool with defined parameters
- email automation
- Mail Merge Excel however instead of Print Need save as
- ID matching with Name and sub six hours work time calculation
- [SOLVED:] Copy row data from one workbook to another based on row header name
- vba - copy workbook 300 times once user selects folder
- [SOLVED:] Line Break Validation
- Pull Date by Criteria for Visible cells only
- Office Automation: Excel executng Word VBA
- Paste column format only through iteration
- VBA event to detect an Autofill Scrolling?
- [SOLVED:] Using concatenate to reference a named range
- [VBA] set range find() -> finds wrong value
- Iterate 2 dropdown lists and move to all the new tabs to new workbook
- Save Active Word Doc with URL File Path
- [SOLVED:] Split First, Middle and Last Name
- Finding the last modified date of an excel sheet
- Avoid code repetition by calling the common code from another sub
- Dsum and Data Tables
- [SOLVED:] Looping through a Range of Data
- [SOLVED:] Loop through all Pivot tables in a worksheet and filter visability VBA
- VBA Code problem for Excel 2016 on a mac
- [SOLVED:] lookup formula to sum percent
- VBA Code to attach (multiple) file(s)
- Minimize-Maximize-Resizing-Scrolling in a Userform
- [SOLVED:] how to loop search to show multiple entries in listbox
- What am I doing wrong here?
- [SOLVED:] Range of inputs and graphing of result
- VBA Code running in f8 but not f5
- [SOLVED:] Dim problem
- [SOLVED:] Remove duplicates (runtime error 5)
- [SOLVED:] automated data query
- [SOLVED:] Sum Values Assigned to a Name
- Copy data from multiple single-worksheet workbooks into another workbook
- [SOLVED:] Loop to copy and paste first cell of repeated values
- Loop for substitution
- Combine Data in Mutiple Columns into Rows
- Sheet_change is not worked
- Extract single row from multiple workbooks
- [SOLVED:] Return Multiple Listbox Selection
- Need help with Timesheet Workbook I know exactly what I need !
- [SOLVED:] Create outlook appointementes only on "check" rows
- macro to send multiple emails with all attachements from specific folder
- my excel vba stop running when i run the userform and not responding
- [SLEEPER:] Loading a txt file into excel win works fine. Loading txt on a mac doesn't work.
- copy and paste a certain number of times
- Vlook from Closed workbook taking a lot time
- what is wrong with my update button code excel vba
- [SOLVED:] Validate cells in column A with info from other columns
- Improve efficiency of VBA Code
- [SOLVED:] Getting Run Time Error 5 on String?
- Returning the Caption Property for active controls in an email body
- search for multiple value using FORMS
- VBA_Pivot table capture in array and reapply
- [SOLVED:] Concatenation with double quotes and comma for the selected list of values
- [SLEEPER:] How to get data from an array table with two different values
- Need help moving many fields of data from the master sheet to several other sheets
- [SOLVED:] Error Handling (runtime error 1004)
- Filter the entries of Combobox
- [SOLVED:] Excel 2010 run time error 91': Object variable or with block ...
- [SOLVED:] Arrangement of values in groups
- Performing count and max commands on multiple groups of rows
- [SOLVED:] Validation Code Problem
- It is possible deleting rows in lisboxt datagrid with active sheets displayed vba exc
- Outlook vba help - Folder Picker
- [SOLVED:] VBA-split data into multiple worksheets based on column
- it is possible to save individual sheets as a separate file?
- How to Merge Cells Specially
- [SOLVED:] Help to faster this script for moving Duplicates
- How to speed up VBA Code
- VBA - Set data list
- [SOLVED:] Split Cells into rows but with two columns
- INDEX MATCH in VBA over different data files
- VBA to copy a new sheet based on active sheet
- [SOLVED:] Color cells from previous colored cells in different column
- [SOLVED:] Showing two expected values together with an IF function
- Restoring default Styles in Excel
- [SOLVED:] MS MapPoint and MS Excel, plot latitude and longitude on a map
- Type missmatch error
- [SOLVED:] Array of Email Addresses
- Find empty cell in one spreadsheet and then paste information from another
- Array match Only 1 RedimPreserve
- Replace text in email body from the excel
- VBA for designing your sheet
- xlsm file opens and immediately closes
- VBA code for conditional cell merging
- Run-time error 438: Object doesn't support this property or method (VBA), Office 2010
- SUMPRODUCT with additional sums/ adds
- [SOLVED:] Conditional Statements & Nested If/Then in VBA
- [SOLVED:] Copy and Paste Problem
- VBA Question
- [SOLVED:] Need help figuring out what went wrong
- VBA Code-csv file into excel- from general to text
- VBACode to show autofilter criteria just show result as <>, even though filter is set
- Insert Vba macro to Sheet 3 using another macro.
- How to run external software run multiple files after each other using VBA (in Excel)
- macro to extract specific data from text file to excel sheet
- Array Question - basic
- Detecting Barcode Scanner input vs input by hand
- Allocating buyers based on expertise and performance
- Edit to "colour to chart" macro - to cycle through workbook
- Counting Used Rows In Column - Best Method?
- [SOLVED:] Formula returning false when it shouldn't
- [SOLVED:] Help with equation that has several inputs which vary in value.
- Excel 2016 Crashes
- [SOLVED:] Send all files in folder vba
- Filtering numbers according to certain ratios
- VBA SUM Formula help
- [SOLVED:] VBA/Excel change value of a cell in multiple worksheets from a range in another workb
- VBA Help needed
- SaveAs to SharePoint not working in Excel 2013
- [SOLVED:] VBA Userform using Danish CPR Numbers
- [SOLVED:] Color Coding Stops After I get to # 65,282
- VBA help loop until & IF formula
- How to make multiple, non adjacent cells hidden based on cell value code
- [SOLVED:] Array Output
- Excel-How to concatenate data in multiple dynamic number of rows and multiple columns
- Public Variable won't pass
- Komplex If-Loop
- [SOLVED:] MoveAfterReturnDirection
- [SOLVED:] VBA exel programming: how to make a automatically filled up by filling up other cell
- Help with IE Button Click - SHDocVw
- Save textbox to specific cell based on combobox seletection
- [SOLVED:] How to do loop in the function?
- Dependent between 2 dropdown columns
- Paste from Clipbaord
- Stock Locator Inventory System-Issue with locator
- Listbox not showing Data
- [SOLVED:] Having trouble with renaming files in subfolders of subfolders
- [SOLVED:] Select row based on multiple textbox values
- Excel Userform DatePicker Default Format to be Blank
- Traverse all images in workbook
- Forecasting
- Distribute Numbers Evenly, With Conditions
- VBA - Export as PDF and overwrite existing PDFs
- Copy multiple workbooks & multiple sheets into single workbook with multiple sheets
- [SOLVED:] Adjust/Sync Table columns number Base on a Pivot Table Columns Size
- [SOLVED:] VBA - Copy with validatation
- [SOLVED:] Gradual Zoom?
- [SOLVED:] Copy data block from one workbook to another .. should be easy
- Security
- [SOLVED:] Dependencies and Dates
- Merge duplicates with cell color
- [SOLVED:] Automatically group the cell based on the words that appear in it
- click button via vba
- Check Values in Array for Matches
- [SOLVED:] VBA Help please - Find First Row of Data?
- [SOLVED:] VBA Loop
- input box to define formulas contraints
- Send Email separating by specific recipient
- Need Excel VBA help to loop in folder, execute several tasks and save filesAs
- [SOLVED:] VBA Code Modifcation To Insert a New Row and Fill out with Data As Per Existing Code
- clearing data using range(cells)
- [SOLVED:] PRINT EMAILS WHERE SUBJECT MATCHES CELLS IN EXCEL
- Summary of cash book day wise
- Excel VBA - Check excel file names and change if necessary
- [SOLVED:] Create a new function to find a date or next date on a selected range
- [SOLVED:] Excel VBA help....please :)
- [SOLVED:] Variable Not Defined, Excel 2013 & 2007
- How to compare different values either by formula or vba
- How to return entire output from Array to Excel sheet in one go
- Update value in a column from another worksheet depending on the date in a range
- VBA Coloring Cells Based on Value
- VBA for printing files listed in excel
- Perform Sum in vba code
- Prining from VBA not coming out in the correct size, please help me
- [SOLVED:] Copy and paste total row with engineer name and headings to a new worksheet
- Refer to a cell in another worksheet (macro)
- VBA - open corrupted file - excel 2010
- Sharing Interest Dynamically
- Aktivate/ deactivate check box
- Add a Calculated filed in pivot table to calculate percentage of adjacent column
- Auto fill from multiple rows & cells
- [SOLVED:] Please Help. Rank Formula Macro
- [SOLVED:] VBA code for sum function for filtered columns
- Summing up values in label captions
- How to split categorical data in Excel
- [SOLVED:] Macro to skip rows that have blank cells
- Spllit the data customer wise and email id should come in A1 Column.
- Using the Custom UI to create a custom ribbon Addin for Excel
- formula help
- [SOLVED:] Timed Message Boxes not handling code in between
- [SOLVED:] Brining in 2 inputs incrementally & 3 others from lists.
- VBA to email each sheet in a workbook
- Help with date and time formats
- VBA for AUDITING
- [SOLVED:] Problem with Userform input to Worksheet (Excel 2013)
- Prevent Blank Rows When applying filters
- [SOLVED:] How to DIM script itself?
- [SOLVED:] Help with solving a maze in VBA Excel
- [SOLVED:] if not found record after 1st criterial in Advanced Filter - then move to next if
- VBA to email each sheet in a workbook
- [SOLVED:] Copy from Excel to Powerpoint to create a report
- [SOLVED:] Deleting multiple cells based on value found
- VBA to copy / autofill data, where am i going wrong?
- Excel 2016 VBA Error 400
- [SOLVED:] Hidden Object Range Failure in Worksheet Calculate
- [SOLVED:] overflow error in range.find
- counts ships between instances of picked number
- Lock ComboBox/ MsgBox as Error
- Quick Question (hopefully) - Possible to create a front sheet for analysing data?
- proper variable type
- [SOLVED:] Consolidating data from multiple workbooks with varying ranges
- [SOLVED:] VBA Dir and HTTP Directories Equivalent
- VBA SQL Query from Cell
- Same Userform, Different Lines
- Multiple Linear Progression, logging and VBA
- Excel Clarification
- Market- making algorithm
- SUMPRODUCT formula does not add up negative numbers.
- Conditional Formatting with Multiple Criteria
- Excel Userform - how can I send an HTML email using data from the userform with image
- VLookup
- Transferring Data between sheets to main record sheet.
- Data Tabulation
- code for sum function
- [SOLVED:] Sorting by custom aplphabet
- File renaming
- [SOLVED:] IF-ElseIF-Else macro seems to be disconnected
- VBA Loop on Overly Coded Macro
- Else without If Problem
- [SOLVED:] TextBox - Named Range Dynamic Search
- Programming Scroll Button on Mouse
- [SOLVED:] Show Random Numbers Looping on a UserForm
- VBA to carry out Simpson's Rule for Tabulated (Equispaced) Data
- excel vba change cell color based on a number value in a range
- [SOLVED:] VBA Error run time 1004: Application-defined or object-defined error
- [SLEEPER:] Makes bold a chosen word in a cell
- [SOLVED:] TMP file not found error when creating multiple workbooks in a loop
- VBA Combining Data from Multiple Workbook into One - Need help ASAP
- Split cells data in below rows with other data.
- Application.Goto not working in immediate window
- MultiPage - Run-time error 35788:
- Macro to open workbook copy data from workbook 1 and paste in workbook 2 and repeat.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.