PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 [152] 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173

  1. organize data in groups with near equal Totals
  2. [SOLVED:] Combine multiple DIMs into one line instead of separate?
  3. [SOLVED:] [Microsoft][ODBC Driver Manager] Data source name too long
  4. Print Documents Using File Path
  5. Filtering dates
  6. Insert Excel Ranges in PowerPoint
  7. User Form Assistance
  8. Macro to send e-mail for different recipients with different messages
  9. [SOLVED:] Array Step by 50 - Loop Incremental
  10. [SOLVED:] Delete Rows Not Containing Array Term
  11. [SOLVED:] Help With Coding Structure
  12. Need to copy Some part of outlook mail body into excel through vba
  13. [SOLVED:] Replace Exact String - Array
  14. List Box - Scroll Bar movement creating a ghost image of the ActiveX List Box
  15. [SOLVED:] Userform Assist - commandbutton to add multiple textbox
  16. OLAP Pivot Table - Variable number of filters
  17. [SOLVED:] WorkSheets in an Array - Copy From
  18. Send Mail VBA LOTUS NOTES
  19. Textbox search conditionally
  20. CLEARCONTENTS OF CELLS WHEN OTHER CELL VALUE IS DELETED
  21. [SOLVED:] Going through a range (Looping?)
  22. UserForm webBrowser ctl: how to detect 'no web page found' for a defective url?
  23. Merge 2 Excel Worksheets together
  24. Integrating Calendar with WorkSheet and UserForm
  25. Close Open Text File - No Save Prompts
  26. time to decimal format
  27. [SOLVED:] Text to columns for every character in text file
  28. [SOLVED:] Transpose Selected Cells Containing Specific Value
  29. [SOLVED:] Macro to Print Worksheets Containing Specific Data
  30. Code to copy the active WS before a specific WS in the WB
  31. countifs column with date
  32. VGA code to list files attributes and also arranged them with filter using buttons
  33. Want to fill data from Excel in to specific Form for Print Lable.
  34. [SOLVED:] Trying to Create a Remove Last Button
  35. [SOLVED:] Can you keep a connection to a DB open?
  36. Hit button and download file using excel vba on web page
  37. [SOLVED:] Highlight Offset Consecutive Column Cells
  38. [SOLVED:] Userform focus causes document in opposite window to minimize - Dual Monitors
  39. [SOLVED:] Subscript Size
  40. PDF2XL
  41. INDIRECT with Data Validation for a 3D formula
  42. For Each inside another loop works only once after excel startup
  43. Excel-Visual Basic UserForm Coding
  44. Referencing Classes ByRef vs ByVal
  45. Check for headers in Excel
  46. work hours with lunch break
  47. reformuler un tableau ce forme dans rapport Excel
  48. exportasfixed format specific range not working
  49. Delete table rows where a cell in D contains certain numbers
  50. Refresh DB Connection Programatically
  51. Changing Vlookup to variable depending on search results? idk
  52. [SOLVED:] Variable Not Defined Error
  53. [SOLVED:] Transpose date from column name
  54. Create outlook reminder from excel
  55. Help with macro filter sequencing
  56. Excel sending email format
  57. [SOLVED:] DATE and TIME FORMATTING in Office 2007
  58. Web scraping
  59. I need the cursor to go to the last non-zero in column C
  60. Treeview not loaded in userform
  61. [SOLVED:] Worksheet.Evaluate to Formulae
  62. Vba Need Dice Continue Rolling?
  63. [SOLVED:] Generating new ID VBA code
  64. [SOLVED:] ListBox - Population - Load For Each Worksheet
  65. [SOLVED:] update a table between two Excels files with a condition
  66. [SLEEPER:] Upload File with winscp and sftp
  67. Select Listbox Item by ComboBox Item
  68. [SOLVED:] Add a link button dynamically in 1 cell of each row
  69. How to use buttons on userform
  70. search a column of keywords in a folder of .docs and match file names and string
  71. Chart - Excel 2013 - Series Highlight on Label mouse over
  72. [SOLVED:] Simple Macro Help
  73. Changing an Excel Userform does not work
  74. Updating database using userform dependent combobox selection
  75. Sleeper: How to save as with fixed name and server location ?
  76. Open PDF in WebBrowswer Control on Userform
  77. Filter by named range in closed file
  78. [SOLVED:] For loop inside IF statement
  79. Link spreadsheets
  80. [SOLVED:] Making VBA userform, ChangeButton does not work
  81. [SOLVED:] Calling Textboxes created in runtime with a form how to reference in a loop
  82. Vba Macro in Excel for exporting multiples files in Word with prompt
  83. Advanced Filter Help
  84. Explain Formula
  85. [SOLVED:] LEFT Function to retain first 10 characters of cells with VBA
  86. VBA to use a variable filename
  87. [SOLVED:] CDR CVS help needed
  88. If Value is >= 1 Take header and insert into row
  89. VBA Powerpoint formating
  90. [SOLVED:] Struggling to apportion value 'dynamically' - Worksheet attached
  91. [SOLVED:] Transpose Excel data from rows to columns
  92. [SOLVED:] VBE Editor Select Module
  93. [SOLVED:] VBA Macro Stops at line 986
  94. To search a column in a database and to return all the entries found
  95. Disable Sort In Shared Workbook
  96. [SOLVED:] Offset in an Array - Replacement
  97. Conditional VBA for Combinations
  98. [SOLVED:] Runtime error 1004
  99. [SOLVED:] Tab delimited text file issue
  100. Montly, Weekly, Daily Attendance
  101. Sleeper: New line in formula & Join Text
  102. Automatic numbering up, with two matches
  103. Newton's Method Iteration Code in VBA- No errors but will not output
  104. TOC macro to skip displaying hidden sheets
  105. Email and HTML
  106. [SOLVED:] Editing the contents of a Match Index Cell through VBA
  107. INSERT OVERWRITE INTO correct syntax?
  108. Available Procedures in COM add-in
  109. excel formula and vba automation help
  110. Speedup VBA
  111. [SOLVED:] NEED HELP RESCTRUCTURING MACRO TO FIT MY WORK SHEET, PLEASE.
  112. Problems with simple counter
  113. [SOLVED:] VBA Copy and Paste data form one workbook to another.. Problem is data change every w
  114. Stuck on VLOOKUP VBA using variables
  115. callback for Application.Run
  116. Issue with sending the active workbook & printscreen via Lotus Notes
  117. [SOLVED:] Cell with multiple lines of data , delete lines without # into one line
  118. [SOLVED:] Issues with Arrays and DLLs
  119. Embedded objects in Excel
  120. [SOLVED:] Converting a string by detecting Chr(183)
  121. How can remove " after do replace in beginning and end of cell
  122. Internal Hyperlinks in Pivot Tables
  123. [SOLVED:] Compare dates - password required if expired
  124. [SOLVED:] Help with an array formula
  125. [SOLVED:] Using a variable to call either a form or a sheet
  126. VBA, i want the value, not the formula
  127. Getting VBA to decide which cell to use
  128. Need help with my macro "Sub or function not defined"
  129. How do i extract a part of text file content
  130. UserForm Retrieve Data From Correct Sheet, based on Combo Box Value
  131. [SOLVED:] Find a cell in a range based on a condition & change the value of the cell beneath
  132. VBA code for Autofit row height for rows with merged and unmerged/normal cells
  133. Toggle SUM/AVG on Pivot Table
  134. [SOLVED:] Enable and disable calculations for a range of cells
  135. Userform - Different rights for differenz users
  136. copy email body to excel
  137. xlDown not returning last used cell
  138. [SOLVED:] Remove lines with no entries and copy back some data
  139. [SOLVED:] VBA Unprotect not working properly
  140. Print from Image Object in Sheet using VBA (range of print changed when filter table)
  141. [SOLVED:] how to create a excel macro (button) that will show next number from a list?
  142. Loop Thru Cells
  143. Comparing Data Across Sheets, with Multiple Variables
  144. [SOLVED:] Count_Colours_Not_Duplicate
  145. [SOLVED:] Copy and paste row of data to another worksheet macro
  146. Find a last row and insert a values
  147. [SOLVED:] Multiple Consecutive Line Feeds Using vbCrLf
  148. Using Macro to Pull in New Data Every Month
  149. [SOLVED:] Merging two Private Sub
  150. Invoice date help
  151. [SOLVED:] Very simple problem with no solution found
  152. Username to populate
  153. Replace functions with hard values
  154. Change color of cell/cells
  155. checkbox in excel
  156. [SOLVED:] Help with Offset and r Resize formulas to select a range.
  157. Excel macro to fill web form using excel data
  158. Excel VBA macro to fill web form using excel data
  159. Import CSV File to Workbook
  160. [SOLVED:] Extracting Dates
  161. VBA Power Analysis Macro help
  162. Automatically copy certain cells from rows from one Worksheet into another Worksheet
  163. [SOLVED:] Automatically filter selected worksheets by date criteria
  164. VBA - Help me to solve this one, makro who can select between 3 sheets
  165. collection / array help
  166. Excel VBA performance variance issue
  167. Sleeper: VBA & IE Form
  168. [SOLVED:] VBA to extract data from WebPages
  169. [SOLVED:] Run code on each cell until month changes
  170. Sorting Issues
  171. Linest() <> Chart Trendline Formula
  172. Deleting specific cells when a condition is no longer met
  173. [SOLVED:] Script to loop match initial search term in data column to find the value of cell bel
  174. Convert PDF data into Excel or txt using VBA
  175. [SOLVED:] Concatenate cells with leading zeros vba
  176. Move data from sheet 1 to 2
  177. [SOLVED:] EXCEL (macro) - Analysis of hourly intervals from sectional graph, correlation
  178. Help Logging into Website with VBA
  179. function keys open wrong dialog
  180. Switch case not giving desired product
  181. Change from Internet Explore to Google Chrome
  182. Excel Date formatting issue
  183. Delete by Dates
  184. [SOLVED:] dblclick cell text cursor blinking
  185. VBA Column comparison against sheet and viceversa
  186. Manipulate 2 different columns to become one
  187. Deleting Data from Database using VBA
  188. Class Does not suppor automation or does not support expected interface
  189. Time stamp in a fixed cell when content of specific cells in row are changed
  190. VBA Macros Copy Paste Seed Up Help
  191. Ink Signature to cell
  192. Populate Form Label Captions from Worksheet
  193. Help w/Offset Paste
  194. IF function in VBA - Can't COPY
  195. [SOLVED:] Open Folder with Comma and Ampersand in Name
  196. Pivot Table not updating after Cut and Pasting Values to Data WS
  197. [SOLVED:] VBA outlook
  198. First VBA project summary file please help
  199. CopyRow help for multiple tabs
  200. Repeat code for each row
  201. [SOLVED:] Copying only values in VBA
  202. When changing Row B in Sheet 2 automatically do sorting with Row B in Sheet 1
  203. Copying certain rows of worksheet into new worksheet depending on date
  204. [SOLVED:] Break text
  205. VBA Userform Precedence
  206. Transferring Userform data to excel
  207. Hyperlink function reference multiple cells?
  208. vba consolidation of specific sheets data and Pasting in specific Mater sheets
  209. Excel VBA IMAGE help!
  210. [SOLVED:] Transferring data to a summary spreadsheet
  211. SUM for a dynamic table
  212. Convert Userform with a scrollbar into pdf
  213. Excel 2016 .CopyPicture
  214. VBA-Extract only number from a string
  215. Best method to check range completion before running rest of program.
  216. [SOLVED:] Worksheet collections in formula?
  217. VBA too long-winded help needed.
  218. Ifnumber & Search with mulitple Conditions
  219. [SOLVED:] vba help on declaring varible
  220. [SOLVED:] Copy certain worksheets from one workbook to another while keeping format
  221. API Help Needed
  222. [SOLVED:] Copy a single field from Access to Excel
  223. [SOLVED:] Copy data from rows to other worksheets
  224. VBA - Email notification when job added to list.
  225. Copy formula/row range down to a value specified by another cell?
  226. [SOLVED:] Fill Userform Text Box From Worksheet
  227. Data transfer depending on the empty cells
  228. Getting a Macro in Power Point to skip update if and excel sheet is open
  229. [SOLVED:] Excel Code Help, Loop related
  230. Update Another Sheet with Results of Formula w/Multiple Criteria
  231. File properties using FSO and Dir
  232. Product List Search Function
  233. Create Power point presentation from multiple excel files
  234. [SOLVED:] Align List Boxes On User Form Using a Loop
  235. Sumif from pivot table
  236. [SOLVED:] Add Unequal Amount of Data To Two Columns of UserForm List Box
  237. Filter quantity of the commodity code from total data and minus decesing ???
  238. [SOLVED:] Inputbox with date used as European style
  239. [SOLVED:] Toggle "select objects" instead of cells ??
  240. Copying two ranges and transposing one of them
  241. Problem With Macro
  242. Automatic Refresh causing paste issues
  243. Userfom to count items and show clicks and percentage vs target
  244. Vba Code to open multiple files from a specific directory
  245. Form showing odd sizes
  246. How to consolidate data from multiple sheets into a master excel
  247. Index/Return cell references from table array based on "Yes"/"No" response
  248. [SOLVED:] Wrong result of my macro!
  249. VBA Combobox for vlookup
  250. [SOLVED:] loop through files in a folder based on a condition