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. [SOLVED:] Issue with AVERAGEIF
  2. [SOLVED:] How can I run VBA Worksheet_BeforeDoubleClick on a (new) daily extract.csv
  3. Save Specific Protected Sheets to a new Workbook
  4. [SOLVED:] Help with Dynamic UserForm in Excel
  5. Macro to concatenate cells into a single cell multiple times
  6. Convert to For Next loop
  7. [SOLVED:] LastRow from a specific Cell
  8. VBA Help
  9. Put linear trendline equation into cell
  10. Problem about sort horizontal with Function.
  11. Problem about Loop through files sort by Date.
  12. Logit VBA Debugging
  13. [SOLVED:] Hide Column Target Cell Clicked - From a List
  14. Checking For Commands From Central Server
  15. Outlook Calendar In Excel
  16. [SOLVED:] Auto Save Excel File as PDF
  17. Email Range Of Cells
  18. [SOLVED:] Show/Hide a Textbox Based on Value of a Combo Box in a USerform
  19. Sum with weeknumbers of a given date
  20. [SOLVED:] Loop through sheets based on cell contents
  21. operations copy and paste file from Adobe Reader
  22. How To Copy just the value in Excel.
  23. Search data in 4 Contiguous cells within a selected area
  24. Amending Code To Reference value (Email address) In Cell
  25. Can I "cancel" Workbook_WindowDeactivate?
  26. [SOLVED:] For If Statement with Two Ranges
  27. convert column to matrix
  28. Hyperlink With Special Characters
  29. Cycling through sheets with loop
  30. Help adding font size / color / etc to my macro
  31. [SOLVED:] How to Combine a Save As PDF macro and an E-Mail send macro???
  32. Problem about function reference
  33. How To Copy excel to powerpoint
  34. How select next blank cell in row and add timestap
  35. SAVEAS with location
  36. Delete all AllowEditRanges in workbook
  37. Copying cells from worksheet that varies in cell range and number of pages.
  38. [SOLVED:] Automatically Update TextBox on Other Sheet
  39. Match to master
  40. Delete Entire Row Based on a Selection
  41. Run time error 429 - ActiveX component can't create object.
  42. Information about Transferring Data In Excel.
  43. Problem about a variable value In excel.
  44. Chart - Plot has different size
  45. Out of Memory error on close tries to open protected VBA
  46. Search List, Find Sheet, Return Value
  47. Autofill Across Columns with "Centered Across Formatted (3 Columns)" Quarterly Dates
  48. [SOLVED:] Please Help me
  49. Search for postcodes in a PDF document and list them in a excel worksheet
  50. Open all pdf one by one from a folder using followhyperlink
  51. Questions about conditions in excel function.
  52. Need help of members with spreadsheet allows users to manipulate.
  53. Macro for executing commands from cmd prompt
  54. Macro to count repeat occurrences from closed WB and paste total counts in new WB
  55. Adapt macro that copies excel to ppt
  56. Sleeper: Open Hyperlink File From Cell - Follow Hyperlink
  57. [SOLVED:] CheckBox on UserForm to show Full list or Part list according to Criteria
  58. VBA Coding to send a common email to different email addresses based on cell values
  59. Issues about source in excel 2010.
  60. Question about create Macro manage information.
  61. Use WinHttpRequest#responseStream for SOAP Request
  62. When Limit has reached in Excel, send to Sheet2
  63. loop, vba
  64. Insert Excel cell range in Shell command
  65. Insert row automatically?
  66. add payment button vba code
  67. Exit User Form Button
  68. Find duplicates with VBA
  69. Copying multiple ranges to Word
  70. [SOLVED:] Initialize modeless FYI Userform but focus never leaves sheet
  71. Download from FTP
  72. Saving to different folders based on part numbers in B1
  73. [SOLVED:] Help with VBA password in commanduttons
  74. [SOLVED:] INDIRECT Row Reference and Increments
  75. ie.navigate to follow links from A1 to A2000
  76. VBA an MSGBOX
  77. VBA Multiple Attachments
  78. Pasting excel tables one after the other from excel into a word document
  79. Meaning of iLastColumn = .Column + .MergeArea.Columns.Count - 1
  80. Excel VBA Database
  81. Macro: Sheet 1 populates Sheets 2 & 3 with unique records only. (stuck)
  82. Sleeper: VBA to group matching data and copy for printing
  83. Problems Initiating a User Defined Function UDF - Using Application.caller.row
  84. How to login with vba
  85. Can't select and activate cells during BeforePrint event
  86. VBA code to Copy/Insert + Delete rows by criteria
  87. VBA: Apply loop to existing code
  88. Save Worksheet as PDF and Attach in Outlook
  89. Extract data from LinkedIn
  90. All VBA Code Stopped Working
  91. Error 53 "file not found"
  92. [SOLVED:] Help to create a date range chart based on a date wthin the data
  93. Copy and rename files without overwriting files
  94. From Sheet.add to Workbook add method
  95. Multi-choice of the listbox to many controls(textbox)
  96. VBA Simple Code Help (Formatting FDM)
  97. [SOLVED:] Problems using ComboBox
  98. Looking for help with VBA code please?
  99. Gantt Chart
  100. [SOLVED:] Need VBA code for Copy+insert / Delete rows & columns by criteria
  101. Code guidance please
  102. Sort All Sheets In Workbook
  103. [SOLVED:] Individually generate email content and attached all files from folder based on cell
  104. [SOLVED:] Copy first 5 characters of Course Name to Column A
  105. VBA code to rename folders
  106. Unable to read last line from VBA plink stdout
  107. [SOLVED:] Set Variable of column number to Multicolumn ListBox
  108. Sleeper: Copy Paste as Values & Save as new sheet
  109. Copy Missing Data to Main Worksheet.
  110. [SOLVED:] Sorting Sheets in a specific order
  111. [SLEEPER:] Populating checked items in worksheet1 to worksheet2
  112. VBA Checkbox buttons
  113. HTML click not consistently working
  114. Passing Data from UserForm to Sheet makes excel to crash (Why?)
  115. Auto-resize Shape_width
  116. Loop through Vlookup
  117. [SOLVED:] Using Workbook from FilePicker
  118. Sleeper: Help with combining these macro snippets?
  119. Need VBA Code to close userform
  120. VBA Command button
  121. Excel File-1 copy the value & compare with Excel File-2 and Save it in Excel File-1 ?
  122. Pivot > Showall data in rows field
  123. [SOLVED:] Fix calculation of minimum date
  124. [SOLVED:] Hide rows between 2 strings
  125. Open Images Folder Mac OSX
  126. Workbook Password Protect
  127. Need help with a VBA code for distributing data
  128. Validation Tool- Lookup for Mis-Match and send email out
  129. Why data labels gone when i paste the chart to other workbook and change the range?
  130. Copy select data on USERFORM
  131. [SOLVED:] Combo box filtering?
  132. [SOLVED:] Send attachment via outlook
  133. Macro to conditionally insert rows not functioning as intended
  134. [SOLVED:] UDF to convert column Letter to Number and return the Largest column as Number
  135. [SOLVED:] Match two rows using VBA
  136. [SOLVED:] Require VBA Macro logic for Multiple ID and Matching Columns data.
  137. Stock Length Calculator
  138. Copy select data to different column
  139. Copy line by index number and past in another worksheet
  140. Embed an "open file" dialogue box to userform, Excel 64 bit version
  141. VB script to filter and update value in different sheet
  142. Generate random values between two number and specific string
  143. Hitro Macors
  144. Match two rows across various columns using VBA
  145. Stopping or breaking userform or code causes VBA to flip through all userforms
  146. [SOLVED:] How to check whether Cells contains specific number?
  147. Resetting Dropdown list in all sheets (Excel Workbook)
  148. Hyperlink Issue
  149. Convert Vlookup to VBA
  150. How to conjuct all the excel value into one cell?
  151. [SOLVED:] How to get Last Digit from Text
  152. Copy data from one sheet to another based on a certain criteria
  153. [SOLVED:] Identify column header name based on a colored cell
  154. VBA Express Certification?
  155. Trying to extract all data from word docs into excel docs
  156. [SOLVED:] Run-time error 91
  157. [SOLVED:] Match and Vlookup method
  158. Google map Travel Planner #1
  159. [SOLVED:] Left Right Function Help
  160. Can VBA be used to search a folder of .docx's for text strings and copypaste to Excel
  161. Codigo VBA para fecha matar o arquivo temporário.
  162. Delete rows except the last one with same numerical value
  163. [SOLVED:] Code to match to cells using a mapping
  164. [SOLVED:] Unhide Worksheet on Selection of Cell
  165. [SOLVED:] Trouble using selected range to define a for loop
  166. [SOLVED:] On Open: "This action will reset your project, proceed anyway?"
  167. [SOLVED:] Macro to create list of hyperlinks to all files in chosen folder including subfolders
  168. [SOLVED:] Remove Apostrophe from string
  169. [SOLVED:] Add shape only if shape doesn't already exist
  170. SUMPRODUCT in VBA
  171. Ping tester in Excal
  172. Run-time error '462': The remote server machine does not exist or is unavailable
  173. Help me insert subtotals on I:L my vba code below. It sorts and insets a blank row
  174. Data Formating - Macro to copy header row and paste to multiple columns.
  175. [SOLVED:] Assign Shape Macros - From List
  176. Need help with this macro to have it work with Alpha Numeric data
  177. [SOLVED:] VBA to create a mapping
  178. Group Shapes Rename Them - Loop Through Worksheets
  179. [SOLVED:] Find and replace
  180. [SOLVED:] Find Text Within A String
  181. "MSACCESS.EXE" process issue - How to terminate this process correctly
  182. VBA code disaappeared.
  183. [SOLVED:] Forms 2.0 library
  184. [SOLVED:] Conditional Compile Question
  185. Open workbook with dynamic filename
  186. Concat date and time in one cell
  187. [SOLVED:] Find a Value in a Cell and Delete some of the text
  188. Adding Code to Workbook_BeforeOpen
  189. Open multiple password protected workbooks in a folder
  190. [SOLVED:] Split files and attach them to an email
  191. Create multidimensional array from several non adjacent table columns
  192. Problem in Executing the Code
  193. The BIG DATA Challenge - Match cells on BIG DATA Sheet (LOOP take 4 Hrs !)
  194. Copy Leading Numeric Values, then Remove
  195. Update data entry for all future months (not a single month)
  196. Logging other PC programs via VBA excel
  197. Drag Drop Reorder part of Row .. Excel
  198. Help me to correct the vba
  199. trying to finish my vbaproject barcodescanner
  200. Syntax for Evaluate SumProduct in VBA
  201. [SOLVED:] trying to pull dynamic webquery data
  202. Make userform stay on top of all windows when macro is fired
  203. VBA: Help me write a code in vba
  204. Formula working wrong, I can't identify why.
  205. Copy and pasting time calculations
  206. Email alert not firing with VBA even though the condition is satisfied.
  207. Learning VBA Variables
  208. Random Sequencing
  209. Rename Current PDF file name using Excel Sheet List
  210. [SOLVED:] Search with Criteria on Userform
  211. i want to validate users entered value with existing range in another sheet
  212. [SOLVED:] Add 1 row below a selected cell using a user input box
  213. VBA help to convert unstructure data to structured data
  214. Data Validation
  215. [SOLVED:] Exporting Worksheet Code Modules - Export Code As Worksheet Name
  216. [SOLVED:] Looping For Duplicates In 2 Dynamic Columns (Odd Issue)
  217. [SOLVED:] Returning Description Based on Field Value
  218. [SOLVED:] Why is "1D050" numeric?
  219. [SOLVED:] Need Help constructing a vba counts rows between data and. Please
  220. create workbooks based on a given template using data in a table
  221. how do I save as .xlsx using xcell compiler
  222. [SOLVED:] SPLIT STRING issue with array if element not found
  223. Loop for certain text in cell - delete cells and shift up
  224. avoid iterations
  225. Help with duplicate matches when using Index(Match(
  226. Sum if Index Match with multiple criteria
  227. Copy down text in columns until next part number - VBA Code
  228. [SOLVED:] Declared Variable not selecting the correct range
  229. Need help reconstructing macros on this file in my description please!!!
  230. VBA code to sort, compare, and line up two lists of data.
  231. [SOLVED:] Delete any row which does not have any cells which are conditionally formatted
  232. obtain distinct rows based on three columns
  233. [SOLVED:] Start Loop Rows From - Row 10 on wards - Listing Files
  234. VBA ONE TO ONE AND MANY HIGHLIGHTED
  235. hide and protected sheet macro not working
  236. [SOLVED:] VBA - Extracting 3 Text Lines From Text files
  237. Removing duplicates from multiple columns
  238. Help VBA using excel function help
  239. Vba help for a lookup table
  240. [SOLVED:] QR-reader to Excel (with time stamp)
  241. Multiple column select in VBA
  242. [SOLVED:] Combining two sets of data into one - vlookup, comparing part numbers - advanced VBA
  243. Data validation
  244. Retrieve value based on selection
  245. Select Case Function on a CommandButton/ToggleButton
  246. Merging columns
  247. Moved: VBA: Picture in Word-Header? Position?
  248. VBA Paste As Values
  249. Toggle to Hide Rows
  250. Matching multiple values from different column