View Full Version : Excel Help
- [SOLVED:] Function to list pdf files within a folder
- Special chars to UTF-8
- Update chart when adding new sheets of data
- VBA to delete first 3 characters and keep cell formatting
- assign a cell value to a variable vba loop
- Sleeper: Found connection problem when run VBA to direct connect Oracle Database
- [SOLVED:] sort and extract text to another excel file
- Update Cost on a smaller spreadsheet from costs on a larger spreadsheet.
- identifying duplicates on each row
- Activate this popup html
- Retrieve price from another wb instead of different sheet? code complete except exter
- [SOLVED:] Find text paste text in message box next cell
- Compare two sheets and exclude existing in the second sheet
- Need a macro for copy pasting with transpose
- [SOLVED:] Combine strings and place in separate sheet
- Copy & Paste
- [SOLVED:] VBA save as function as new workbook
- If cells starts with a number and exceeds a certain number of characters
- VBA: Counting an "if" loop to get average.
- [SOLVED:] PROCESSING External Excel Files
- [SOLVED:] Subscript out of range
- [SOLVED:] change word spacing in a messagbox
- Calculation incomplete message issues
- [SOLVED:] Conditional Formatting
- Generate workbook
- Unpivot data?
- [SOLVED:] Code runs when VBA Editor is open, but doesn't work when closed
- VBA Macro button to open a folder derived from the (partial) name in a selected cell
- Sum/ABS
- size of photo based on the height of row and make center based on the column width
- [SOLVED:] Find and Replace macro is not working
- VBA: Am i doing something wrong with While...wend?
- [SOLVED:] stripChar is not working
- macro to select different sheet tabs
- If Elseif to toggle
- Conbining IF Then Conditions in Excel
- convert date/number
- [SOLVED:] How to copy sheets from workbook to new open workbook and rename new workbook accordi
- [SOLVED:] Multiple buttons using a single macro
- Save Document's most recent version
- Studying VBA for Excel and getting frustrated by objects/properties...
- [SLEEPER:] Frightened to tunnel!
- [SOLVED:] Stuck with defining range for calculation
- [SOLVED:] Excel 4 Macro Page.Setup Error
- Macro to delete line in excel after third / sign.
- Help needed: Vlookup formula with a dynamic range
- [SOLVED:] Needs Help With Conditional Renaming for Several Tabs
- Need he;p with code error, .SaveAs
- [SOLVED:] STRUGGLING VLOOKUP in VBA
- Checking for multiple conditions
- Excel picture object chart paste in specific ppt as per slide name/number through VBA
- [SOLVED:] Needs Help With Calling All Tabs
- Needs help with VBA for 2 specifics detailed functions
- Pivot Table Filter Button - VBA HELP
- Excel Macro to copy data from a specified multiple ranges of a workbook to another wb
- Need help for copy columns to new sheet with new order and two or more criteria
- Helped Needed: Linear/nonlinear Optimization with Solver
- Problems writing data to worksheet
- [SOLVED:] how to remove saturday and sunday when calculating start dates
- Copy rows from Outlook to Excel
- Insert a picture in an multiple image control with one click based on dropdown list
- VBA code to copy data from one sheet and paste it in a specific location
- [SOLVED:] Highlight Duplicates
- [SOLVED:] VBA Page Break Issue
- VBA Lock rows upon checkbox click on multi-sheets
- [SOLVED:] Need advice with manuals and instructions
- Avoiding the DocumentsPane to show up on startup
- [SOLVED:] Need Help With Input Box To Open File in Specified Path
- [SOLVED:] Select Sheets Array If
- FSO Object used in VBA code?
- [SOLVED:] How to create a list out of wide table
- [SOLVED:] Switch between Putty and Xshell using same Loginbutton
- Run Regression on Filtered Data Set
- [SOLVED:] Needs Help With For Next Loop
- Combine Excel sheets w/ same name into one
- This code takes 5 seconds to run. Any suggestions on how to get that down to 3?
- [SOLVED:] Run-Time error when saving
- [SLEEPER:] Code retrives https:// in Windows Explorer instead of windows explorer drive
- [SOLVED:] Qucik help
- Need help combining multiple sheets into a single summary page
- restore workbook after Application.Visible = False
- Place formulae on each row where dates meet criteria
- How can I chart the moon data against the tide data
- [SOLVED:] Importing data from a MySQL database
- Need Help With Automating Data Validation Selection
- VBA to merge specific sheet of different workbooks into one multisheet master file
- Need help with VBA code for entering cell value based on another cell value
- Efficient coding with Loop
- Need Help - Find Variable Text from Cell B in Cell A, then Bold/Color.
- [SOLVED:] Format Cells based on start & end date!
- Calculate Percent Error
- Optimize macro performance
- Unmerge VBA with dates
- Could I have done this quicker?
- [SOLVED:] Format decimal places based on columns from same row
- How to analyze big data with Excel
- [SOLVED:] DATE DIFF function in years
- Sleeper: Matching Algorithm - Gale Shapley, Almost complete - Excel Matching
- Alternative for sendkey
- [SOLVED:] Shared excel userform
- [SOLVED:] Display MsgBox "Macro is running" when macro is running
- "orientaion" parameter in vba SORT
- [SOLVED:] Generate multiple TXTs files
- [SOLVED:] find/retrieve price from closed WB and copy to current workbook
- [SOLVED:] Need Help in making minor modification to an excel vba code.
- Help creating a file joining different other files
- copy and paste into next blank cell of table
- [SOLVED:] Range changes values unexpectedly as code executes
- Creating and Save new workbook based on cell value
- [SOLVED:] Excel and splwow64.exe issues
- [SOLVED:] Function in VBA (Excel) - Want a dynamic behavior depending on parameter
- [SOLVED:] Workbook open from specific folder
- Transpose Data Blocks To the Right
- select item with macro
- VBA code for determing if worksheets (OR) cells within a worksheets are protected?
- Method 'SaveAs' of object '_Workbook' failed
- [SOLVED:] VBA copy and paste Vlookup
- [SOLVED:] Need Help With Show/Hide Check Boxes
- [SOLVED:] Autofill Destination Offset
- [SOLVED:] Extract matching data values and copy to new location
- [SOLVED:] Subscript out of range problem
- Copy data from another worksheet if it doesn't exist in current worksheet
- VBA - Want to load Red colored text from a cell into an array
- [SOLVED:] Print Userform
- [SOLVED:] Highlight the first row in every data block
- [SOLVED:] Highlight duplicate data blocks
- Work hours between 2 dates(not working -VBA)
- [SOLVED:] VBA User Form To Select Column To Copy Cells Into If Destination Is Blank
- [SOLVED:] Coding Efficiency (2)
- Excel Table of Contents/Summary Help
- VBA code to determine if a specific excel-based tool is used as add-in and locked?
- How to copy an entire row from 1 sheet to another
- Subtotal at each PageBreak
- Help with VBA code in data entry form
- [SOLVED:] VBA to dynamically select EACH block/range of cells on a worksheet, then copy/paste?
- ICOLOR TAB
- Create Summary sheet from multiple tabs & run macro on certain tabs
- VBA to relocate XML blocks
- Modification of VBA code
- [SOLVED:] Find and Replace based on Selection only
- move files from one folder to another whose file names are listed in an excel file
- [SOLVED:] De-selecting cells after Paste
- ActiveX Combo Box and Pivot Table using Visual Basic Issue
- VBA code to generate report based on criteria
- [SOLVED:] Even Vectors - Panel Data
- Numbering a unique sort
- [SOLVED:] Renaming inserted Object
- Excel to Pdfs Not saving correctly
- How to correct this error
- Can I “include” another file or module in a sub or function?
- [SOLVED:] NEED A LOOP TO COPY DATA
- Get data from two worksheets using form
- [SOLVED:] Cell selection issue
- Adjust macro (problem)
- [SOLVED:] Database or object is read-only
- Hi , how to select sheets
- Isolating errors 2
- [SOLVED:] Copy/paste values in column if condition is met
- [SOLVED:] Save workbooksheet as .CSV with some variables
- [SOLVED:] How to modify this code to place the checkbox in the first cell of each column?
- Locking Cell Format
- [SOLVED:] Date filter in table
- Using Marlett for optional selections - multiple ranges
- Filter Pivot table by each customer and auto email invoices unpaid
- VBA for binking Text inside a Shape in Excel
- [SOLVED:] Need help with Macro VBA code in Excel
- How do I move files into latest created subfolder
- Sleeper: How do I break a link after saving to new workbook
- Skip heading rows with Range Offset
- [SOLVED:] Vba code to copy and paste dynamic range from mulitple workbooks to one workbook
- [SOLVED:] Message bar detection.
- Moving different rows data to one row based on criteria to optimise on printing
- Export Crystal Report to pdf
- [SOLVED:] Data Validation
- Minsweeper VBA code Problem
- Excel report generation and export to pdf
- Auto click OK button
- [SOLVED:] Help with macro to set vertical alignment in Excel without affecting text indents
- [SOLVED:] Spell Check in Excel-Auto Select First Recommendation Using VBA
- VBA: How to use listbox properly.
- Exporting an multidimensional array from an Ecxel file to a new Excel file (.xls)
- Still Stuck On A loop
- [SOLVED:] Optimizing Copying Sheets & Printing
- [SOLVED:] help for homework
- [SOLVED:] Function to get list of Excel files in a folder
- Converting Excel File to CSV
- [SOLVED:] Template
- Mails from excel
- [SLEEPER:] MonthView DatePicker default to current date
- [SOLVED:] using conditional format to change font if column has a number greater than or equal
- Copying real time data in excel using VBA
- convert gregorian date
- VBscript for data matching
- Condition should applied if columns total value is not match
- [SOLVED:] When stepping through, code doesn't stop after this "paste" command...why?
- [SOLVED:] Form selection
- Activate sheet which contains date
- Excel automation error on VBA Code modification using VBA
- [SOLVED:] Numbering Duplicates Consecutively
- VBA Copy Sheets to New Workbook
- VBA to save excel file (downloaded from server) to specific folder
- Code to detect duplicate cells in Excel
- VBA adding numbers up to a certain range
- Simple and Basic VBA question.
- VBA macro for dependents
- Linking multiple sheet columns into one master sheet column
- Format Column Labels
- Worksheet_Change ( No Responese )
- Table
- Change Color If Selected Cells Edited
- Looking for a free software/tool to perform analysis on excel data....
- VBA:Problem with DCOUNT + Problem while copying data from range to listbox
- Need help with INDIRECT formula
- [SOLVED:] Help to build a data collecti searching from many Workbooks
- [SOLVED:] Help needed resolving Compile Error: Expected End Sub issue
- Hiding and then Unhiding Rows on Excel sheet based on if a checkbox is unchecked?
- HELP! - Print All Options (Loop) On A Drop Down List after Refreshing Excel Add In
- Hiding columns based on cell values in column
- Rank for Top 5 after two criteria match excel formula
- "Run-Time Error 91" trying to run Login Code
- Write selected items on form to range
- Protect radio buttons on a sheet with VBA
- FILTER EXCEL PER COUNTRY & CREATE MULTIPLE WORKBOOKS
- Add and Sort
- Chart series don't extend
- Creating a VBA code for a cell with a dropdown list to allow multiple selections
- Assistance resolving Runtime 1004 error
- Multiple conditional formatting to the same range
- [SOLVED:] Using End(xlToLeft) in Sheets with Tables
- [SOLVED:] Stuck trying to figure out this macro
- Calendar userform ( datepicker )
- [SOLVED:] Execute Macro on Cell Change
- VBA Userform match issue
- vlookup separate workbooks and sum the results
- Nested if statement, loop or something else
- Sorting arrays
- [SOLVED:] VBA Copy & Paste Based on a Condition in Another Column
- [SOLVED:] For Loop goes thru all sheets but doesn't execute code?
- Double run problem
- Search multiple keywords to filter column
- [SOLVED:] In merged file, re-name sheets to include part of workbook name that they came from?
- [SOLVED:] if find specify word copy all the row to anther sheet
- Trying to replicate MAX function in SAS
- Speed up the loop process (Copy paste Value)
- [SOLVED:] Split text in different cells after each Dash
- Sorting table with Duplicates
- Slicer changing chart styles
- vba excel dir loosing file name in looping
- Excel Userform with Checkbox value, How to return to Checkbox value in Winword
- [SOLVED:] How to use an Array instead of a Loop to clear contents of blank cells? - Speed Issue
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.